2

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?

1

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

  • Very cool, I will give this a shot. – Abe Miessler Nov 29 '11 at 18:21
-1

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. – 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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