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 “clunkier” with Change Limit: [1] [2] [3]

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

228 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
clunkier1434579(None) 
chunkier17395881chunkier
clankier14327081clankier
clunker13419451clunk_er
plunkier14305321plunkier
chinkier17377362chinkier
clingier1155852clingier
clinker133811662clink_er
clubbier1434832clubbier
clumpier1435582clumpier
clumsier1234732clumsier
clunked14439572clunk_ed
clunkers14327552clunk_ers
clunkiest1535162clunkiest
clunking15329432clunking
crankier14339162crankier
flukier14397852flu_kier
flunker14389362flunk_er
flunkie1434512flunkie_
flunkies1536392flunkies
funkier14349982_funkier
gunkier12369552_gunkier
hunkier144512142_hunkier
junkier18339492_junkier
lankier113711632_lankier
luckier133811532_luckier
lunier64617602_lun_ier
lunker104718342_lunk_er
pluckier16295072pluckier
plunker133910652plunk_er
punkier133512792_punkier
skunkier11174282skunkier
slinkier12206932slinkier
spunkier14235812spunkier
baulkier1433533baulkier
blanker134612023blank_er
blinker134110213blink_er
blockier1666133blockier
bluesier1034943bluesier
blunder103813153blun_der
blunger104112013blun_ger
blunter94512033blun_ter
blurrier1035163blurrier
bouncier1236033bouncier
bulkier134111513_bulkier
bunker124519373_bunk_er
cakier123115243c__akier
canker124422523c_ank_er
cannier94014163c_annier
caulker13456893caulk_er
chalkier1736753chalkier
chancier1538823chancier
cheekier1735103cheekier
chokier1638043c_hokier
chubbier1733893chubbier
chuckies1937703chuckies
chuckler1935553chuckler
chuffier1934543chuffier
chukker1543833chu_kker
chummier1734513chummier
chunked17428213chunk_ed
chunkiest1835263chunkiest
chunkily2043083chunkily
chunking18328053chunking
chunter123911483chun_ter
clacker153813773clack_er
clammier1435843clammier
clanger104113493clan_ger
clanked143812253clank_ed
clankiest1536663clankiest
clanking154313063clanking
classier10359083classier
clavier1239173cl_avier
clayier1248323cl_ayier
cleanlier1143363cleanlier
clencher15277973clencher
clerklier1542183clerklier
clicker154111883click_er
cliffier1633913cliffier
clincher15347663clincher
clinger103812153clin_ger
clinked144011643clink_ed
clinkers14339833clink_ers
clinking153611663clinking
cliquier1944223cliquier
clocker153910873clock_er
cloddier1234063cloddier
cloggier1244253cloggier
cloner84418093clon__er
clonked14429563clonk_ed
clonking153810153clonking
clothier1335363clothier
cloudier1135053cloudier
clubber13319593clu_bber
clucked163810133cluck_ed
clucking17429993clucking
clumber134011443clu_mber
clunk114215083clunk___
clunks124811013clunk__s
clunky15447893clunk__y
cluster94013333clu_ster
clutter94211663clu_tter
cockier154013623c_ockier
colickier1743513colickier
conker124721553c_onk_er
corkier133114303c_orkier
cornier93017093corn_ier
counter94220153coun_ter
counties10316283counties
courier93617893cou_rier
courtier1059333courtier
couthier13218913couthier
cranker133612783crank_er
creakier14328333creakier
crinklier1543843crinklier
croakier14436263croakier
cruddier1244153cruddier
crumbier1456363crumbier
crummier1435603crummier
cruncher15338073cruncher
crunchier1644683crunchier
crustier10259533crustier
cunner83915003c_un_ner
cuppier1368323c_uppier
curdier103312623c_urdier
curlier93314183c_urlier
currier93316703c_urrier
curvier123110663c_urvier
cushier123610833c_ushier
dinkier123411503_dinkier
drunker12326633drunk_er
duckier143911793_duckier
dungier9368583_dungier
dunker113616463_dunk_er
duskier12409433_duskier
flakier143910203fl_akier
flanker143911293flank_er
flauntier1243063flauntier
flintier1136393flintier
flockier1745343flockier
flouncier1442483flouncier
fluffier13264333fluffier
flunked15398413flunk_ed
flunkers15347533flunk_ers
flunkey17405793flunk_ey
flunking16317773flunking
flutier103011553flu_tier
funker133915763_funk_er
funnier103210173_funnier
glintier945703glintier
gluier7310263glu__ier
glumpier1334873glumpier
grungier1034983grungier
hinkier143610793_hinkier
hulkier14328973_hulkier
hunker133917673_hunk_er
hunkie133812383_hunkie_
hunkies143214503_hunkies
huskier14369763_huskier
inkier104013783__inkier
jauntier1535233jauntier
jouncier1734423jouncier
junker174213653_junk_er
junkie17339603_junkie_
junkies183711693_junkies
kinkier10319433_kinkier
kludgier1432463kludgier
klutzier2142193klutzier
lakier104716273_l_akier
lanker104123003_lank_er
larkier113711523_larkier
leakier114010993_leakier
lingier84113383_lingier
linier64423793_lin_ier
linker104321473_link_er
lintier73613803_lintier
luckie123611413_luckie_
luckies133313683_luckies
lumpier113410143_lumpier
luncher123111413_luncher
lunger75720423_lun_ger
lunies64723013_lun_ies
lunkers113414603_lunk_ers
lurker103613293_lurk_er
lustier73813503_lustier
luthier1038233_luthier
muckier153411483_muckier
murkier133110273_murkier
muskier134312733_muskier
plankter1435363plankter
plinker134010963plink_er
plucker15368243pluck_er
plumier113510043plu_mier
plummier1434123plummier
plunder103810503plun_der
plunger104211243plun_ger
plunked14429593plunk_ed
plunkers14328333plunk_ers
plunkiest1535503plunkiest
plunking15328483plunking
plushier1375193plushier
punier84519223_pun_ier
punker123718823_punk_er
punkie123513613_punkie_
punkies134216803_punkies
punnier93511263_punnier
quakier20239203_quakier
runnier74010113_runnier
runtier73512853_runtier
skankier11184883skankier
slangier9117933slangier
sleekier1245573sleekier
sludgier1034823sludgier
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
spunkie13215293spunkie_
spunkies14227583spunkies
stinkier12278543stinkier
suckier133613973_suckier
sulkier113811963_sulkier
sunnier73412153_sunnier
swankier15225503swankier
unluckier1541933unluckier
wonkier1437423_wonkier
younker14316453younk_er
yuckier16358533_yuckier
yukkier13263893_yukkier

Search took 8 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622287.61019206.6
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.87322696.7
 
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.