The search component we are using is AceSearch. We need the criteria of the search to work like the following:
1)When I search for : a-123-45/16 I need to find all matches for a12345/16 and a-123-45/16 and a123-45/16.
2)Also we need to be able to add similar words to a column in the database to search on :
Example: If I search for sheave. another name for a sheave is a pulley so I would like to be able to type in "sheave" and also find results containing "pulley"
That is just one example so we will need to be able to add similar words in the database for any of the products.
3)Lastly, we need to add the image to the search results and it must be quick.