How to identify similar names in one column without a comparative names list

[Cscalera]

Hello Forum users,

I have an Excel database containing in one column hundreds of names with misspellings of all sorts. The problem is that I do not have a list of the correct names. Therefore, I need to identify all those names with a similar spelling, and have them grouped by index rate of similarity, in order to fix them manually later based on the biggest number of name string occurrences. Thank you in advance

EXAMPLE CURRENT MIXED UP LIST Mario Rossi Rossi Mario Mario Rosi Marrio Rosi Mario rossi Gino Bianchi Bianchi Gino Gino bianci Gino Rossi Ginno Banci Mario Rossi Rossi Mario Mario Rosi Marrio Rosi Mario rossi Gino bianci Gino Rossi Ginno Banci Mario Rossi Mario Rossi Rossi Mario Gino Bianchi Bianchi Gino

 

[GraH]

https://www.google.com/url?sa=t&source=web&rct=j&url=https://www.mrexcel.com/board/threads/levenshtein-distance-string-transposition.1101258/&ved=2ahUKEwiB25rl3N_4AhWZD-wKHY0PBjQQFnoECAYQAQ&usg=AOvVaw0VdWJbYgxqYj-4Y-NFtedt

 

[GraH]

Or Power Query using fuzzy match might work. If you have it in your excel version available that is.