"I rarely get excited about SEO and SEM tools...But, when it comes to keyword research it is virtually impossible to produce a quality worksheet without software. When I have to perform the same task for my customers, the process is even more daunting and time consuming...there is now a better way to manage huge keyword lists and this tool is called WordStream."
The keywords you want to focus your SEO on should closely resemble the vocabulary of your audience. In order to come up with the proper keywords you really have to get inside the heads of the people who search for your website. What terms will people use? How do people search? Which question does your website answer? You should create a list of all search terms people could use and think of combinations and nuances within these search terms.
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.
These 3 keyword matching options are not solely to blame for the large variations seen when comparing data from the keyword tools. Much of this difference can be attributed to the distinctive techniques that the tools use to collect their data. Let’s take a look at how these tools collect and present their data and hopefully it will help clear up any confusion.
Understanding the balance of terms that might be a little more difficult due to competition, versus those terms that are a little more realistic, will help you maintain a similar balance that the mix of long-tail and head terms allows. Remember, the goal is to end up with a list of keywords that provide some quick wins but also helps you make progress toward bigger, more challenging SEO goals.
In a nutshell, Long Tail Pro helps you quickly find keywords in bulk based on a seed keyword that you input.  In addition to returning hundreds of related keywords, the tool also shows search volume (monthly search volume), advertiser bid, number of words, rank value, and my favorite Keyword Competitiveness (helps you judge the competition and keyword difficulty).