I’ve used Tableau Prep Builder before, and it had an option that would allow it to algorithmically “fix” some of my data. I could also pretty easily sort this through a UI and "select’ which members belong to each grouping.
I have a list of names that have some minor misspellings, but should be grouped together. Here’s some examples.
Anxsia
Anxsia
Anyisa
Anysia
Anysia
Britney
Brittany
Brittany
Brittany C.
Brittany c.
Brittney
Brittney C.
Chrisitian
Christen
Christian
Christian
Christin
Christin
Christin H
Christin/Brianna
Christin/Ron