You can search for files using the Raw Query function in the Finder. This gives you the ability to use wildcards to search for files with specific file names. You can also use other file attributes and combine them for even more complex searches. Raw Query is also very fast and can search your entire drive in seconds.
Check out Powerful Searches With Raw Query at YouTube for closed captioning and more options.
Apple Spotlight Metadata Attributes page.
I want to thank you for your insightful and instructional videos. I have learned so much from your podcasts. I've been playing around with content searches within the finder but have yet to find what I'm looking for. I want to be able to search for lower case .jpg instead of .JPG and cannot seem to have finder differentiate the two.
Have you found something that I'm missing in my search?