How to Find SharePoint Documents by Partial File Name
Question details
The user needs to find documents in SharePoint using partial file names or text located in the middle of a 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.
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.
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.
Open your SharePoint site or specific document library and locate the search bar at the top of the page.
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.
Press Enter or click the search icon to run the query and locate your document.

Submit Feedback for Search Improvements
Since native substring search is limited in SharePoint, submitting feedback helps prioritize future updates.
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. Download the software: Visit the official WPS Office website and download the free installer.
- 2. Install WPS Office: Run the downloaded file and follow the quick on-screen instructions to complete the installation.
- 3. Manage your files seamlessly: Open WPS Office to easily organize, search, and edit your documents without complex query languages.

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.




