How to match fuzzy duplicates in one column

[rnordgr]

I have some data in a single column, this data contains titles. Some of the titles are exact matches but others have the same words but just in a different order. Is there a way to find the fuzzy duplicates within a single column?

 

[Ruddles]

You'll probably have to do this with VBA, maybe via a User Defined Function. If they're the exact same words, you could convert each title into a string containing all the letters from the title in alphabetical order, then compare those. For example, if you have "Tiger boat" and "Boat tiger", each of those would result in "abegiortt" and they'd match.

Am I making sense?

 

[rnordgr]

Yeah. I had to convert each title into a alphabetized text string and then compare but it worked just fine. Thanks for the suggestions.