Membership is FREE – with unlimited access to all features, tools, and discussions. Premium accounts get benefits like banner ads and newsletter exposure. ✅ Signature links are now free for all. Share your own thoughts and experience, accounts may be terminated for violations.
-
Welcome to AcornDomains.co.uk, a friendly community for UK domain investors, developers and anyone interested in domain names.
Whether you're looking to buy or sell domains, learn more about the UK domain market, get feedback on your names, or simply chat with other domainers, you're in the right place. AcornDomains has been bringing together people from across the UK domain industry for many years, from complete beginners to experienced investors.
Have a look around, join the discussions and, if you haven't already, create a free account and introduce yourself.
Dictionary Words
- Thread starter Admin
- Start date
- Status
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...
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...
- Joined
- May 23, 2005
- Posts
- 2,036
- Reaction score
- 50
- Joined
- Mar 13, 2005
- Posts
- 4,660
- Reaction score
- 184
admin said:
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
grantw said:
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
- Joined
- Mar 13, 2005
- Posts
- 4,660
- Reaction score
- 184
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
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
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
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
- Joined
- Jan 26, 2005
- Posts
- 5,910
- Reaction score
- 196
- Status
