I've been trying to come up with a spell checker. I'm sick of members on my forum using too much slang to post replies and such so I'd like to impliment some sort of a system to block them from posting replies which exceded a certain percentage of incorrect words in thier post. What I would need is a huge database of all the words in the English language and lots of acrynoms, etc. I could enable/disable this for trouble users.
Anyways...the does anyone have any ideas how I can quickly check words against a database table which could potentially contain hundreds of thousands of rows? Is one way faster to search to see if a word exists vs another? I'd also like to impliment a list of suggestion spellings for each word which is wrong. I'm still in the early stages of figuring some of this out and just throwing around ideas. Does anyone have any ideas? Where can I find a huge database with all the words in the English language?