SharePoint Document Issues

How to Find SharePoint Documents by Partial File Name

Phi Hung VoPhi Hung Vo Oct 10, 2026 870 views

Question details

The user needs to find documents in SharePoint using partial file names or text located in the middle of a file name.

How to Fix SharePoint Search Not Finding Documents by Partial File Name
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Searching for a specific document in a SharePoint library when only a portion of the file name is known.
Observed behavior
Default SharePoint search fails to return results when searching for text in the middle of a file name, unlike other applications such as OneNote.
Before you start

Ensure you have the exact partial string you want to search for, and verify that you have appropriate viewing permissions for the document libraries you are querying.

Solution 1Recommended

Use Keyword Query Language (KQL) and Wildcards

Use KQL wildcard characters to force SharePoint to match partial strings in your document names.

By default, SharePoint search relies on prefix matching. To find documents based on keywords located in the middle of a file name, you must utilize Keyword Query Language (KQL) wildcards.

1
Navigate to the search bar

Open your SharePoint site or specific document library and locate the search bar at the top of the page.

2
Enter the KQL query

Type your partial search term followed by an asterisk (*). For example, to find a file named '21071-30-SP-111', enter '111*' into the search box.

3
Execute the search

Press Enter or click the search icon to run the query and locate your document.

Use Keyword Query Language (KQL) and Wildcards
KQL Limitations: Note that some complex mid-string queries (like 'SP-111*') might still yield inconsistent results depending on SharePoint's indexing rules and delimiter handling.
Free Microsoft Office alternative

Try WPS Office for Easier Document Management

If you are frustrated with complex enterprise search setups and need a lightweight, user-friendly suite for your documents, WPS Office offers an intuitive interface and highly accessible local and cloud file management.

  1. 1. Download the software: Visit the official WPS Office website and download the free installer.
  2. 2. Install WPS Office: Run the downloaded file and follow the quick on-screen instructions to complete the installation.
  3. 3. Manage your files seamlessly: Open WPS Office to easily organize, search, and edit your documents without complex query languages.
Highly compatible with Microsoft Office formats (Word, Excel, PowerPoint).Built-in file manager with straightforward local and cloud document search.Lightweight installation and incredibly fast startup times.Familiar user interface requires no learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint search work differently than OneNote?

SharePoint uses a different indexing engine designed for enterprise-scale document management, which relies heavily on prefix matching for performance, rather than the simpler substring matching used by apps like OneNote.

Can I search for the exact middle of a file name without using wildcards in SharePoint?

No, by default, SharePoint requires the use of Keyword Query Language (KQL) wildcards (such as the asterisk *) to identify partial matches inside a file name.

What happens if my KQL query with a wildcard still returns no results?

Ensure the document has been fully crawled and indexed by SharePoint. Also, be aware that certain combinations of letters and hyphens may be treated as a single word by the search index, complicating mid-string searches.

Where can I find a complete list of KQL commands for SharePoint?

You can review the official Keyword Query Language (KQL) syntax reference provided in the Microsoft Learn documentation for detailed rules and query options.