I had to develop this tiny utility to delete around 1500 site collections which are autogenerated by some other tool. The autogenerated site collections were created in the format like this: http://sharepointsite.com/clients//
So this tool of mine identifies the site collections which matches the above format and deletes them. At the same time it keeps log of each and every action taken in the log file provided. If anyone needs to delete site collections in thousands then just modify the code according to your need.
Belowis a screenshot of the tool:
Solution Files
(since wordpress doesnt allow to upload zip files, I renamed the zip file with a .doc extension.)