Hi Thomas . Thanks for your reply
I'll check LevenshTein and VFP
Regards,
Gerard



>>Apparently, there is a 'Fuzzy Search' option that can be installed for Excel 2012 (I have Excel 2007)
>> which compares 2 columns and gives a % Match result (e.g. 100%=Exact Match 90%= Near exact etc)
>>
>>Anybody know if:
>>1. This can be done programatically (To exactly replicate what Excle does
>
>no idea on Excel implementation
>
>>2. Can it be done in Foxpro or DotNet
>
>Google Levenshtein and vfp - you will find a ready made routine (IIRC in vfp wiki) I made a bit faster...
>Fields should be letter-normalized perhaps - replacing all labials for a common one for instance.
>
>HTH
>
>thomas