Ask a questionAsk a question
 

QuestionSearch results depends on sequence of words

  • Friday, November 06, 2009 5:19 PMrenevo Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    We have few 100 items within a SharePoint List. We use SSE for indexing this list. We try to implement some kind of wildcard functionality by using the SSE Search WebService. http://<server>/_vti_bin/search.asmx. We get some results but somehow they are unpredictable.

    For Example:

    We have the following data

    1 2009 cb1fc11bc79d - 12-10- 2009
    2 UNITTEST - 12-10-2009
    3 Lorem Ipsum, Lorem met Ipsum Dolar - Related to xxx  
    4 Related to xxx  - Lorem Ipsum, Lorem met Ipsum Dolar

    Searched for: like '%2009%'
    Row 1 is returned

    Searched for: like '%met%'
    Row 3 is returned

    We use this query (simplified) to search.
    <QueryText type="MSSQLFT" language="en-us">select title from scope() where title  like '%met%'
    </QueryText>

    We miss row 2 and 4, while they contain the exact same data only in a different sequence.

    Can someone please help?

    Thanks
    Rene