Help with a 'word' application

Bruce · February 1st, 2005, 06:55 AM

Hi
Thanks in advance for all the help offered.

I am writing an application that will accept a scrambled couple of letters (max 13) and then bring back all of the possible words that could be constructed.

I have completed the front-end and placed the 'dictionary' into an MS ACCESS database. All fine...

I know that I have to write an algorithm to accomplish the task but I am stuck at double and triple letter combinations. (eg: brionsstsipuc)

Anyone done something like this before? Any help would be appreciated.

Regards

Bruce

anubhav.kumar · February 18th, 2005, 09:01 AM

hi Bruce,

Can you elaborate your actual confusion. The example you gave doesn't enlight the point where you stuck

Anubhav Kumar

Bruce · February 18th, 2005, 10:14 AM

Hi Anubhav

Thanks for your response, at this point the program (application) is an idea that I have for a "puzzle solver". I have no code yet and are busy planning the logical flow of the application.

As stated before I have finalized what I wanted the front-end to look like as well as creating a dictionary (database).

I was actually looking for assistance and guidance with the algorithm that need to be created to match possible words to the ones found in the database - and thought that if someone has maybe done something similar then I could always learn from their experience.

Thanks for the offer - I hope that I was more clear in this posting.

Regards

Bruce

chipset · February 19th, 2005, 05:30 PM

Hi Bruce,
i can't realy write the fullvalgorith for you cause am in the middle of an Exam in school
tell you what! i will give the procedures.

[quote]quote:match possible words to the ones found in the database [/qoute]
- i think this will have to do with a little bit of database programming
- Connection to the database

Code:

Public Rs as New Recordset
Public SQLstm as String
Public sConnection as String

  sConnection = "your Connectionstring to the database"
  SQLstm = "SELECT * FROM [Dictionary]"
  Rs.CursorLocation=2
  Rs.Open SQLstm, sConnection, 2, 3

- for the check routine,

Code:

Private Sub txtEmailAddress_Change()
  Rs.Filter = "[field name] Like '%" & txtEmailAddress & "'"

- for advance result and speed,
- you can have fields list from A - Z
- then check the First letter of the search string
- Locate the right Field with the Letter
- then make your search

i don't really understand this statement

Quote:

I know that I have to write an algorithm to accomplish the task but I am stuck at double and triple letter combinations. (eg: brionsstsipuc)

you can tell me what you think.

Arowolo