Thanks for your reply
Okay I will look at the % and remove what is needed.
I understand what you mean; having the results being able to find the closest match to the users input is what I am looking for.
So. If a user searched for w"120" l"170" d"90", I would want the search to be able to find any records that can either match or be closest too by a certain amount, say "20". So if there was a record with a width of "120" then it would definitely display that record. If there was no record with a length of "170" then a result within a "20" range would be found and added to the results.
Does this make sense? Sorry haha.
EDIT: sorry forgot to answer you query
Ultimately any of those queries should be displayed. Due to the fact that they are all within 20 of the user input and some are exact matches. But they wouldn't duplicate hopefully.