Comparing VARCHAR Text

[SgtJarrow]

I have a requirement to search a table containing a VARCHAR(1000) column and return a "comparison value" to a given string. SOUNDEX and DIFFERENCE do not provide a detailed enough comparison value. Anyone know of any other methods for doing something like this? A good example of a fuzzy compare or some such??

Example:

Table
========
1   Some paragraph or long string text up to 1000 characters long
2   Some paragraph or long string text up to 100 characters long
3   Who knows?



Parameter Input = 'Some paragraph or string text up to 1000 characters long'


Output
=======
1   close (or some value)
2   close (or some value)
3   not close (or some value)

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer