I am developing a sharepoint portal for a suggestions and rewards system and need to alert duplicate suggestions. Suggestions will be in free text format, hence need fuzzy search. I understand that “Damerau-Levenshtein algorithm” does fuzzy search, but how do I implement in Sharepoint portal? Can Microsoft Search Server help? If yes, how ?
A:
You're kinda stuck with the built in Search provided by SharePoint, but the FullTextSqlQuery class can do a lot of waht you are looking for I think. It will filter out duplicates if you want to. I suggest you take a look at this class.
Trimming duplicates can be enabled / disabled using FullTextSqlQuery.TrimDuplicates = false or true
Colin
2009-06-16 10:12:02
P.S. There are some third party products out therethat do leverage SharePoint Search OOTB functionality, like Coveo Enterprise Search.
Colin
2009-06-16 10:12:52