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

Complete support 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:

19.95
Buy now

See how Fuzzy Duplicate Finder can help you

You can view the video in the fullscreen mode by clicking fullscreen icon

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

Free Download
Free 15-day trial version, 9/8/2014

Fuzzy Duplicate Finder for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 2.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

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Fuzzy Duplicate Finder version

Current add-in version: 4.2.6
published on: Sep 08, 2014

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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
Awesome!!!
Sheila Blanchard