Searchable Database Options

Hello! I am looking for plugin recommendations, ideas, suggestions, and just general feedback on something I’m trying to figure out how to accomplish on my site. I’ve been searching through plugins that are available but I can’t seem to figure out how to be specific enough in my search to find what I’m looking for.

Basically, I am trying to make a searchable system of characters by name and by color. It’s not a sales site, it’s not products or anything like that. Basically I want to have it where you type in red, and you see all the names of the characters that fall under red. Or if you type in Sam, and you see Sam falls under pink, brown, and white. I have roughly 420 names and 22 colors, with about 1200 combinations. It’s all listed in a spreadsheet. I don’t really care how long it takes me to enter them into the system, if I had to do them all individually, that’s fine. I just want to make it work and make it as nice and simple as possible.

So far my best idea is just doing pages, even though that sounds like a lot of pages and not very streamlined. If it comes to that, that’s what I’l do. I just wanted some outside opinions before I go down that path.

Thank you!

The page I need help with: [log in to see the link]