Fuzzy Duplicate Finder is a tool for Microsoft Excel that helps you find and correct similar records. The add-in quickly performs approximate match according to the settings you select and changes all typos into the correct equivalents of your choice.
Open the add-in pane by clicking on the Find Fuzzy Duplicates icon in the Duplicate Remover drop-down list on the Ablebits Data tab, Dedupe group:
This tool is also available in the Search group on the Ablebits Tools tab: in the Find and Replace drop-down list, click Search for Typos:
There are some settings that you need to tweak to get more precise results:
Click the Search for typos button and the add-in will perform approximate matching in Excel. All found items will be grouped by duplicates (nodes) in the tool's tree view:
If you have several correct values in your node that differ in case, you may want to keep their original case or make them all look the same.
Tick the Keep case of the same values in the node option at the top to leave the items that differ only in case unchanged.
So, if you have "Street, street, street, and Streett" in the results and you consider only the value as a misprint, not the case, then select this option and the "street" value will keep its case.
If you want to remove an entry from the list of found duplicates, just select it and press the Delete button on your keyboard. Or, you can select several items by holding the Ctrl key and delete them all at once.
You can remove similar data from your Excel worksheet if necessary. Just click on the value you want to delete in the list of found items. The cell with this value will be automatically highlighted in Excel worksheet, so you can select it in your table and press the Delete button on your keyboard.
To see the found similar records in a separate Excel worksheet, click the Export button on the Fuzzy Duplicate Finder pane.
This option may be helpful if you want to see the changes in the nodes before applying them.
To do a new fuzzy match, click New Search at the top of the Fuzzy Duplicate Finder pane.
Please contact us here