Database query review and recomendation

Closed - This job posting has been filled and work has been completed.

Job Description

Code is written in PHP Codeigniter and Mysql

We require a query that ranks and returns 20 of the closest products based on there descriptions. We have a database of 150,000 products with descriptions of 250 chars some words are shortened or abbreviated (mnthly,mly = monthly) .We need to return products based on there relevance to a product description. this may require separate tables to rank words or groups ("ring binder" or "view binder") or filter out words that are not helpful

The initial project is to test the theory and to see if this is possible if it is successful we will be require the applicant to build the code - build tables, and further improve it's efficiency and speed

Skills: test