Question How to check similarity between strings?

[dmuller]

Hello!
Is there a way in Progress 4GL to compare names in a database (perhaps phonetically)?
For example, I would like the program to return to me how much of the string "Diego Muller" is similar to "Diego Mueller".
I've tried using the "Compare" function without success.

Diego Müller

 

[Marco Mendoza]

Can't find on my current environment, but I remember a program called "soundex.p" or somethig like that; Soundex - Wikipedia

 

[dmuller]

Phonetic comparison code - soundex

code:/* The soundex code is a useful function for finding names phonetically. The best use of this would be to have a file with an non-unique indexed field called Soundex, and to place into this field the soundex code for the name. Then, when the user inputs a name, convert that input to a...

www.progresstalk.com

 

[Rob Fitzpatrick]

String matching and manipulation is not really an ABL strength. Years back when my application had a need for heuristic matching, we made web service calls from App Server to an Apache Solr instance.