I have a document library within which users run a search. If the users enter a number (ex. 881765) the results should show files containing "R881765" or "F;881765" or "|2881765"

Basically appending 5 or so different strings to the beginning of {subjectTerms} to search every combination.

  • Are you using Community build Search webpart on SPO or using OOB MS Search or using CSOM/REST based search query? Sep 25, 2019 at 20:17
  • I am using OOB MS Search on SPO. The default search that comes with the "Collaboration Site" Template.
    – bibobobaba
    Sep 25, 2019 at 20:24
  • Yes it is doable but as of now SPO is limited on search functionality. Follow the link to more about SPO Modern vs Classic Search limitations. docs.microsoft.com/en-us/sharepoint/… Sep 25, 2019 at 23:32
  • If you can use community based search web part and target to a specific result type, you can solve this issue. Sep 25, 2019 at 23:32

1 Answer 1


SharePoint does not support suffix wildcard search, it only support for prefix matching.

When you use words in a free-text KQL query, Search in SharePoint returns results based on exact matches of your words with the terms stored in the full-text index. You can use just a part of a word, from the beginning of the word, by using the wildcard operator (*) to enable prefix matching. In prefix matching, Search in SharePoint matches results with terms that contain the word followed by zero or more characters.

eg:Federated Searc*

Similar issue post for your reference:

How can I get suffix matching in a search in SharePoint 2013?

  • It is possible using query transform but in SPO OOB search, right now we dont have concept of using a specific result source, otherwise for classic SP, configure a result source with query transform. Sep 27, 2019 at 22:21
  • Also, you are also correct for wild card part, there is no wild card prefix matching option in SPO. But as the requirement listed they need to append a finite set of words to the query which is possible. Sep 27, 2019 at 22:23

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.