Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “cheerfulnesses” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

153 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
cheerfulnesses225338(None) 
cheerfulness2053582cheerfulne_s_s
heedfulnesses20124102_heedfulnesses
carefulnesses1845693care_fulnesses
cheerinesses1765823cheer__inesses
colorfulnesses1993833colorfulnesses
fearfulnesses1945313_fearfulnesses
gleefulnesses1764253glee_fulnesses
helpfulnesses2153543_helpfulnesses
needfulnesses17134093_needfulnesses
tearfulnesses1645533_tearfulnesses
balefulnesses1844854bale_fulnesses
changefulnesses2462234changefulnesses
cheekinesses2164204chee__kinesses
cheerfullest2062064cheerfulle_s_t
cheerlessnesses1954544cheerlessnesses
cheesinesses1765374chee__sinesses
dolefulnesses1774844dole_fulnesses
dreadfulnesses19193794dreadfulnesses
dreamfulnesses20183694dreamfulnesses
eventfulnesses2054274eventfulnesses
fatefulnesses1945994fate_fulnesses
fretfulnesses1945904_fretfulnesses
harmfulnesses2164304_harmfulnesses
hatefulnesses1945804_hatefulnesses
heedfulness18104074_heedfulne_s_s
hopefulnesses2184594_hopefulnesses
hurtfulnesses1954854_hurtfulnesses
masterfulnesses2053294masterfulnesses
prayerfulnesses2362404prayerfulnesses
restfulnesses1646624_restfulnesses
ruefulnesses1545934_rue_fulnesses
shamefulnesses2253684shamefulnesses
sheernesses1445844sheer___nesses
thankfulnesses2453094thankfulnesses
tunefulnesses1655134tune_fulnesses
usefulnesses1545824_use_fulnesses
wakefulnesses2354294wake_fulnesses
wearifulnesses2054654_wearifulnesses
woefulnesses1845344_woe_fulnesses
wonderfulnesses2262674wonderfulnesses
zestfulnesses2555004_zestfulnesses
artfulnesses1546645__artfulnesses
awfulnesses1744945___awfulnesses
bashfulnesses2154185_bashfulnesses
beefinesses1675955_bee_f_inesses
beerinesses1398925_beer__inesses
blissfulnesses1852835blissfulnesses
boastfulnesses1954035boastfulnesses
canorousnesses16127065canorousnesses
carefulness1645955care_fulne_s_s
charinesses1639565ch_ar__inesses
cheapnesses18104025ch_e__apnesses
cheerfuller1991385cheerful___ler
cheeriness1545535cheer__ine_s_s
cheerless1495295cheer__l_e_s_s
cheerlessly1952085cheer__l_essly
cheerlessness1853705cheer__l_essness
chewinesses1945145ch_e__winesses
chillnesses1644725ch___illnesses
churchlinesses2451395ch_urchlinesses
clearnesses13106155clear___nesses
clevernesses1743635clever___nesses
colorfulness1753825colorfulne_s_s
covertnesses1746335cover__tnesses
covetousnesses1955225covetousnesses
creepinesses1645255cree__pinesses
cruelnesses1346255c___ruelnesses
cumbrousnesses2054855cumbrousnesses
deceitfulnesses2173045deceitfulnesses
doubtfulnesses2053705doubtfulnesses
dutifulnesses1755115_dutifulnesses
eerinesses10612605__eer__inesses
effortfulnesses20112185effortfulnesses
eternalnesses1353695_eternalnesses
etherealnesses1762315etherealnesses
faithfulnesses2354405faithfulnesses
fancifulnesses2254005fancifulnesses
fearfulness1745225_fearfulne_s_s
fitfulnesses1866025__fitfulnesses
forcefulnesses2254175forcefulnesses
forgetfulnesses2262985forgetfulnesses
fruitfulnesses2094635fruitfulnesses
fulnesses1239055_____fulnesses
gainfulnesses17124615_gainfulnesses
generousnesses1556945generousnesses
gleefulness1554065glee_fulne_s_s
gracefulnesses20154915gracefulnesses
gratefulnesses18135415gratefulnesses
guilefulnesses1853585guilefulnesses
healthfulnesses2492905_healthfulnesses
heartinesses1548005_hear_tinesses
heftinesses1737135_h_e_ftinesses
heinousnesses1655555_heinousnesses
helpfulness1953485_helpfulne_s_s
herculeses15113015_h_ercul_e_ses
joyfulnesses2553505__joyfulnesses
lawfulnesses1844145__lawfulnesses
lecherousnesses20123855lech_erousnesses
leerinesses11119485_leer__inesses
liberalnesses1554265liber_alnesses
literalnesses1355245liter_alnesses
lustfulnesses1655155_lustfulnesses
manfulnesses1745835__manfulnesses
materialnesses1653915materialnesses
mercifulnesses2154275mercifulnesses
mindfulnesses1954435_mindfulnesses
mirthfulnesses2253645mirthfulnesses
mournfulnesses1963425mournfulnesses
needfulness1593995_needfulne_s_s
numerousnesses1655615numerousnesses
onerousnesses1348975_onerousnesses
painfulnesses18115145_painfulnesses
peacefulnesses2154705peacefulnesses
pitifulnesses1855575_pitifulnesses
playfulnesses2153645_playfulnesses
plentifulnesses2093175plentifulnesses
pridefulnesses2053895pridefulnesses
pushfulnesses2153945_pushfulnesses
queernesses2044575queer___nesses
regardfulnesses2072525regardfulnesses
regretfulnesses1963275regretfulnesses
resentfulnesses1883745resentfulnesses
rightfulnesses2174465rightfulnesses
ruthfulnesses1954945_ruthfulnesses
scornfulnesses1953205scornfulnesses
sheepishnesses2153015sheepishnesses
shrillnesses1543505sh__rillnesses
sinfulnesses1546135__sinfulnesses
skillfulnesses2152655skillfulnesses
slothfulnesses2053465slothfulnesses
songfulnesses1754675_songfulnesses
soulfulnesses1654555_soulfulnesses
spitefulnesses1954415spitefulnesses
sportfulnesses1964175sportfulnesses
tactfulnesses1855265_tactfulnesses
tastefulnesses1754605tastefulnesses
tearfulness1445485_tearfulne_s_s
tristfulnesses1774335tristfulnesses
trustfulnesses1764315trustfulnesses
truthfulnesses2054115truthfulnesses
unlawfulnesses2052985unlawfulnesses
vengefulnesses2153655vengefulnesses
voicefulnesses2253575voicefulnesses
wastefulnesses2054525wastefulnesses
watchfulnesses2552985watchfulnesses
wheezinesses2742865whee__zinesses
willfulnesses1953885_willfulnesses
wishfulnesses2254285_wishfulnesses
wistfulnesses1955545_wistfulnesses
wrathfulnesses2354375wrathfulnesses
wrongfulnesses2153175wrongfulnesses
youthfulnesses2353735youthfulnesses

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691950240.360496363.9
2DLD Change Limit950241535.50017277.1
3Display Results1531530.1101390.9
 (SQL Overall)1786911535.97029931.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.