These "Linkable Columns" are currently only implemented, as you've seen, for a few fields.
For now, you can use the Search box/wizard to accomplish what you're trying to do. It is pretty smart, and will help you with the misspellings or close approximations. As you type, files are narrowed to the possible matches.
For these types of projects, its best to create a panes Standard view that includes the Name column, along with whatever else you want. Then, you can sort by Name and work from that.
There are all sorts of other techniques that you can use to cleanup your library fields and tags, and you'll learn these over time (MC is loaded with features).