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 “cloudier” 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.

196 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
cloudier113505(None) 
cloddier1234061cloddier
bloodier1136822bloodier
blousier1055662blousier
cloggier1244252cloggier
clothier1335362clothier
clouded11348832cloud_ed
cloudiest1235582cloudiest
cloudily1444282cloudily
clouding12269492clouding
cloudlet1145502cloudlet
clouter93511692clou_ter
clowder13367942clowd_er
courier93617892c_ourier
croupier1246882croupier
louder74414602_loud_er
loudlier934952_loudlier
lousier72411622_lousier
blockier1666133blockier
blonder104011943blond_er
bloodied1245973bloodied
bloodies11310163bloodies
bloomier1275783bloomier
blottier10336413blottier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
bludger11419563bl_udger
bouvier1277433_bouvier
broodier1157433broodier
chokier1638043cho_kier
choosier1337173choosier
choppier17286643choppier
chouser125212943chou_ser
chowder16387813chowd_er
chudder14245943c_hudder
clammier1435843clammier
clankier14327083clankier
classier10359083classier
clavier1239173cl_avier
clayier1248323cl_ayier
cliffier1633913cliffier
clingier1155853clingier
cliquier1944223cliquier
clobber13378163clo_bber
clocker153910873clo_cker
cloddiest1334633cloddiest
cloddish1544233cloddish
clogger11438803clo_gger
cloister1037093cloister
cloner84418093clo__ner
closer84918203clo__ser
clothiers1443423clothiers
cloud86716423cloud___
cloudberry1851253cloudberry
cloudiness1344113cloudiness
cloudless1243153cloudless
cloudlets1242823cloudlets
cloudlike1642553cloudlike
clouds94612353cloud__s
cloudy12517803cloud__y
clour76617283clou___r
cloured103111543clou_red
clouring112811273clouring
clouted104212163clou_ted
clouters10399803clou_ters
clouting113011683clouting
clover114617123clo__ver
clowders14357473clowd_ers
clubber13319593cl_ubber
clubbier1434833clubbier
clumber134011443cl_umber
clumpier1435583clumpier
clumsier1234733clumsier
clunker13419453cl_unker
clunkier14345793clunkier
cluster94013333cl_uster
clutter94211663cl_utter
coalier93416183c_oalier
cobbier133410163c_obbier
cockier154013623c_ockier
codder104416343c_o_dder
coddler113710833c_oddler
coder86134223c_o_d_er
codger105814873c_o_dger
colder95121853c_old_er
collider113410423collider
collier93618153c_ollier
colluder11276873collud_er
colourer1037563colou_rer
comfier1439163c_omfier
copier103722893c_o_pier
corder94322883c_ord_er
corkier133114303c_orkier
cornier93017093c_ornier
cosier84423753c_o_sier
cottier93814173c_ottier
coucher144515853c_oucher
coude85022633c_oud_e_
cougher133711733c_ougher
coulter94115603c_oulter
counter94220153c_ounter
coupler114713013c_oupler
couriers103213173c_ouriers
courser94114803c_ourser
courter94516483c_ourter
courtier1059333c_ourtier
couter84930223c_ou_ter
couther123914633c_outher
couthier13218913c_outhier
cowier113616163c_o_wier
cozier173315143c_o_zier
croakier14436263croakier
crosier94116573cro_sier
croupiers1334653croupiers
crowder13389863crowd_er
crowdie1335913crowdie_
crowdies1437553crowdies
crozier18369933cro_zier
cruddier1244153cruddier
cruder95612383c_rud_er
curdier103312623c_urdier
dowdier12328573_dowdier
eluder73712213el_ud_er
floatier1136983floatier
flockier1745343flockier
flooder11258463flood_er
floppier1554633floppier
flossier11326973flossier
flouncier1442483flouncier
flounder1235103flounder
flouter104311343flou_ter
flukier14397853fl_ukier
flutier103011553fl_utier
frouzier2043703frouzier
gaudier938453_gaudier
gladier93810993gl_adier
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
gluier7310263gl_u_ier
goutier82612353_goutier
grodier939673gro_dier
groutier9297173groutier
hoodier113812973_hoodier
kludgier1432463kl_udgier
lardier83518343_lardier
lauder73815013_laud_er
leadier83212723_leadier
loader74316313_load_er
loamier9349163_loamier
lodger86517693_lo_dger
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loonier73312683_loonier
loopier93711193_loopier
loppier11369723_loppier
lordlier935363_lordlier
louden73711793_loud_en
loudish1137983_loudish
louie55023513_lou_ie_
louies64525103_lou_ies
lounger84610213_lounger
louver94110393_lou_ver
lowlier10338903_lowlier
lunier64617603_l_unier
moldier103110033_moldier
moodier103212203_moodier
mouldier1154963_mouldier
mousier93712463_mousier
plodder1146003plo_dder
ploidies1138173ploidies
plottier10327263plottier
plougher14214463plougher
plumier113510043pl_umier
poutier93215323_poutier
prouder10310383proud_er
roupier9319493_roupier
rowdier11348593_rowdier
shoddier1334213shoddier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
sloucher13206813sloucher
slouchier1443603slouchier
sloughier1343673sloughier
sludgier1034823sl_udgier
snoutier8206973snoutier
soldier82812153_soldier
soupier93111753_soupier
studier82510053_studier
troutier8277153troutier
woodier113912063_woodier
wordier112511213_wordier

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.423422437.4
2DLD Change Limit1461621967.47019566.5
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.96922423.3
 
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.