That’s not a common phrase, though…
I grew up with people saying, “happy as a frog on a log” or something.
Precisely something a clam would say, suspicious…
Those are very small percentages. Maybe it is a phrase some people use, I’ll accept that, but it is not common.
Compare with an actually common expression
You are literally showing it’s half as common as “free as a bird”, a VERY common phrase.
That only proves it’s common!
Most phrases have very small percentages, as they are measured against all other combinations of words in literature.
Since it’s an informal idiom, it’s also much more common in spoken than in written language.
Even with those small percentages, ‘free as a bird’ was twice as common.
Exactly, only twice as common. To put in other words: For every two times someone says “free as a bird”, one person says “happy as a clam”.
That is much narrower than the gap between something commonly said and something rarely said.
Again, “happy as a clam” is very informal. “Free as a bird” is much less so, so it makes sense it pops up more often in literature.
It’s also been used much longer. First known use of “happy as as a clam” was 1833 versus “free as a bird” being used in the 17th century.
Also more poetic, shows up in poetry and song lyrics, pre-written spreches, etc.