I'm looking for an equivalent of the Fuzzy Lookup Add-In for Excel, which unfortunately doesn't work on my dataset (yields error
Unable to set the numberformat property of the range class).
What I need is to get a list of fuzzy matches, e.g. based on Levenshtein distance, based on a dictionary. E.g. I would like to match
Mikal. I already have the (non matched) list of names. What I need is a service to iterate over it.
It's OK if the service only combines single matches (e.g.
Michel etc. etc.), but it would be even greater if it produced a collection of synonyms, where all the matching items were collected on a row or in an array.
It would also be good if it supported configurable tokenization, so that e.g.
Chr was converted to
Kr at a cost of 1 (rather than 2, which would be the default).
The end goal here is to populate the Nickname search in SharePoint 2013 based on a local repository of names.
The service can run locally or online. If somebody knows how to get around the Excel bug, that would also solve the problem.