Dictionary Words

[Admin]

Does anyone have a tool or site that can pull out domains with only proper "dictionary" words in the list?

thanks

 

[mmerlin]

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...

 

[aquanuke]

Not tried it but think you just need pspell.

http://uk2.php.net/manual/en/ref.pspell.php

 

[Admin]

thanks for the replies, will give the Access database a go....

 

[Jeewhizz]

If you look online, you can download the pspell dictionaries (named english.1 english.2 etc) and they are sufficient.

Jee

 

[Admin]

If you look online, you can download the pspell dictionaries (named english.1 english.2 etc) and they are sufficient.

Jee

cheers, the key is knowing how to query a domain list using these

 

[grantw]

cheers, the key is knowing how to query a domain list using these

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

 

[Admin]

Sounds cool!

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

How cheap is cheap?

 

[grantw]

I'll send you a pm in a min.

grant

 

[mmerlin]

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?

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

 

[grantw]

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

 

[mmerlin]

LOL no probz

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

 

[Pred]

lie down

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

 

[stender]

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!

 

[Jeewhizz]

if you are on unix/linux:

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

tar -xvf file.tar if it's not

 

[rob]

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!

winrar does tar i think http://www.rarlab.com/download.htm

 

[stender]

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.