Word Finder in PHP/MySQL

I have a project: to create a small word finder game with Flex. The rules are simple: A word of more than seven letters is picked at random and you must find all the words of four or more letters from the letters of that word.

The first step was to find a good dictionary. I imported a word list with roughly 113,000 entries into a mysql database, and with a little help of regular expressions and looping php functions I've made the first step of my game: the back-end to pull the words. You can see below what I've done so far. No Flex-based interface and game yet, but I intend to use this php/mysql script as a back-end for the application:

  • Enter a word in the field below or leave blank to load a random word:


Selected Word: choreic

  • c -> 2
  • e -> 1
  • h -> 1
  • i -> 1
  • o -> 1
  • r -> 1

Selection of matching elements

Number of words found: 28
cercicericcerochicchicochirochoicechoicerchoirchorechoriccicerocoheircoircorecrociechoechoicheirheroheroichirehoerichorocherochrericerich

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options


CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
7 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.