Suggested by Ryan Maclean – New
It would be great if it was possible to expand on the fuzzy matching capabilities already in the system with the Levenshtein Distance function by introducing additional options, such as:
- Jaccard Index of SImilarity (used by the Excel Fuzzy Lookup add-in - https://www.microsoft.com/en-gb/download/details.aspx?id=15011)
- Soundex or Metaphone algorithm
We do have the MetaPhone3 algorithm already and while the video below is very old it would all this work today on v9.
https://www.youtube.com/watch?v=FVf5eLA-7BA
In terms of the Jaccard Index of Similarity in 8 years you are the first to ask for that one 😊 It will get added to the product back log but to be honest it would be low priority for us.