Fuzzy matching

How To
1

Hi,

Using Klippa, I have built a scenario that checks the validity of eID cards and submitted pay slips from potential customers. One of the validations is that Klippa extracts the information from the eID or pay slip, and then I compare the information to the information that was submitted by the potential customer. The reason is to make sure that for example the pay slip submitted really belongs to this customer, and it’s not some random pay slip they obtained somewhere.

image
image358×170 13.8 KB

In this case you can see that my check detects a difference, because the customer entered his name as “FirstName LastName” and Klippa reports the name as “Madame FirstName LastName”.

My check is pretty rudimentary indeed: if there’s just one different character, then it will fail:

image
image432×414 23.7 KB

Has anyone come across something similar before? Ideally I could apply some “fuzzy matching”, saying that if 90% of the name is identical between both items in the comparison, then probably you could consider it as a match (IF statement validates as true) instead of a difference (IF statement validates as false).

Thank you for thinking along!

2

Welcome to the Make community!

What you’re asking for, “Fuzzy Matching”, is what we call the Levenshtein Distance (algorithm).

According to Wikipedia, the Levenshtein distance is a string metric for measuring the difference between two sequences. The Levenshtein distance between two words is the minimum number of single-character edits (insertions, deletions or substitutions) required to change one word into the other.

This is possibly doable, but it requires expert advise. Therefore, you should post your request in the Hire a Pro category, as forum members are not allowed to advertise their services (even offer FREE assistance to help) in other categories like here. Once you have posted in the Hire a Pro category, that will allow other members like me to provide booking links to our calendars for a free consultation and video assistance (including screenshare)!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.