sql server 2008 - Cannot find my search "iso" in a word "TESTISOTEST" by using FREETEXTTABLE -

first, i'm starting implement fulltext search on table of 12 millions of rows. maybe have not yet understood of intricacies. :)

all 12 millions of rows seem indexed correctly , index correctly created 1036 lcid language. use "system" stopwords list , 1 seems empty. that's ok me, now.

query used :

declare @keywords nvarchar(2800) set @keywords = 'iso'  select ft.[key], ds.data, ds.datatypeid datassearch_fr ds inner join freetexttable(datassearch_fr, (data), ''' + @keywords + ''', language 1036) ft  on ft.[key] = ds.id order  ds.datatypeid desc 

this query used in sp returned datas "iso" value or "test iso test" value not "testisotest" or "isotest"...

maybe it's correct operation of full-text search freetextable. know how returned "testisotest" type of data. maybe using containstable seems me not useful...

thanks help, regards, sébastien

fulltext search depends on tokenizing input text, done @ word boundaries (for western languages). cannot find arbitrary substrings, words.