Is it possible with either KQL or FQL to query for title:*or* and get back items where the tile is e.g "A.B.PZ.3_MS_Form" ? Another query would be title:*PZ*.

Background: I have a custom advanced search and fight with the contains drop down for the title property. Starts-with, ends-with and equals are working. Its for SP2010+FS4SP


3 Answers 3


This is NOT possible with Managed Property keyword queries. The only wildcard capability that Sharepoint Search Server 2010 supports is "Stemming". Stemming expects the characters to be matched by the characters at the start of a string in the index.

e.g. Item contains Title string "TestMe"

You're query can be : Title:"Tes" and that would pick up the TestMe item.

You would have to enable stemming in your Core Results Webpart or in a custom scenario, enable it on a FullTextSqlQuery object.

  • Apparently I need contains. What I dont understand is that the values are stored in the Property DB - why is a simple contains query not possible? Apr 10, 2013 at 17:43

If you do a KQL query with title:or* you will see the results you are asking for. You do not need to put the leading wildcard as it does that automatically.

  • Nope, that does not work. Have you tried it? Apr 10, 2013 at 17:35
  • I was working with something similar the other day and that was the behavior I was seeing. I ended up having to change over to use the FQL and starts-with to get around it. Apr 10, 2013 at 17:38
  • Does starts-with(title,"*or") work or can you provide me a screenshot of your query/result? Apr 10, 2013 at 17:45
  • This does not work. MS has stated clearly: KQL queries don’t support suffix matching.
    – Wint
    Jul 15, 2015 at 9:43

Your best approach is to get titles on those weird formats into a separate managed property. Then you can do word searches on that property in FQL with less chance of the query bombing.

It's all about term expansion in the search engine core and how many terms would match and how big(slow) will the end query be.

The other approach is to create a full text index with n-grams enabled.

  • So the title property is the problem? I am aware that the term expansion is the root cause, but I dont understand why another managed property would help. Could you give me an example please? Apr 28, 2013 at 19:39
  • 1
    No, another one would not help if it duplicated all values in the current Title property. But if you only pull over the "weird" titles, then it might can help as that mp will have fewer values. Apr 29, 2013 at 9:15

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.