Hi Karl!
Good to see you.
You're right, I left off a clause! Nice catch!
For what it's worth, sometimes the SCOPE_IDENTITY() trick doesn't work. But that can be fixed by putting the insert default values line once before the while loop.
There are no new results after removing the <> clauses.
But, I changed the query to search for all words with three double-letter patterns, not necessarily adjacent, and got quite a list! Some are very funny. Woollybutt?
accessibleness, accessorii, accessoriness, accommodativeness, addressee, addressees, aggressiveness, allottee, allottees, antiinsurrectionally, appellee, appellees, arrowwood, assessee, assessees, barrenness, bitterroot, bloodlessness, bookkeep, bookkeeper, bookkeepers, bookkeeping, cheerlessness, classlessness, coappellee, coappellees, committee, committeeman, committeemen, committees, committeewoman, committeewomen, commonness, effortlessness, footlessness, greenness, heedlessness, heelless, immunosuppressant, immunosuppressants, immunosuppression, immunosuppressive, keelless, keenness, Llanfairpwllgwyngyll, masslessness, mcconnell, Mississippi, Mississippian, mississippians, needlessness, noncommittally, nonpossessiveness, nonsuccessiveness, oppressiveness, pennilessness, possessiveness, prepossessingness, rootlessness, rottenness, sleeplessness, soddenness, soullessness, speechlessness, stubbornness, subcommittee, subcommittees, successfully, successfulness, successiveness, successlessness (4!), suddenness, sullenness, tallahassee, tennessee, tennesseeans, toolless, toothlessness, treelessness, uncommonness, unnecessariness, unneedfully, unsuccessfully, unsuccessfulness, wheelless, whippoorwill, whippoorwills, woodenness, woolliness, woollybutt, yellowweed, yellowwood.
Code:
SELECT
Word
FROM Dictionary D
INNER JOIN @N N ON N.Num <= D.WordLength - 1
WHERE
WordLength >=6
AND SubString(Word,Num,1)=Substring(Word,Num+1,1)
GROUP BY
Word
HAVING
Count(*) >= 3
-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)