macOS - Finder shows unrelated items for a search query.

Is there a way to make it so Finder only shows results for the key words you are typing only in the file name?

When you type in the search field, it asks you if you want to limit the search to a variety of categories including Filenames:

You can also start with "Find by Name" using cmd-shift-ctrl-F

Kind of long shortcut, but you can change it.

Create keyboard shortcuts for apps on Mac - Apple Support

Just entering a string such as "Summers Day" causes Spotlight to check every Search Result category that you have selected in System Settings > Spotlight. This doesn't just look for a document name but peeks inside documents to see if it can match that search string, or does web lookups, and is woefully inefficient.

Apple talks about narrowing your Spotlight search results by using keywords to limit the search to just filenames. For instance, this case-insensitive search for a document whose name contains the partial or full string:

kind:pdf name:summer
kind:word name:"summers day"
kind:pages name:" day"

In concert with Spotlight search, it is beneficial to make a change to the Finder Settings > Advanced panel:

for when you are using the search feature in a Finder Window.