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

468 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
clotting11311064(None) 
blotting113910431blotting
clothing14278781clothing
clouting113011681clouting
lotting82917751_lotting
plotting113011011plotting
slotting92612611slotting
allotting1046502allotting
blatting114111652blatting
bloating113512812bloating
catting103922642c_atting
chatting142810142chatting
cleating113518142cleating
clefting14347582clefting
cloaking15299712cloaking
clocking174312412clocking
clogging13368502clogging
clomping15329652clomping
cloning103215472clo_ning
clonking153810152clonking
clopping153511082clopping
closeting1236182closeting
closing103114842clo_sing
clothings15264432clothings
cloturing1245472cloturing
clouding12269492clouding
clouring112811272clouring
clowning14307252clowning
cloying133511752clo_ying
coating103525312c_oating
coopting133411312coopting
coplotting1555952coplotting
costing104323022c_osting
coting94629252c_o_ting
cutting103817492c_utting
dotting93314482_dotting
flatting123511252flatting
flitting123010882flitting
floating123111882floating
flouting122610472flouting
gloating102611462gloating
glouting10379692glouting
glutting10247642glutting
hotting113116522_hotting
jotting152912772_jotting
knotting13236572knotting
letting83218532_letting
lofting113311312_lofting
looting83019642_looting
louting83719382_louting
platting114813032platting
plotzing20276152plotzing
potting103720892_potting
rotting82919682_rotting
shotting123012382shotting
slatting94014232slatting
slitting93012582slitting
spotting112812092spotting
stotting92811162stotting
swotting12268482swotting
totting82816842_totting
trotting92510912trotting
wotting112913842_wotting
abetting1158293abetting
aborting11710253aborting
abutting1137003abutting
accosting1446733accosting
adopting1237453adopting
alerting91312383alerting
batting104422273_batting
beclothing1843873beclothing
besotting12256873besotting
betting103921403_betting
bitting103717293_bitting
blasting114013433blasting
bleating113514503bleating
blitzing2035903blitzing
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
blooding122410653blooding
blooming13299433blooming
blooping13248843blooping
blotching1734963blotching
blottier10336413blottier
blousing1138793blousing
blowing133813053blo_wing
blunting11319843blunting
blurting11258773blurting
boating103721303_boating
bolting104416763_bolting
boosting113311053boosting
booting103821363_booting
bottling11279143_bottling
butting103519283_butting
canting104725903c_anting
carting104228283c_arting
casting104628343c_asting
castling11311233castling
catling104819793c_atling
cavorting1536063cavorting
centring112112953centring
chanting143413533chanting
charting142614193charting
cheating144014523cheating
chitling142910663chitling
chocking204011013chocking
choiring14279793choiring
choking173911943cho_king
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
choring133617663cho_ring
chortling1535563chortling
chousing14259423chousing
chowing164412773cho_wing
chowsing17217343chowsing
chuting132910733c_huting
citing94220183c__iting
clacking173313493clacking
cladding1337143cladding
clagging13328883clagging
claiming13279303claiming
clamming15329373clamming
clamping154011153clamping
clanging124012123clanging
clanking154313063clanking
clapping153810603clapping
clashing143812193clashing
clasping133310263clasping
classing113211793classing
clattering13109233clattering
clawing133812673cl_awing
claying133614303cl_aying
cleaning113112383cleaning
clearing113014883clearing
cleaving141389683cleaving
cleeking15267813cleeking
cleping123310423cl_eping
clerking15257163clerking
clewing13359583cl_ewing
clicking173610983clicking
climbing15205983climbing
cling86424673cl___ing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
clonings11307433clo_nings
closings11277673clo_sings
closuring1255173closuring
clothier1335363clothier
clotted104011823clott_ed
clotty11208263clott__y
clubbing15266513clubbing
clucking17429993clucking
clueing104110093cl_ueing
cluing93913503cl__uing
clumping15319883clumping
clunking15329433clunking
clutching17154823clutching
cluttering13106833cluttering
coacting133412703coacting
coaling103722823c_oaling
coaming123818323c_oaming
coapting133511613coapting
coasting113615513coasting
coatings113811843c_oatings
coaxing173511703c_oaxing
cocking163619983c_ocking
codding124014693c_odding
coding104024793c_o_ding
codling114418953c_odling
coffing163811253c_offing
cogging123513713c_ogging
cohosting1546323cohosting
coifing133213893c_oifing
coiling103723453c_oiling
coining103920553c_oining
coking134523883c_o_king
collating12312783collating
colleting12311063colleting
collying14319553collying
colocating1548623colocating
coloring11414843coloring
colouring1258733colouring
combing143714733c_ombing
coming114225453c_o_ming
comping143518593c_omping
complotting18124263complotting
compting153013603compting
coning94331833c_o_ning
conking143618453c_onking
conning103718763c_onning
cooeeing1137463cooeeing
cooeying1438153cooeying
cooing94024923c_o_oing
cooking143818973c_ooking
cooling103422573c_ooling
cooping123918933c_ooping
coping113927663c_o_ping
copping143918593c_opping
copying153411983c_opying
cording113620823c_ording
coring94433963c_o_ring
corking143018823c_orking
corning103720133c_orning
corotating1349323corotating
cortin82423153c_ortin_
cortina91915973c_ortina
cortins92421333c_ortins
coshing134316433c_oshing
cosying134513133c_osying
cotinga10348023c_o_tinga
cottier93814173c_ottier
cotton8312993c_otton_
cottoning1237343c_ottoning
cottons9312193c_ottons
cottony1237253c_ottony
counting113115273counting
couping124317023c_ouping
courting112514573courting
coveting141912313coveting
coving124321523c_o_ving
cowing124526323c_o_wing
cowling134017423c_owling
coxing164218863c_o_xing
coying124021483c_o_ying
cozying22308073c_ozying
crafting143710173crafting
crating103725203c_rating
creating113921953creating
cresting114017043cresting
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210893cropping
crossing112612693crossing
crostini1038293crostini
crostino1038883crostino
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crusting113612793crusting
cuittling1234103cuittling
curating11314293curating
curetting1236573curetting
cuttings11277613c_uttings
cuttling1138203cuttling
doating93816863_doating
doting84821913_do_ting
dratting10389663dratting
duetting1047183duetting
elating83423083el_ating
electing112113783electing
eloining9310443eloining
eloping103512833elo_ping
eluting84115293el_uting
emitting112410353emitting
emoting10313563emo_ting
fatting113818703_fatting
fetting113517873_fetting
fitting113516563_fitting
flatling123410013flatling
fleeting122910323fleeting
flinting123412343flinting
flirting12319013flirting
fliting113514613fl_iting
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouring123010143flouring
flowing143411763flo_wing
fluting113815093fl_uting
flyting14378553fl_yting
footing115017593_footing
footling12239923footling
fretting122711523fretting
fritting123510703fritting
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
garotting1136113garotting
gavotting1443193gavotting
getting93316563_getting
ghosting1336463ghosting
gitting93215703_gitting
gleeting10279173gleeting
glinting103210053glinting
glitzing1934973glitzing
gloaming12268013gloaming
globing113210003glo_bing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glottic1036653glotti_c
glottis837173glotti_s
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
gritting10309983gritting
grouting103410793grouting
gutting93415923_gutting
hatting113920233_hatting
hitting113017273_hitting
hooting113919883_hooting
hosting114318383_hosting
hutting113016033_hutting
inletting1087873inletting
jetting153815343_jetting
jolting153410913_jolting
jottings16275193_jottings
jutting153313713_jutting
kitting123214443_kitting
knitting13257023knitting
knottings14243073knottings
knouting13226793knouting
lasting84725243_lasting
lathing114315693_lathing
lattin64316223_lattin_
lattins74115483_lattins
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
loathing1247673_loathing
lobbing123110913_lobbing
locating11311503_locating
locking143718153_locking
locoing102810973_locoing
lodging103110813_lodging
logging103316813_logging
loiding93313403_loiding
lolling83415783_lolling
longing93915783_longing
looing73621043_lo_oing
looking123415043_looking
looming102814853_looming
looping103615283_looping
loosing83515963_loosing
loping93921413_lo_ping
lopping123815223_lopping
lording93115233_lording
losing74022873_lo_sing
louping104313983_louping
louring83916503_louring
lousing83817733_lousing
loving104416723_lo_ving
lowing104623273_lo_wing
loxing143615273_lo_xing
lunting83817743_lunting
lusting83619323_lusting
luting75221753_l_uting
matting103620143_matting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
netting84018763_netting
notating92513343_notating
nothing113511903_nothing
noting74120153_no_ting
nutting83316233_nutting
omitting11217743omitting
opting94514403__opting
outing74128153__outing
patting103722343_patting
petting103720953_petting
photoing1439073photoing
piloting1139693pilo_ting
pitting103618873_pitting
plaiting113113513plaiting
planting113515383planting
plating103823073pl_ating
pleating112916053pleating
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plotline1037643plotline
plottier10327263plottier
plotties103111413plotties
plowing133111723plo_wing
ploying132811573plo_ying
porting103021783_porting
posting105622243_posting
pouting103519943_pouting
putting103218573_putting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
ratting83822363_ratting
reclothing1644973reclothing
reletting102713943reletting
replotting1357043replotting
repotting12511123repotting
retting83425883_retting
rioting82716393rio_ting
roosting93411463roosting
rooting83522433_rooting
rootling9269953rootling
rotating92614553_rotating
routing83821093_routing
rutting82718043_rutting
scatting113311813scatting
scooting113012643scooting
scouting112612753scouting
setting83621393_setting
shitting123212663shitting
shooting122812863shooting
shorting122514803shorting
shouting122711793shouting
shutting12309693shutting
sitting83519633_sitting
slanting94115093slanting
slating83724653sl_ating
slattings10346073slattings
sleeting93114163sleeting
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slowing112814743slo_wing
smutting11278063smutting
snooting92813203snooting
snorting92613373snorting
snouting92511923snouting
solating9315593solating
soothing12269973soothing
sooting82820963_sooting
sorting83221813_sorting
spatting113111763spatting
spitting113012323spitting
splatting1235983splatting
splitting1236563splitting
sporting112415463sporting
spouting113511953spouting
stetting93410713stetting
swatting12309593swatting
tatting84019523_tatting
toiting83217093_toiting
toothing12278863toothing
tooting83019423_tooting
tootling9279523tootling
toting74123793_to_ting
touting84118453_touting
trothing122410843trothing
tutting83515913_tutting
twitting12307223twitting
unclothing1644133unclothing
vatting113614853_vatting
vetting114216563_vetting
voting103916033_vo_ting
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wonting113214103_wonting

Search took 9 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.403443402.0
2DLD Change Limit1461624687.56319325.9
3Display Results4684680.2032305.4
 (SQL Overall)1786914688.16921874.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.