strange query

[Alex Dantart]

Hi:

I know about Full-Text searchs, soundex, and subqueries with IN or SOME. But I want to make a query that joins two concepts.

Let's see... I got this array ("grreen", "black","yellow", "bluee", "orange") (yes, some colours are bad-written)
And I got a database with for example 200 colours well-written.
1 white
2 orange
3 blue
4 brown
5 green
6 black
7 yellow
8 pink
9 ... ect


Then i would like to make a query that select from the database the rows that matches the array elements and if not, the most similar ones...

I mean... the query should return 5,6,7 and 3 (that are the 4 colours or similar "soundex" ones that matches the elements of the array).

How can i do this ?

THANK YOU