Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

Say I have a document with the title, Calendar events for December and another document with the title Month of December Calendar of Events.

Is there some way to determine that these are very similar using a FullTextSqlQuery? If not, is there something else provided in the object model that would work for this?

share|improve this question

2 Answers

up vote -1 down vote

I don't think FullTextQuery supports distinct. You best bet would be to fetch the results using a combination of LINQ and FullTextQuery.

Following thread will give you a quick snapshot of how it can be done - http://stackoverflow.com/questions/1469960/distinct-department-names-sharepoint-search

share|improve this answer
I don't see what selecting distinct records has to do with my question. – Abe Miessler Nov 29 '11 at 6:37
Ah my mistake, I thought you meant distinct titles. I guess it may be tough without full blown search products. – Nitin Rastogi Nov 29 '11 at 6:50
up vote 1 down vote

Try to use FREETEXT predicate in FullTextSqlQuery.FREETEXT matches the meanings of phrases against fields.

share|improve this answer
Very cool, I will give this a shot. – Abe Miessler Nov 29 '11 at 18:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.