SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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 -

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

Your Answer


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.