How to find repeating characters in a string?

I’m trying to find whether any character in a string repeats five or more times in clickhouse cloud. Examples: