Find the best string result

[#1]

HI,

Sorry for my english !

My problem is this :
I have a client list with a city and postal code entered manually ,

and I want to match it with a file of cities.
My problem is this :

some cities entered are bad spelled .
I want to match with the city that is match more .

Example:

Montbelliard ---> Montbeliard (In list have : Montbeliard - Montbeliardot - Courcelles les montbeliard)
Plessis pate - > Le plessis plate


Thank you

[MarcoWedel]

search for the following terms in this community:

Metaphone

Soundex

Levenshtein

hope this helps

regards

Marco

[swuehl]

Can you match it using the postal code?

[#4]

Thx !

[#5]

Impossible because some cities have the same postal code 😕