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

383 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
clothing1427878(None) 
clothings15264431clothings
clotting113110641clotting
beclothing1843872beclothing
blotching1734962blotching
blotting113910432blotting
clashing143812192clashing
cloaking15299712cloaking
clocking174312412clocking
clogging13368502clogging
clomping15329652clomping
cloning103215472clo_ning
clonking153810152clonking
clopping153511082clopping
closing103114842clo_sing
clothier1335362clothier
cloturing1245472cloturing
clouding12269492clouding
clouring112811272clouring
clouting113011682clouting
clowning14307252clowning
cloying133511752clo_ying
clutching17154822clutching
coshing134316432c_oshing
coting94629252c_ot_ing
frothing15208532frothing
lathing114315692_lathing
loathing1247672_loathing
lotting82917752_lotting
nothing113511902_nothing
plotting113011012plotting
plotzing20276152plotzing
reclothing1644972reclothing
sloshing12258822sloshing
slotting92612612slotting
soothing12269972soothing
toothing12278862toothing
trothing122410842trothing
unclothing1644132unclothing
airthing12297953airthing
allotting1046503allotting
anything1534993anything
bathing134816243_bathing
berthing14209603berthing
birthing14338433birthing
blatting114111653blatting
blitzing2035903blitzing
bloating113512813bloating
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
blooding122410653blooding
blooming13299433blooming
blooping13248843blooping
blousing1138793blousing
blowing133813053blo_wing
blushing14339333blushing
bolting104416763bolt_ing
booting103821363boot_ing
botching16359703_botching
caching156317503c_aching
canting104725903cant_ing
carting104228283cart_ing
cashing135022553c_ashing
casting104628343cast_ing
castling11311233castling
catching163712773catching
catling104819793c_atling
catting103922643c_atting
centring112112953centring
chatting142810143chatting
chitling142910663chitling
chocking204011013chocking
choiring14279793choiring
choking173911943cho_king
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
choring133617663cho_ring
chortling1535563chortling
chousing14259423chousing
chowing164412773cho_wing
chowsing17217343chowsing
chuting132910733chut_ing
cinching163310223cinching
citing94220183c_it_ing
clacking173313493clacking
cladding1337143cladding
clagging13328883clagging
claiming13279303claiming
clamming15329373clamming
clamping154011153clamping
clanging124012123clanging
clanking154313063clanking
clapping153810603clapping
clasping133310263clasping
classing113211793classing
clawing133812673cl_awing
claying133614303cl_aying
cleaning113112383cleaning
clearing113014883clearing
cleating113518143cleating
cleaving141389683cleaving
cleeking15267813cleeking
clefting14347583clefting
clenching17266303clenching
cleping123310423cl_eping
clerking15257163clerking
clewing13359583cl_ewing
clicking173610983clicking
climbing15205983climbing
clinching17276123clinching
cling86424673cl___ing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
clonings11307433clo_nings
closeting1236183closeting
closings11277673clo_sings
closuring1255173closuring
cloth105817543cloth___
clothe114712993cloth__e
clothed134010283cloth_ed
clothes124513813cloth_es
clothiers1443423clothiers
clothlike1842663clothlike
cloths115512483cloth__s
clubbing15266513clubbing
clucking17429993clucking
clueing104110093cl_ueing
cluing93913503cl__uing
clumping15319883clumping
clunking15329433clunking
coaching164011963coaching
coaling103722823c_oaling
coaming123818323c_oaming
coating103525313c_oating
coaxing173511703c_oaxing
cochin131313203c_ochin_
cochins141413103c_ochins
cocking163619983c_ocking
codding124014693c_odding
coding104024793c_o_ding
codling114418953c_odling
coffing163811253c_offing
cogging123513713c_ogging
coifing133213893c_oifing
coiling103723453c_oiling
coining103920543c_oining
coking134523883c_o_king
collying14319553collying
coloring11414843coloring
colouring1258733colouring
combing143714733c_ombing
coming114225453c_o_ming
comping143518593c_omping
coning94331823c_o_ning
conking143618453c_onking
conning103718753c_onning
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923c_o_oing
cooking143818973c_ooking
cooling103422573c_ooling
cooping123918933c_ooping
coopting133411313coopting
coping113927663c_o_ping
coplotting1555953coplotting
copping143918593c_opping
copying153411983c_opying
cording113620823c_ording
coring94433963c_o_ring
corking143018823c_orking
corning103720123c_orning
costing104323023c_osting
cosying134513133c_osying
cotinga10348023c_ot_inga
couching163213263couching
coughing15309213coughing
couping124317023c_ouping
coving124321523c_o_ving
cowing124526323c_o_wing
cowling134017423c_owling
coxing164218863c_o_xing
coying124021483c_o_ying
cozying22308063c_ozying
crashing143512633crashing
crating103725203crat_ing
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210883cropping
crossing112612683crossing
crouching1746383crouching
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crushing143010053crushing
crutching17216073crutching
cutting103817493c_utting
cuttling1138203cuttling
doting84821913_dot_ing
dotting93314483_dotting
earthing12310333earthing
elating83423083elat_ing
eloining9310443eloining
eloping103512833elo_ping
eluting84115293elut_ing
emoting10313563emot_ing
faithing1537153faithing
farthing1538073farthing
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
fleshing15339303fleshing
fletching18256143fletching
flitching18265343flitching
fliting113514613flit_ing
flitting123010883flitting
floating123111883floating
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouring123010143flouring
flouting122610473flouting
flowing143411763flo_wing
flushing15288833flushing
fluting113815093flut_ing
flyting14378553flyt_ing
footing115017593foot_ing
footling12239923footling
girthing13256083girthing
glitzing1934973glitzing
gloaming12268013gloaming
gloating102611463gloating
globing113210003glo_bing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glouting10379693glouting
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
glutting10247643glutting
hooting113919883hoot_ing
hotching17309313_hotching
hotting113116523_hotting
jolting153410913jolt_ing
joshing18519413_joshing
jotting152912773_jotting
kithing153411553_kithing
knotting13236573knotting
kything18285523_kything
lashing114422893_lashing
latching143712023_latching
lathings12469853_lathings
leching134613653_leching
letching143810263_letching
letting83218533_letting
lithoing1236743_lithoing
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
loathings1344213_loathings
lobbing123110913_lobbing
locking143718153_locking
locoing102810973_locoing
lodging103110813_lodging
lofting113311313_lofting
logging103316813_logging
loiding93313403_loiding
lolling83415783_lolling
longing93915783_longing
looing73621043_lo_oing
looking123415043_looking
looming102814853_looming
looping103615283_looping
loosing83515963_loosing
looting83019643_looting
loping93921413_lo_ping
lopping123815223_lopping
lording93115233_lording
losing74022873_lo_sing
louping104313983_louping
louring83916503_louring
lousing83817733_lousing
louting83719383_louting
loving104416723_lo_ving
lowing104623273_lo_wing
loxing143615273_lo_xing
lushing114316113_lushing
luting75221753_lut_ing
molting103517173molt_ing
mooching16259063mooching
mooting103019363moot_ing
moshing134214883_moshing
mouthing142810243mouthing
naething1236073naething
northing12199063northing
noshing114612773_noshing
notching14288583_notching
nothings12266683_nothings
noting74120153_not_ing
ohing96018813__o_hing
oohing104412933__oohing
photoing1439073photoing
piloting1139693pilot_ing
pithing134014053_pithing
plashing143311063plashing
plating103823073plat_ing
platting114813033platting
plaything1843853plaything
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plotline1037643plotline
ploughing16203673ploughing
plowing133111723plo_wing
ploying132811573plo_ying
pooching16328983pooching
poohing133112323_poohing
potting103720893_potting
quoting17310043quot_ing
rioting82716393riot_ing
rooting83522433root_ing
rootling9269953rootling
rotting82919683_rotting
scathing14269703scathing
scooching1735073scooching
scootching1843363scootching
scooting113012643scoot_ing
scotching1735653scotching
scything17264883scything
seething1239023seething
shotting123012383shotting
slashing123713413slashing
slating83724653slat_ing
slatting94014233slatting
sleuthing1334203sleuthing
slitting93012583slitting
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
slouching15195723slouching
sloughing14244753sloughing
slowing112814743slo_wing
slushing12299643slushing
smoothing1535293smoothing
sooting82820963soot_ing
southing122811823southing
sploshing1544293sploshing
splotching1842863splotching
spotting112812093spotting
stotting92811163stotting
swathing15248713swathing
swotting12268483swotting
teething1237163teething
thing96622983___thing
tithing113513893_tithing
tooting83019423toot_ing
tootling9279523tootling
toting74123793_tot_ing
totting82816843_totting
trithing122811773trithing
trotting92510913trotting
tything14316573_tything
voting103916033_vot_ing
withing143814493_withing
wooshing1536683wooshing
worthing15178053worthing
wotting112913843_wotting
wrathing15248923wrathing
writhing15278673writhing

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 Limit1461623837.34319904.9
3Display Results3833830.1402735.7
 (SQL Overall)1786913837.90622601.9
 
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.