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?

2 Answers 2


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

  • Very cool, I will give this a shot. Nov 29, 2011 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 - https://stackoverflow.com/questions/1469960/distinct-department-names-sharepoint-search

  • I don't see what selecting distinct records has to do with my question. Nov 29, 2011 at 6:37
  • Ah my mistake, I thought you meant distinct titles. I guess it may be tough without full blown search products. Nov 29, 2011 at 6:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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