You can try DeepMiner. It is good for scrapping, rank position, generating long tails and keyword suggestions. You can export the data to document for later analytics. You can find popular keywords that people are searching for. 7 major engines are supported, Google, Yahoo, AOL, Amazon, YouTube, Ask, Bing. It supports multi-threading so it is very very fast scrapper. BTW you must use proxy list if you plan to scrap thousands and thousands of keywords.
2. The second category are keyword tools based on the competition. One of the first things to determine is not only who the business competitors are, but who the SEO competitors are. Keyword research can be done by simply doing research on high-performing competitors. Some of my favorite domain-based keyword tools are SEMrush, SpyFu, and BrightEdge's Data Cube.
This makes Google Suggest a relevant source for keyword research, it contains a large amount of organic keywords very closely related to a full or partial keyword and can be used to find additional most searched appending keywords that make the whole keyword less competitive. Google Suggest can be researched through the Google Search website or through a compatible browser for a small amount of keywords but also in large scale using free scraper tools.