Levenshtein and Jaro Winkler Distances for formula

[simonaubert_bd]

Hello,

In Datascience, Levenshtein and Jaro Winkler distances are used to quanitify a similarity between two strings.

Here the wikipedia pages
https://en.wikipedia.org/wiki/Levenshtein_distance

https://en.wikipedia.org/wiki/Jaro%E2%80%93Winkler_distance

Note 1 : the Levenshtein and Jaro Distances are already used in Fuzzy Matching tool, so that shouldn't be a huge work to include it in formula
Note 2 : there is a useful macro on the galley https://gallery.alteryx.com/#!app/LevenshteinDistance/5c54701f826fd30988f02779
Note 3 : some product already have it implemented such as Apache Hive or Qlik Sense

Best regards,

Simon

[CristonS]

hi @simonaubert_bd, neat idea! Our product team is constantly striving to make our products better, and the user feedback we received is critical in that mission. This idea will be reviewed and commented on by product management when the necessary criteria are met. 

[Paul-T23]

this would be a great addition, to apply fuzzy match attributes in a formula. Would get more utility out of the feature!

[fmvizcaino]

Yes!!! Found this by luck. I`m currently using Python to do this kind of comparison.

It is possible to do this with the Fuzzy Match tool with a set of transformations, but I decided to go with Python (without knowing Python) out of frustration.

Best,

Fernando Vizcaino