Flookup is a Google Sheets add-on that uses the power of fuzzy matching for data cleaning. It can process data in the following ways, regardless of spelling differences, partial matches or any other text-based differences in your data:

Highlight and remove duplicates. Fuzzy lookup or fuzzy match data a.k.a record linkage. Extract unique values from fuzzy duplicates. Analyse percentage similarities between text entries. Remove unwanted words, diacritics and punctuation marks.