The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.
Date Published: 8/16/2013
FuzzyLookupAddInForExcel.zip, 1.5 MB
The Fuzzy Lookup Add-In for Excel was developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel. It can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables. The matching is robust to a wide variety of errors including spelling mistakes, abbreviations, synonyms and added/missing data. For instance, it might detect that the rows “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity, returning a similarity score along with each match. While the default configuration works well for a wide variety of textual data, such as product names or customer addresses, the matching may also be customized for specific domains or languages.
Supported Operating System
Windows 7, Windows Server 2008, Windows Vista
- Preinstalled Software (Prerequisites): Microsoft Excel 2010
Sounds like something I might be able to use... Now it would be even better if this were a .Net assembly that I could use. Will have to look at this and see what my programming options are...