Suffix Processing and Phrases

Post Reply
sroth
Posts: 44
Joined: Mon Jul 23, 2007 11:21 am

Suffix Processing and Phrases

Post by sroth »

I'm having trouble figuring out suffix processing for this query. I can search on Blues Brothers and get correct results, but when I search on the typo version Blue Brothers (no s on blues), I don't get any matches.

Here's what I'm doing.

*** QUERY SETTINGS ***

<apicp keepeqvs 1>
<apicp alequivs 1>
<apicp keepnoise 1>
<apicp ueqprefix C:\MORPH3\Texis\Scripts\eqvsusr>
<apicp eqprefix ''>
<apicp exactphrase 0>
<apicp suffixproc 1>
<$minsuflst = "s" "es" "'s" "'">
<apicp suffix $minsuflst >
<apicp minwordlen 3 >
<apicp qminwordlen 1>
<apicp phrasewordproc "none">
<apicp defsuffrm 0>
<sql "set delexp=0"></sql>
<sql "set addexp='>>\alnum=[\alnum\.\+\_\x24\x27\x2E\xa0-\xff]{1,30}'"></sql>
<sql "set addexp='[\alnum\x80-\xff.]{1,70}>>[.&\x27]=[\alnum\x80-\xff.]{1,70}'"></sql>
<sql "set addexp='\alnum{1,30}'''"></sql>
<sql "set addexp='\alnum{1,30}-'"></sql>
<sql "set addexp='\alnum{1,30}.\alnum{1,30}.\alnum{1,30}'"></sql>
<SQL NOVARS "set likeporder=334"></SQL>
<SQL NOVARS "set likepproximity=333"></SQL>
<SQL NOVARS "set likepdocfreq=0"></SQL>
<SQL NOVARS "set likeptblfreq=0"></SQL>
<SQL NOVARS "set likepleadbias=333"></SQL>
<SQL NOVARS "set likepallmatch=1"></SQL>


**** QUERY TO RUN ***

SELECT DISTINCT c.ArtistID ,PerformerFriendlyName,ArtistSeoName FROM Concert AS c WHERE (WebAppIDs LIKE 'WAID2') AND TrackID=0 AND (c.ConcertTypeID IN (1,2)) AND ( c.PerformerFriendlyName LIKEP `blue brothers' ) ;
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Suffix Processing and Phrases

Post by mark »

With your settings "blue" strips down to "blue" and "blues" strips down to "blu". Turning on defsufrm or adding "e" to the suffix list should make them equal.
Post Reply