Linking MS dictionary as data into Excel

  • Thread starter Thread starter Yabbadoo
  • Start date Start date
Y

Yabbadoo

I'm British. I've sourced some word lists, unfortunately they are US
English, with US spellings - not helpful with my end-use. It occurred to
me, the needed database already exists ...

PC already has an English dictionary (part of MSOffice). Is it possible to
import this as a wordlist into Excel?

Object of the exercise - to "query" the dictionary to return words which
match input criteria such as example -
G?GG?? (the length of word, 6 characters, ? a single wild-card) ?
The return to be all 6-letter words matching - gaggle, gagged gagger giggled
etc ... this an example, the query could be as few as 3 and as many as
sixteen letters.

There's a web-site which already does this on-line, but the reponse time is
slow. I'd like to create my own in Excel, if possible. Help, please?
 
As ever, you are most helpful, and correct. The list "mword.tar.tar" appears
to originate from Sheffield Universtity. I know exactly where Sheffield
is - in Yorkshire, UK's largest county (I'm a Yorkshireman).
Have downloaded. It's said to be a ZIP file - Lord knows how I'm going to
get 387,000 words into Excel as a database! (ZIP, with a .tar.tar double
extension?? That'll be a good test of Winzip!! Manyana, it's too late now
(near midnight).
Thanks again, Tom. Sincerely, Len.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top