If you want to search words that are not spelled correctly you can use mysql’s buildin SOUNDEX function: SELECT * FROM po_images WHERE SOUNDEX(`keyword`) LIKE CONCAT( ‚%‘,SUBSTRING(SOUNDEX(‚wronk spellet wort‘),2),’%‘ );