I had a bunch of photos in Apple Photos which did that sort of thing. As a library management tool it's probably the best out there.

But when you search for brown dog it'll bring back different coloured goats, horses and cows too. This is a problem in a large library.