how can I search for folders ending in certain characters in Finder?

Executing a Finder search for folders seems limited to searching for folder names beginning with the search term. I can't search for folder names only using a characters in the middle or end. I'm having to resort to using the find command from Terminal. Any way around this? Below is a sample folder and multiple search attempts:

This is my first post here so I can only post two images, apparently. I have an additional screen shot showing a search for "jo" which indeed reveals every subfolder beginning with "jo". I have a fourth screen shot showing that a search for "bert" fails to return "robertson" "colbertson" etc. Those searches were both name-based searches with the same "kind" restriction to folders only.

What's up with this?

Solution 1:

In Finder try using this:

Kind is Folder
Name ends with son

This should display all folders ending with "son".

Try also, begins with and contains for similar searches.

Solution 2:

I haven't found a way to get variables in spotlight, but I must be misinformed since that seems so useful to not implement.

That being said, I use terminal and mdfind to parse spotlight like you have all the time.

mdfind "kMDItemFSName == '*son' && kMDItemKind == 'Folder'"

That will show you all folders ending in son and you might want to grep for the "sample names" folder name to replicate the search you have illustrated or use the -onlyin command:

mdfind -onlyin dir "kMDItemFSName == '*son' && kMDItemKind == 'Folder'"

You can drag the folder into terminal to get a properly escaped name with spaces encoded and then paste that in place of dir