title: Best way to deal with misspellings in a MySQL fulltext search
body: <p>I have about 2000 rows in a mysql database.</p>
  
  <p>Each row is a max of 300 characters and contains a sentence or two.</p>
  
  <p>I use mysql's built in fulltext search to search these rows.</p>
  
  <p>I would like to add a feature so that typos and accidental mispellings are corrected, if possible.</p>
  
  <p>For example, if someone types "right shlder" into the searchbox, this would equate to "right shoulder" when performing the search.</p>
  
  <p>What are your suggestions on the simplest way to add this kind of functionality?  Is it worth adding an external search engine of some kind, like lucene?  (It seems like for such a small dataset, this is overkill.)  Or is there a simpler way?</p>