Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mister Peanut
Starting Member
1 Post |
 Posted - 2006-07-12 : 18:39:14
|
| I'm working with two SQL Server databases that both have a "description" column that contains a string of characters. The strings can be at least 500 words. I need to compare each string with all the others (there are about 115 rows in one database and 500 in the other) and determine how similar they are.Is there a SQL command that takes both strings and returns a similarity percentage, (where 100% = the same, 0% = different)? If so, how can I use SQL Server to run each string through it automatically?Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-12 : 18:41:11
|
| Take a look at SOUNDEX and DIFFERENCE functions in SQL Server Books Online. Neither returns a percentage, but they might work for you.Tara Kizeraka tduggan |
 |
|
|
|
|
|
String Comparison