Partial Keyword Search Not Working

Question

Hi,

We are looking for a solution to search the partial words.

Example:

We have Product Numbers in a SharePoint list like 00100122, 00110120, 00100132, 00100152, 01100122

When user search for 100, it doesn`t return the results.

But expected results as 00100122, 00100132, 00100152, 01100122. Ideally user is looking for *100*.

We have used KQL syntax to get results for our search implementation.

We have gone through the MSDN articles and found suffix match won`t support.

Can anyone help me to get this works.

Thanks in advance.

---

-Venkat

Answer 1

Hi Venkat,

According to your description, my understanding is that you want to search using the partial words.

When you search using partial words, SharePoint use these partial words as a string to query, it only returns the result which matches the string completely.

If you want the keyword as a suffix or prefix to search, you need to add "*" as the prefix or suffix of keyword, like you said "*100*".

Thanks,

Wendy

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].

Answer 2

Hi Venkat,

What I suggest you do is to modify the "query" of search webpart to append "*" after every user input. This would act as a wildcard search. Hope that helps!

Syntax and details here https://technet.microsoft.com/en-us/library/jj679900.aspx

Cheers

Sudeep