Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.

Dictionary Words

Discussion in 'Domain Research' started by Admin, Aug 15, 2006.

Thread Status:
Not open for further replies.
  1. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    Does anyone have a tool or site that can pull out domains with only proper "dictionary" words in the list?

    thanks
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
    IWA Meetup
     
  3. mmerlin

    mmerlin Member

    Joined:
    Jan 2006
    Posts:
    10
    Likes Received:
    1
    I've written custom software for my own purposes (for .com domains)

    Using custom software I managed to register and resell the majority of my dictionary .com domains registered over the years (many hundreds sold since 1998, most sales occuring from year 2000 onwards)

    Anyway if you want to "roll your own", here's the way to go about it...

    First thing is to get ahold of the "mobywords" archive (it's at some university)

    Get the list with the 75000 dictionary words

    Load it into a database. I use MS-Access.

    Then whereever you are getting your drop list from, feed the results into a database table, then run a single SQL query join (with extension truncated from the domain name) against the mobywords table and viola, you have a result set of domains that are dictionary words (or at least in the mobywords file)

    The mobywords file is not 100% pure, you need to strip out a few extraneous characters first.

    If you're not up to writing your own, then you could try posting on elance.com or it's ilk for someone to write you something custom.

    Or assuming you have a reasonable budget for what you want to achieve, I could write you just about any kind of web robot, HTML scraper, database parser, search automator, etc...
     
  4. aquanuke

    aquanuke Well-Known Member

    Joined:
    May 2005
    Posts:
    2,040
    Likes Received:
    42
  5. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    thanks for the replies, will give the Access database a go....
     
  6. Jeewhizz

    Jeewhizz Well-Known Member

    Joined:
    May 2006
    Posts:
    1,174
    Likes Received:
    18
    If you look online, you can download the pspell dictionaries (named english.1 english.2 etc) and they are sufficient.

    Jee
     
  7. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    cheers, the key is knowing how to query a domain list using these
     
  8. grantw United Kingdom

    grantw Well-Known Member

    Joined:
    Mar 2005
    Posts:
    4,694
    Likes Received:
    93
    Admin, I can write you a vba module to run through the domain list and query it against the dictionary table then output only the dictionary domains into a new table? Only problem is that Im still using access 97, in theory it should work in later versions tho.

    Will do it cheap or maybe for a domain as Im pretty bored at the mo?

    Grant
     
  9. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    Sounds cool!

    Basically I want it so I can publish word lists here.

    How cheap is cheap? :)
     
  10. grantw United Kingdom

    grantw Well-Known Member

    Joined:
    Mar 2005
    Posts:
    4,694
    Likes Received:
    93
    I'll send you a pm in a min.

    grant
     
  11. mmerlin

    mmerlin Member

    Joined:
    Jan 2006
    Posts:
    10
    Likes Received:
    1
    Hi Grant,

    Even easier, use an Access Query, as described in my post above and you don't need to write any code to do the domain matching.

    Start off with a select query of your "domains" table, and truncate the domain extension starting at the first dot.

    Assuming you have a table named DropList with a field Domain

    SELECT Domain, Left([Domain],InStr([Domain],".")-1) AS DomainWord
    FROM DropList;

    will give you a new field DomainWord.

    Then use that query above and create a new JOIN query with your dictionary words, joining DomainWord field with the DictionaryWord field in your Dictionary table.

    Output the result using an Access make-table query (or you could do an append query into an existing table)

    Apart from not having to write chunks of VBA code, the whole thing runs heaps faster than VBA code could do the matching.

    Behold the power of SQL ;)

    Gotta love databases :)
     
  12. grantw United Kingdom

    grantw Well-Known Member

    Joined:
    Mar 2005
    Posts:
    4,694
    Likes Received:
    93
    Appreciated mmerlin, would have appreciated it more tho. if you had posted it before I'd written the code :)

    I just checked it and it will do 65k domains in about 90 seconds, not the speed of light but I think it will suffice for what Admin needs.

    Al the best, Grant
     
  13. mmerlin

    mmerlin Member

    Joined:
    Jan 2006
    Posts:
    10
    Likes Received:
    1
    LOL no probz :D

    It would be interesting to see how the running time compares, if you get around to refactoring your code to use the SQL way of doing things.

    At the very least you'd get some experience at another way of tackling the same problem.

    Anyway, glad it all worked out :)
     
  14. Pred United Kingdom

    Pred Well-Known Member

    Joined:
    Jul 2006
    Posts:
    7,145
    Likes Received:
    71
    lie down

    after reading this thread i need to go for a lie down.wooa.
    cheers, Predator :mrgreen:
     
  15. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    Mobywords are .tar files. Is there any way to unzip them on windows?
    Doubt my boss will be too keen on me loading university files onto our unix network!
     
  16. Jeewhizz

    Jeewhizz Well-Known Member

    Joined:
    May 2006
    Posts:
    1,174
    Likes Received:
    18
    if you are on unix/linux:

    tar -zxvf file.tar.gz if it's gzipped

    tar -xvf file.tar if it's not
     
  17. rob

    rob Founding Member

    Joined:
    Jan 2005
    Posts:
    5,966
    Likes Received:
    119
    winrar does tar i think http://www.rarlab.com/download.htm
     
  18. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    Thanks Rob.
    Jee i use unix at work but dont want to put that file on the network, hence wanted to unzip it at home on windows.
     
Thread Status:
Not open for further replies.