I also want to emphasize that Microsoft Excel and Google Docs perhaps play an equal, if not more important role in keyword research than any of these tools, because at the end of the day, the mountain of data you end up with is of no use if you can’t perform calculations, sort, filter, present or store it in a way that’s best suits the task at hand. Head over to Distilled for a comprehensive Excel for SEOs guide. Alternatively, bug this guy—he’s the Sensei who trains Excel ninjas in the dark of the night.
Basically, Google shows the autocomplete suggestions whenever you start typing anything into Google search box. It is in Google's best interest to show the most relevant keywords in the autocomplete suggestions. Keywords that would help Google to retrieve the most relevant websites and help users find the most relevant content for their search query.
Because great content requires a deep understanding of the main idea (e.g., “ac repair houston”) and the supporting subtopics that require coverage (e.g., “central ac vs portable ac systems”) and the common issues that users seek answers for (e.g., “freon,” “refrigeration loops,” “coolant refills,” “troubleshooting”), the effectiveness of a keyword reporting tool is only as strong as the SEO pro using it.
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.