THE METHOD :-
The Search could be done by splitting up the Search into separate words ('tokens'), and
then returning the results with the highest being the ones with the most matches.
The basic SQL would look something like this :-
SELECT url_id,COUNT(*)
FROM url_key_word_matches
WHERE key_word LIKE 'Key Word in Search%'
GROUP BY url_id;