I have recently seen this really cool feature (that was once) available in google sheets: you start by writing a few related keywords in consecutive cells, say: "blue", "green", "yellow", and it automatically generates the next keywords on the same theme (in this case, other colors).
See more examples in this video: http://youtu.be/dlslNhfrQmw.

I would like to reproduce this in my own program: I'm thinking of using Freebase, and it would work like this intuitively:

1. retrieve the list of given words in Freebase
2. find their "common denominator(s)" and construct a distance metric based on this
3. rank other concepts based on their "distance" to the original keywords
4. display the next closest concepts

As I'm not familiar with this area, my questions are:

• Is this correct, or is there a better way to do this  ?
• What's the best tool to execute each step of the process ?

I recently saw a cool feature that was once available in Google Sheets: you start by writing a few related keywords in consecutive cells, say: "blue", "green", "yellow", and it automatically generates similar keywords (in this case, other colors). See more examples in this YouTube video.

I would like to reproduce this in my own program. I'm thinking of using Freebase, and it would work like this intuitively:

1. Retrieve the list of given words in Freebase;
2. Find their "common denominator(s)" and construct a distance metric based on this;
3. Rank other concepts based on their "distance" to the original keywords;
4. Display the next closest concepts.

As I'm not familiar with this area, my questions are:

• Is there a better way to do this?
• What tools are available for each step?