title: Scrabble word finder with wildcards
body: <p>I’ve got a problem and it seems some before me have had similar problems but I haven’t been able to find a working solution for me.</p>
  
  <p>I’m currently building a mobile web application using C#, MySQL, HTML5 and Javascript. The application will be used to help users to find possible words to play while playing games like Scrabble.</p>
  
  <p>The problem I’ve got:
  How do I get the right words from a MySQL database containing a dictionary from user letter input?</p>
  
  <p>More details:
  - Users can input any number of letters and also use wildcards (representing any letter) .
  - If the user inputs “TEST” the result can’t contain words with more than 1 E and S and words with more than 2 T, a result with “TESTER” in it would be bad.
  - The result can’t contain words with more letters than inputted.</p>
  
  <p>UPDATE: Seems Trie is the solution to my problem as suggested by Eric Lippert <a href="https://stackoverflow.com/questions/7418910/scrabble-word-finder-with-wildcards/7419003#7419003">here</a>.<br />
  Problem is I'm a beginner with both C# and MySQL, so here are some follow up questions:</p>
  
  <ol>
  <li>How do I create a Trie from my MySQL dictionary? (400k+ words)</li>
  <li>How do I store the Trie for quick and future access?</li>
  <li>How do I access the Trie and extract words from it with C#?</li>
  </ol>
  
  <p>Thank you very much for the help!</p>