Use an indexing tool like NeoFinder to generate a searchable offline index of the folder or volume. Then you can use the NeoFinder index to find what you want, then right-click on the file and select “Reveal in Finder”