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

243 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
drumming1426578(None) 
dramming14347571dramming
brimming15196622brimming
bumming143410782_bumming
chumming18366202chumming
cramming15339432cramming
crumbing15267812crumbing
crumping15319902crumping
damming133812742d_amming
degumming1643132degumming
dimming13339592d_imming
dreaming124011062dreaming
drubbing14286052drubbing
drudging12256232drudging
drugging12326442drugging
drumbling1544032drumbling
drumlin1044422drumlin_
drumlins1144992drumlins
dumbing13319852d_umbing
dummying17263722d_ummying
dumping133712912d_umping
grumping14266902grumping
gumming133810192_gumming
humming153310672_humming
mumming114010022_mumming
primming15268172primming
ramming123115062_ramming
rimming123411072_rimming
scrumming1654022scrumming
scumming15256792scumming
slumming13278382slumming
strumming1454412strumming
stumming13347672stumming
summing122912382_summing
thrumming1742902thrumming
tramming13279342tramming
trimming13318652trimming
trumping13308732trumping
arming94719803ar__ming
bamming144611813_bamming
bluming123511283blu_ming
breaming133612513breaming
brooming132911143brooming
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993bru_ting
bruxing17236823bru_xing
bumping143812493_bumping
chumping18349063chumping
clamming15329373clamming
clumping15319883clumping
cramping153411853cramping
creaming133413143creaming
crimping15299783crimping
crudding1335723crudding
cruising112610153cruising
crumbling1655083crumbling
crummie1336153crummi_e
crummier1435603crummier
crummies1437643crummies
crumpling1645323crumpling
crushing143010053crushing
crusting113612793crusting
culming123811183_culming
cummin1288783_cummin_
cummins1358963_cummins
damning114211633d_amning
damping133414003d_amping
daubing11358623dau_bing
daunting103310403daunting
dauting93814763dau_ting
deeming113913123d_eeming
defaming15238463defaming
deliming12310373deliming
demoing11311753d_emoing
deucing1139393deu_cing
doming104218393d__oming
dooming113112533d_ooming
doubling1238153doubling
doubting1237373doubting
douching15349843douching
dousing93315763dou_sing
drabbing14286803drabbing
drafting13339413drafting
dragging12308103dragging
draining103312673draining
draping114213353dr_aping
dratting10389663dratting
drawing123812053dr_awing
drawling13318673drawling
draying123813843dr_aying
dreading113712803dreading
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
dribbing14325883dribbing
drifting13338733drifting
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dr_iving
drolling103510763drolling
droning93013723dr_oning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drubbings15262883drubbings
drumfire1442543drumfire
drumfish1743503drumfish
drumlier1134523drumlier
drumlike1543793drumlike
drummed13306323drumm_ed
drummer12407503drumm_er
drummers13316163drummers
drying113411603dr__ying
dubbing133311213d_ubbing
ducking154315053d_ucking
ducting113713593d_ucting
duding93913323d_u_ding
dueling93614543d_ueling
dueting93814393d_ueting
duking124715133d_u_king
dulling93418273d_ulling
dummied13346723d_ummied
dummies123012133d_ummies
dumpings14295763d_umpings
dumpling14217893d_umpling
dunging103012623d_unging
dunking133813263d_unking
dunning93514473d_unning
dunting93418383d_unting
duping104113633d_u_ping
dupping133711043d_upping
during84419403d_u_ring
durning93511733d_urning
dusking133912053d_usking
dusting93618993d_usting
eructing112110173eructing
erupting11218443erupting
flamming16357153flamming
fluming133512793flu_ming
flumping16287583flumping
framing133014793fr_aming
frugging14317053frugging
fruiting12229063fruiting
fuming124013293_fu_ming
gamming133112623_gamming
gauming11319713gau_ming
gemming13289153_gemming
glomming14275923glomming
griming113612493gr_iming
grooming12309513grooming
grubbing14295403grubbing
grudging12255993grudging
grueling1078273grueling
gruffing1635273gruffing
grumbling1544083grumbling
grummeting1642453grummeting
grunting10269583grunting
hamming153014093_hamming
hemming15269973_hemming
humping153213073_humping
jamming19329793_jamming
jumping19319803_jumping
lamming123014583_lamming
lemming12269393_lemming
lumping123314643_lumping
mummying15263723_mummying
mumping143411633_mumping
nimming12358143_nimming
numbing12269033_numbing
plumbing15286433plumbing
pluming123412043plu_ming
plumping15277633plumping
priming123417373pr_iming
primping15338893primping
promoing13310463promoing
pruning10311733pru_ning
pumping144213553_pumping
ramping123316873_ramping
reaming103924013_reaming
rhyming1634043_rhyming
riming93322223_r_iming
roaming103215793_roaming
romping123113033_romping
rooming104117043_rooming
rubbing123412273_rubbing
rubying13297933_rubying
ruching133612933_ruching
rucking143216673_rucking
ruffing143210843_ruffing
rugging102512763_rugging
ruing67221053_ru__ing
ruining83514883_ruining
ruling73219553_ru_ling
rumbaing13185303_rumbaing
rumbling131910103_rumbling
rumina83412483_ru_mina
rummaging1543363_rummaging
rummier11309563_rummier
rummies113212793_rummies
rumoring1136983_rumoring
rumpling13178763_rumpling
running83514593_running
rushing113817703_rushing
rusting83821263_rusting
rutting82718043_rutting
scamming15328543scamming
scramming1634883scramming
shamming16289413shamming
shimming16278253shimming
skimming17286273skimming
slamming133310003slamming
slimming13288093slimming
slumping13359973slumping
spamming15317603spamming
spuming1248523spu_ming
stemming13408203stemming
stumping13289083stumping
swimming16316323swimming
thumbing16245513thumbing
thumping16296713thumping
tomming12359243_tomming
tramping132711273tramping
trimmings14254453trimmings
tromping13319603tromping
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trussing9268653trussing
trusting93411653trusting
tumping123114243_tumping
umping114815333__umping
vrooming14287353vrooming
whamming19275223whamming
whumping19325403whumping

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 Limit1461622437.01620832.7
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.53223724.2
 
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.