SOUNDEX similar articles test

SQL

SELECT if(right(soundex('intéresser'),3) = right(soundex('enterese'),3),1,0), soundex('intéresser'), soundex('enterese');
SELECT if(right(soundex('water'),3) = right(soundex('wasser'),3),1,0), soundex('water'), soundex('wasser');
/*SELECT iapage.page_title, iepage.page_title from iawiktionary_p.page as iapage join iewiktionary_p.page as iepage on iepage.page_namespace=0 join (SELECT SOUNDEX(page_title) as soundex, page_title from iawiktionary_p.page WHERE iawiktionary_p.page.page_namespace=0) AS iasoundex ON iapage.page_title=iasoundex.page_title join (SELECT SOUNDEX(page_title) as soundex, page_title from iewiktionary_p.page WHERE iewiktionary_p.page.page_namespace=0) as iesoundex ON iepage.page_title=iesoundex.page_title where iapage.page_namespace=0 and iepage.page_namespace=0 and iasoundex.soundex=iesoundex.soundex limit 10*/

SELECT iapage.page_title, soundex(iapage.page_title) as iesoundex 
from iawiktionary_p.page as iapage
LEFT JOIN (
  SELECT page_title, soundex(page_title) as iesoundex 
  from iewiktionary_p.page WHERE page_namespace=0 AND iesoundex is not null group by iesoundex) as iepage
  ON iapage.soundex=iepage.soundex
 
 WHERE iapage.page_namespace=0
SQL

Checking query status...
