Find partial duplicates in Google Sheets

Find Fuzzy Matches is a smart tool that will help you group and correct all typos you have in your Google spreadsheet.

How to use Find Fuzzy Matches

Start the add-on

First, select the column with records that may contain typos.

Tip. You can change the range for the search any time before you click Search for typos. Simply select the necessary cells in your sheet.

Then, open the tool by going to Add-ons > Find Fuzzy Matches > Start in the Google Sheets menu:
Open Find Fuzzy Matches from the menu.

Adjust the search settings to set aside the values that you don't need to see in the results:
 Narrow down typo search settings.

  1. Use the Max number of different characters field to choose how many characters can differ in your records and to narrow down your results.
    Tip. The fewer characters you enter, the more exact search results you will get.
  2. If you're searching in columns that contain several words in one cell, e.g. street address and city, you can look at each word individually by ticking off The cells contain separate words delimited by.
    Tip. Enter all possible delimiters that separate your words in the Delimiters field or pick them from the add-on's drop-down:
    Check the delimiters used in your cells.
  3. To exclude short words from the search, set the Min number of characters in a word/cell. This will make the add-on search only in words that are at least this long.

When everything's set and you're ready, click Search for typos to work with the results.

Get the results

You will see all the found typos grouped by value. Click on a record to see where it's on your sheet, or use the cell address column to see what it refers to:
See the typos grouped by values.

How to manage the results

Correct typos

  1. If you see the correct value for the group, simply click on the check mark in the Action column to set it as the right one for other records in the node:
    Apply the correct value to other nodes within the group.

    Tip. If your search results are case sensitive, take advantage of the option Keep case of the correct values. It will let you change the listed value but keep its original case. Unselect this check box to change both the case and the value:
    Apply only value changes or update the case as well.
  2. If all values in the group are incorrect, you can enter the right word in the field next to the root node and press Enter on your keyboard:
    Enter and apply the correct value to other nodes in the group.

    Tip. You can also click on the check mark in the Action column to apply the entered word as correct.
  3. If you see a record listed in a group by mistake, remove this item by clicking on the Delete icon next to it:
    Delete value from the group.
  4. Once you finish correcting the found values, you can apply all changes you made to your sheet by clicking on the Apply button:
    Apply the changes to your sheet.
  5. Cancel changes

    If you notice any errors before you close the add-on, you can revert back to the work mode by clicking the Undo button. The add-on will keep all your changes, so you could quickly correct any mistakes.

    Export results

    If you want to keep the search results for a record or take a closer look, you can export them to a new sheet by clicking on the Export button at the bottom of the sidebar.

    To run a new lookup with other search settings, click the New search button at the very top of the add-on.

Ask a question

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.