Looking for invaild names

I have a database with a whole lot of records (over 70 mill) I am looking for a quick way to search the name fields for incorrect names and give me a count.
Example:

ttthomas
wwwagner
jonnnes
willllliams
fredrickkkk
collinssss

I mostly need it to search for 3 or more duplicate characters in a row, but through the whole name.
I am not sure if this is even possible.
Any help would be greatly appreciated.

select count(*) from yourtable where name like '%aaa%'
or name like '%bbb%'
or name like '%ccc%'
or name like '%ddd%'
or name like '%eee%'
or name like '%fff%'
or name like '%ggg%'
or name like '%hhh%'
or name like '%iii%'
or name like '%jjj%'
or name like '%kkk%'
or name like '%lll%'
or name like '%mmm%'
or name like '%nnn%'
or name like '%ooo%'
or name like '%ppp%'
or name like '%qqq%'
or name like '%rrr%'
or name like '%sss%'
or name like '%ttt%'
or name like '%uuu%'
or name like '%vvv%'
or name like '%www%'
or name like '%xxx%'
or name like '%yyy%'
or name like '%zzz%'