Guys,

any help with this much appreciated...

I have two tables containing sting fields: One entered by a user with no validation and another that contains the "allowable" list of entries. I need to convert each string in the first table (with spelling mistakes, back to front words, abbreviations, etc) to the closest match from the second "allowable" list. Effectively I'm spell-checking the first list but my dictionary is a short list of allowable entries rather than the whole english language.

Any ideas how to do this in VB???