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' ) ;
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' ) ;