I am looking for an efficient way to search for files in EPDM, starting out with purchased parts.

I would like the user to be able to search for a screw, a bearing, a cylinder, motor, etc. by certain characteristics.  Example:  I need a Sockect Head Cap Screw, M8, 1.5 long, partial thread, zinc.  Yes if this was all in the description and consistent you could search it but that is not the case with years and years of legacy.

Anybody come up with a good way in EPDM to tackle something like this?  I would rather not create yet another database to do this...

Thanks