In any application generating related links is little challenging and it is very hard to get accurate result. I have try to create example of related link query which will fetch close result of what you are looking for.
Consider an example of any website with article section and if you are trying to give related links using fulltext search query of sql server, than following query would be helpful.
If you are new to fulltext search and would like to understand more on how fulltext search works in sql server
Step 1: Check whether fulltext search is installed
If this query returns a value of '1' then the component is installed.