Fuzzy Duplicate Finder for Microsoft Excel

Search similar records in Excel, fuzzy lookup and match

If you have worksheets and workbooks with similar records that differ in one or a few characters, use Fuzzy Duplicate Finder to quickly solve a fuzzy match problem in Excel.

  • Find similar data that differ in 1 to 10 characters
  • See all fuzzy matches at a glance organized by duplicate groups
  • Export search results for reviewing or correcting them

Free download for:

Search for similar records in Excel with Fuzzy Duplicate Finder

Lookup fuzzy dupes in Excel

Fuzzy matches are grouped by duplicate nodes

Fuzzy Duplicate Finder provides a number of options to perform a fuzzy match in Excel. It lets you tweak the search process depending on your particular type of data and your needs:

  • You can search for similar records in the whole list, column or a selected range.
  • You can split data in each cell into words to look up and match words separately. This is very convenient when, for instance, you are working with a list of addresses that are not divided into different columns but each address is written in one cell. When you tick this option, the Fuzzy Duplicate Finder add-in will process the names of streets, cities and countries separately and pinpoint all possible fuzzy matches that may be there, even if they differ just in one symbol like st. and str. With this option, you can specify any delimiter, e.g. space or comma.
  • You can exclude from search cells or words with fewer than the specified number of characters, e.g. if you are working with a list of names, you will most likely want to omit salutations and courtesy titles like Dr., Mr., Ms. etc.
  • You can choose to correct the same values written in a different case, e.g. Outlook, outlook, OUTLOOK, or keep them as they are.
  • And finally, you can export found data to another worksheet for comfortable reviewing.
Note. If your task is to search similar records in Excel, Fuzzy Duplicate Finder will do the job perfectly. This add-in is purposed for finding partial duplicates, i.e. fuzzy Excel matches that differ in one or several symbols.

If you want to find exact duplicates, please use Duplicate Remover for Excel.

How to find and remove all typos in your workbooks

With Fuzzy Duplicate Finder you can quickly find all sorts of similar values, typos and misspelled words. You just specify the number of different characters for a particular search, from 1 to 10, and our fuzzy lookup add-in finds all approximate matches in your Excel spreadsheets, whether they have omitted, excess or mistyped symbols.

The found results are displayed in the neat pane, which can be located in the left or right part of your workbook, whichever is more comfortable for you. You see all found fuzzy matches in Excel at a glance organized by duplicate groups.

Search for similar records in Excel

  1. Open the Duplicate Finder pane by clicking on the add-in's icon.
  2. If you are searching for similar data (fuzzy duplicates) in a single column, place a cursor on any cell of that column. To look up within several columns or a range of cells, just select them.
  3. Specify the maximum number of different characters, from 1 to 10.
  4. If you want to exclude short words or numbers from search, use the Exclude cells /words with fewer than option to specify the minimum number of characters.
  5. Finally, you decide whether you want to handle the content of each cell as a whole, or split it into separate words and have each word processed individually. If the latter, just check the Split cell data into words option.
  6. Click "Search for Typos" button.

The add-in quickly produces a list of possible fuzzy matches grouped by duplicate nodes.

Correct fuzzy duplicates

Fuzzy lookup returned the matches and you have a list of similar records found in your Excel 2010 worksheets. Now you only need to look through the errata to decide which dupes to delete, which ones to correct and which to keep. When you click on any found value in the Duplicate Finder pane, the corresponding cell in your worksheet gets selected automatically so that you can see where this entry is actually located.

You can choose to correct all similar data in a node at once, correct only some of them or just one record. Please see our online help for detailed step-by-step instructions:

How to find partial duplicates in Excel (fuzzy match)

Fuzzy Duplicate Finder screenshots

Fuzzy matches in Excel are grouped by duplicate nodes

Fuzzy matches are grouped by duplicate nodes

Set the correct value to similar records in 2 clicks

Set the correct value to similar records in 2 clicks

You can enter the correct value

You can enter the correct value

Export the found data to a new workbook

Export the found similar records to a new workbook

This add-in comes as part of Ultimate Suite - 60+ professional tools for Microsoft Excel

Download and try Ultimate Suite without any limitations for 14 days.

Free Download
Free 14-day trial version, 13 MB

System requirements:

Microsoft Excel

  • Microsoft Excel 2016 (32- and 64-bit)
  • Desktop Excel included in Office 365
  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Featured customers

Ablebits.com featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools - Ablebits.com