Not sure if I understand your question correctly but:
- Why do you store the tags/keywords inside a single column? I would split them into separate rows. Storing them as comma separated list will cause you problems in both logic and performance
- Depending on the definition tags represent a different thing than keywords. Tags typically categorize while keywords are important words that exist in the article
- Why not store both in a same table. Both are words but just different types so by adding a type column you can separate them
I would also recommend getting to know
Full-Text Search[
^] since it could help you build good search tools with SQL Server