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.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Identifying possible duplicates using FREETEXT

Author  Topic  oli82 Starting Member 1 Post Posted - 2009-01-13 : 06:39:47 Hi, First post hope you can help me. Previously a contractor of ours used Oracle to compare entries in a table to detect possible duplicate entries of book titles. It may be for example that book titles have been entered slightly differently and so the query ranked the similarity between that record and other records and produced at list of potential duplicates which was checked through by a user. Is there anything similar in SQL server for example could you rank records against other records using the ranking system in FREETEXT using the full text searching in SQL server 2005. Any help on this would be really appreciated. Thanks, Oliver