I have found that users can miss spell names or miss type them. But most will usually get at least the first two and last character right. So I have a match column that is a C(3) size that stores the first two characters and last character in upper case. I perform a search against this criteria to reduce the number of possible matches. Then I refine using soundex functions.