I want to catagorize those into folders per albums but I don't know what album each song is on. So I was looking for a search tool for that purpose.
The problem with this train of thought is simply compilations, greatest hits, soundtracks, best of's, NOWs, etc.....
In other words, each song can end up on more that one album. While this won't happen with all of your music, it will happen with a good 5-10%. Sounds small, but when you're talking 10's of thousands of songs, it gets hairy real fast.