well, hiragana and katakana themselves never really have any meaning, they form words that do. So like you can think of お as being like ‘w’ or some other letter of the alphabet. ‘w’ doesnt mean anything on its own, but if you add it to “ater”, it means water.
In terms of actual words that only use kana, you can use the core10k if you want. I’ll see if I can find a link.
Not sure if this is what you were looking for, but here you go