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.
Most keyowrd databases consist of a small sample of the overall search universe. This means keyword databases tend to skew more toward commercial terms and the core/head industry terms, with slighlty less coverage of the midtail terms. Many rarely searched for longtail terms are not covered due to database size limitations & lack of commercial data around those terms. Plus if those terms were covered, there would be large sampling errors. Google generates over 2 trillion searches per year and claims 15% of their searches are unique. This means they generate searches for over 300 billion unique keywords each year. The good news about limited tail coverage is it means most any keyword we return data on is a keyword with some commercial value to it. And with Google's Rankbrain algorithm, if you rank well on core industry terms then your pages will often tend to rank well for other related tail keywords.
Note: the old software version of Long Tail Pro would have spit out several hundred adwords suggestions (many being irrelevant to the seed keyword) for this one seed keyword and then you would have to filter to see only what you wanted to see. With the new cloud version of Long Tail Pro, you set it to show only a certain number of keywords and it displays the most relevant keywords so you have less noise and confusion to filter through.
Long Tail Pro is a keyword research tool that helps you quickly find low competition keywords for your website.  In particular, the tool is built for people doing SEO (search engine optimization) as opposed to people doing paid ads (Google Adwords PPC).  I'm sure there are some advertisers that use the tool for paid ad keyword research, but the tool was built for SEO keyword research.