title: select records which contains nearby word in string
body: <p>I am trying to fetch record which contains similar word in string.I know %% trick in mysql to fetch required data like </p>
  
  <pre><code>select * from products where Name like '%LORFAST%'
  </code></pre>
  
  <p>but what if dont have exact word for filter??? like instead of "LORFAST" if i write "LORFST" then it will not return any record.</p>
  
  <pre><code>select * from products where Name like '%LORFST%'
  </code></pre>
  
  <p><strong>Expectation :</strong>  even i miss any character it should return nearby match. above query should return "LORFAST TAB." any idea how to do that??</p>
  
  <p><a href="http://sqlfiddle.com/#!9/30b949/2" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/30b949/2</a></p>
  
  <p><strong>Code</strong></p>
  
  <pre><code>create table `products` (
      `Id` int (11),
      `Name` varchar (900)
  ); 
  insert into `products` (`Id`, `Name`) values(1,'LORFAST TAB.');
  insert into `products` (`Id`, `Name`) values(1,'SPORIDEX REDIMIX DROP');
  insert into `products` (`Id`, `Name`) values(1,'MICROGEST 400MG');
  insert into `products` (`Id`, `Name`) values(1,'ANTIPLAR PLUS TAB');
  insert into `products` (`Id`, `Name`) values(1,'DECA DURABOLIN  100MG');
  </code></pre>