- Home
- Products
- Ultimate Suite for Excel
- Fuzzy Duplicate Finder
Check for similar records and fuzzy matches
Quick way to perform fuzzy lookup in Excel
Use Fuzzy Duplicate Finder to find and fix typos and misprints in your Excel files. The add-in searches for partial duplicates that differ in 1 to 10 characters and recognizes omitted, excess, or mistyped symbols. You just choose what to correct, make a couple of mouse-clicks, and get a flawless data set at your disposal.
With Fuzzy Duplicate Finder you will
- Search within multiple rows and columns Find all similar values that differ in 1 to 10 characters.
- Manage the correct variants Replace the typos with one of the words from the list or enter your own proper value.
- Quickly navigate between the results See all fuzzy matches at a glance organized by duplicate groups.
- Export the found misprints Export search results to a separate worksheet for reviewing or correcting them.
Your personal Excel fuzzy duplicate finder
Frequently asked questions
What is Fuzzy Duplicate Finder and what do I need it for?
Fuzzy Duplicate Finder for Excel can help you find and correct all sorts of partial duplicates, typos, and misspelled words in your worksheets. The tool searches for fuzzy duplicates that differ in 1 to 10 characters and recognizes omitted, excess, or mistyped symbols. It allows you to correct misprints automatically or manually directly in search results.
Why not use Excel's Spell Checker to correct typos?
The built-in spelling and grammar checker in Excel looks only for evident mistakes. It won't find all variants of the same name, nor will it show you a list of all those embarrassing fuzzy matches. Moreover, the standard Excel dictionary may simply lack the value you need.
What about Microsoft's Fuzzy Lookup Add-In for Excel?
The Fuzzy Lookup add-in from Microsoft works only in Excel 2007 - 2013 and can only compare data in two similar datasets formatted as tables.
Our add-in works with any version of Excel 2019, 2016 - 2010, supports all Windows versions, and can handle any range of cells no matter its format.
How does Fuzzy Duplicate Finder work?
The tool allows you to find fuzzy matches in the following steps:
- Choose the range of cells to search within.
- Set the max number of different characters.
- Set the max number of characters in a word/cell.
- Click Search for typos button to see all incorrect values.
- Select the correct value and click Apply.
See a more detailed description here.
Can I run the search again without restarting the tool?
Yes, just click the New search button at the top of the results pane and you're good to go.
What if I need to use a value different from the suggested as a correct one?
No problem. You will be able to choose the correct one from the list of values or enter a completely different word to change them all.
What happens if my words in sentences are separated by some uncommon symbols: &, _, -, etc.? Will the add-in work?
Sure, there's a special field for you to indicate the delimiters used between the words.
I don't want to correct the mistakes right away, I just want to see if there are any. What should I do?
The add-in has option to export the results, so you could get all the words with fuzzy matches in one sheet. Also, you can apply the changes and cancel them easily.
Choose your Ultimate Suite edition
Fuzzy Duplicate Finder + 70 other time-saving tools in one powerful suite
| Personal | Business | Business, 5 seats | |
| One-time purchase You pay only once and can use the purchased version as long as you need. |
|||
| Unconditional 60-day money back guarantee If you are not 100% happy with the product, you can cancel an order and get your money back with no questions asked. |
|||
Volume discounts
|
|||
| Support for Excel 2019 – 2010 All Excel versions 2019–2010 are supported, both 32- and 64-bit. Also, all desktop Excel versions included in Office 365 subscriptions. |
|||
| Free upgrades for 2 years During 2 years after the purchase you get all minor updates and major upgrades for free. |
|||
| License for | Single user | Single user | 5 users |
| Technical support service Our support team is always happy to help you via email, live chat, or phone no matter how long ago you purchased your license. |
|||
| Corporate deployment (GPO, SCCM) Your system administrator can quickly and easily deploy Ultimate Suite for a group of users without even disturbing them. |
|||
| Features and hotfixes on request We’ll do everything in our power to create additional features you need and fix the found bugs as soon as possible. |
|||
February Offer
Enjoy Ultimate Suite
with up to 30% discount Offer ends February, 20th
|
$69 $99 Buy now |
$11995 $14995 Buy now |
$29996 $375 Buy now |
Supported versions
Microsoft Excel
- Excel included in Microsoft 365 (formerly Office 365)
- Excel 2021
- Excel 2020
- Excel 2019
- Excel 2016
- Excel 2013
- Excel 2010
- 32-bit and 64-bit
- Note! Office Insider is not supported
Windows
- Windows 11
- Windows 10
- Windows 8.1
- Windows 8
- Windows 7
- 32-bit and 64-bit
- Note! Windows Insider is not supported
- Note! Windows X (on ARM processors) is not supported
Any questions or comments?
Please contact us here
