The Fuzzy Lookup Add-In for Excel has been developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel.
Fuzzy Lookup Add-In 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.
Download page: Microsoft.
Requires Microsoft Excel 2010 on Windows 7, Windows Server 2008 or Windows Vista.