Find Fuzzy Matches for Google Sheets
Identify and correct misprints in your spreadsheet
If the task of unifying your data ever crops up in your sheet, get this add-on to handle it easily. The tool compares all words from the sheet for similarities and differences and prepares a list of all fuzzy duplicates grouped by record for you. Mark a correct word and change all similar misspelled words in a click or export search results to a new sheet.
With Find Fuzzy Matches you will
How to smart-search for typos in Google Sheets
Frequently asked questions
Otherwise, our add-on can become your best assistant for the task.
2. Specify how many chars may differ in your words.
3. Identify the minimum number of total chars in a word/cell.
4. If cells contain separate words, turn the corresponding setting on and specify the delimiter.
5. Hit Search for typos.
2. To export the misspellings, click Export right away.