Database Software

hi ,

We are using
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production

There is a CONTEXT index on one of the tables. I use soundex , fuzzy operators to get the desired text . The column is a varchar2(300) column .

When I do a query like this
select * from tbl where contains( title , '!{greenlight}' ,1 ) >0

I don't get the record with title "green light"

If i query for

select * from tbl where contains( title ,
'!{green light}' ,1 ) >0
then I do get the record with "green light" and some other stuff.

The application should be able to support the functionality that if the user types "greenlight" they should be able to find "green light"

I am not sure how to make Oracle think that "greenlight" sounds like "green light"

Is there any other operator that can be used instead of the soundex operator to achieve this

Have you faced this problem before I will appreciate your help with this

Thanks a lot !!
smita