How to add typo tolerance to a MySQL product search without scanning every word

<p>A shopper types <code>hedphones</code>. Your store sells headphones. WooCommerce's default search runs a <code>LIKE '%hedphones%'</code> against post titles and content, finds no such letters anywhere, and shows "No products were found".</p> <p>You can fix this without Elasticsearch, using nothing but MySQL or MariaDB. The naive way is to compare the query with every word in your catalogue usin

Read the source →