I use the Media Explorer inside Reaper. You can create databases inside it or just choose every sfx-folder you have and use the search. Of course your audio files have to be named correctly and even better if they have some kind of a BWF Description also. For example the wave file could be named: "Whoosh Throw Hard 01" And the BWF: "THROW WHOOSH BODY FALL DROP HARD. A combined movement of whooshes and body drops. Some bone cracks"

When you have everything named correctly it's really easy to just use the search. In Reaper Media Explorer you can preview the file instantly and choose which part of it you want to use by selecting and dragging. I use Reaper for everything so it's easy for me but if you use some other DAW you might wanna check some other softwares.