I need to create a database for an inhouse graphics search engine.

I need help difining my tables.

what do i do

1 table with the graphic names and locations and an ID

and

1 table with the keywords that relate back to the ID

but how do I execute a query and figure out what match is closer.

for example if the search word is part of the keyword it get less of a "match value" than if it was the whole word

any help would be great
if you have a diagram
email it to me [email protected]

thanks