Two projects each have a workbook with quote-log in the name. Start in Winter Fair and narrow the search to that folder before deciding which result to open.

Select the open project as the search scope

Open Winter Fair in Finder and type quote-log in the search field. In the scope bar select Winter Fair instead of This Mac. Check the path on any result you plan to use.

The Finder search for quote-log selects Winter Fair instead of This Mac.

Illustrated scope selection. Start from the project folder.

Check the file itself when names still match

Open the candidate and check a revision, heading or date inside. If there is no result, try a shorter distinctive term and verify the selected folder. Switch to This Mac when there is a reason to look outside the project. For frequent project searches, see the default scope setting under Finder → Settings → Advanced.

The search result is checked against the Winter Fair folder path and the revision inside the workbook.

Illustrated result review. Similar filenames can still appear within one project.

Apple’s Finder search settings