I have search keywords in one of my database table. These are the keywords searched by users on a website. My requirement is to find the top 100 search keywords after consolidating various similar search keywords.
e.g. COVID19, Covid 19, Corona, Corona virus, covid-19 are all related to corona and it should be grouped under Corona.
blockchain, BLOCKCHAIN, Blockchain business, B L O C K C H A I N are all related to Blockchain so it should be grouped under Blockchain category.
I tried to do this using fuzzywuzzy python library but fuzzywuzzy needs a list to be compared with the search keywords. And unfortunately I don't have that list because it can be anything based on user's search.
Any suggestions on the approach would really help.