>Hello All:
>
> I'm trying to write an application that takes a user-entered name and matches it with names in a table. If the name isn't found I wan't to try to do an inaccurate match and get a list of names that are 1 or 2 letters different. These are international names which easily have 7 separate words in a name. Does anyone have any ideas on how to do something like this? Thanks in advance.
You may assign them some similarity points, using the difference() function (uses soundex() internally) matching words in the name, assigning more if they're found in the same position, assigning less if the equal words are standard pre/suffixes (like van, de, von, jr, II etc). You may also store words into a table and select names based on number and similarity of words of a particular name with words in this table...
Also, take a look at LIKE operator in SQL, it may give you a good way to select equal, similar, less similar words from such a table.