Crossword solver

[hendrikbez]

Good Day



I want to know if it is posible to make a crossword solver in access. I want to add word list, Synonym, Anagram eg in it, If it is possible does any one have a sample for it.

[CJ_London]

not aware of something so specific but don't see why it can't be done in principle, although could be very time consuming to set up

I would envisage a table which you might populate initially from the office dictionary. Not sure how you would find it but this link might help
https://support.office.com/en-us/art...1-a6f40c9610a5

phrasePK..Phrase..phraseFK
1.............Hello....1
2.............World...2
3.............Greet...1
4.............Planet..2

so searching for 'greet' finds the word, then matching on phraseFK, you can also find Hello

For anagrams you would need a fairly complex formula since letters get jumbled up to make new words so there are 25 possible anagrams just for 'Hello' (number of letters squared) some of these will be valid words (e.g. hoe, he, oh), others will not

you might want to check out this site for anagrams, there are others https://www.wordplays.com/anagram-solver/

[orange]

hendrik,

Here is a link that may be helpful.
This is the post that started the creation of this database.

I re-posted/re-uploaded the code today (since it had been removed). It was originally created and posted in 2012.

The current link for the database/zip is
https://www.4shared.com/zip/5lRldjgzfi/Crossword.html

If you do use it and extend its functionality and/or update/create a new word list, please post a copy.

I have used it on occasion to help with scrabble.
Good luck.

[hendrikbez]

Hi orange

Thank you will look at this.

[orange]

Hendrik,

There may be issues with 4shared--I don't use it often.
Try this link (dropbox) created today.
File is Crossword_2019.zip
Good luck.

[hendrikbez]

Orange

Thank you for this, I have changed the word list to Afrikaans, but I battle to get it to save a new word for me.

[orange]

What is your process for adding new word?
What exactly do you need help with?

Did you replace the English words with Africaans? via translate or did you have a separate dictionary?

[hendrikbez]

I have replaced the English words with Afrikaans words, that I have a txt file for, did inport them, and it is working, the only thing now is, if I have an ew word, I cannot get it to add it, I did palce a textbox and save button on the form, but it does not work.

[orange]

Can you post a copy of your database in zip format? You could make a copy and remove most of the words to get the size down. Or zip a copy to dropbox and I'll look at it.

I have reviewed the copy I sent to you and have made a couple of changes.
-replaced the dictionary with another that has 300K words
-clears the result list and search box when clicking CLEAR
-has an option to add a new word
--- considering
--batch add of new records
--exclude a word from search

Good luck.

[hendrikbez]

Orange

All that you have done now ,is what I am looking for, where can I download the new file from. Thank you for your help

[hendrikbez]

deleted see below

[hendrikbez]

Hi Orange

Here are the database.
I have added two texboxe and one button to add new words, but cannot get itto see the table.
Need your emailaddress, to let you see the file, on dropbox or google drive

[orange]

Hi Hendrik,

I have a couple of things to adjust on my revised version. Attached is a screenshot of the revised form.
I'll post the file later today.
I'm interested in your project. Could you give a few details of your proposed database?

[hendrikbez]

Hi Hendrik,

I have a couple of things to adjust on my revised version. Attached is a screenshot of the revised form.
I'll post the file later today.
I'm interested in your project. Could you give a few details of your proposed database?

Orange thank you for the screenshot.

My thinking is to have a database, with wordlist (search) then adding tables and forms for Mountens,rivers, synonymous (Put in one word and it must give answer on words that has the same meaning, there can be more taht one answer for it.) ,eg.

Doing this for my wife that loves do do wordlist, to help her with it. It will take me a while to do this, as I an not so good in access.

[orange]

Hendrik,

I have added materials - database and word doc - to the hendrik1.zip and made it available at this link since is too large for the forum.

Let me know if you can access the file and if it's useful to you. Post in the forum if you need any help.

Good luck.