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

307 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
stumming1334767(None) 
scumming15256791scumming
slumming13278381slumming
stemming13408201stemming
strumming1454411strumming
stumping13289081stumping
summing122912381s_umming
bumming143410782_bumming
chumming18366202chumming
drumming14265782drumming
gumming133810192_gumming
humming153310672_humming
mumming114010022_mumming
scamming15328542scamming
scrumming1654022scrumming
shamming16289412shamming
shimming16278252shimming
skimming17286272skimming
slamming133310002slamming
slimming13288092slimming
slumping13359972slumping
spamming15317602spamming
spuming1248522spu_ming
stamping133310962stamping
steaming114013212steaming
stimying1437502stimying
stomping13309762stomping
storming11209422storming
stubbing13237452stubbing
studding1136702studding
studying1335552studying
stuffing15247842stuffing
stumbling1435002stumbling
stunning9298462stunning
stunting92811502stunting
stymying1733962stymying
swimming16316322swimming
tomming12359242_tomming
tumping123114242_tumping
assuming1135143assu_ming
bamming144611813_bamming
bluming123511283blu_ming
brimming15196623brimming
bumping143812493_bumping
chumping18349063chumping
clamming15329373clamming
clumping15319883clumping
costuming1445283costu_ming
cramming15339433cramming
crumbing15267813crumbing
crumping15319903crumping
culming123811183_culming
cummin1288783_cummin_
cummins1358963_cummins
damming133812743_damming
degumming1643133degumming
dimming13339593_dimming
dramming14347573dramming
dumbing13319853_dumbing
dummying17263723_dummying
dumping133712913_dumping
esteeming1244703esteeming
flamming16357153flamming
fluming133512793flu_ming
flumping16287583flumping
fuming124013293_fu_ming
gamming133112623_gamming
gauming11319713gau_ming
gemming13289153_gemming
glomming14275923glomming
grumping14266903grumping
hamming153014093_hamming
hemming15269973_hemming
humping153213073_humping
iteming1037753it_eming
jamming19329793_jamming
jumping19319803_jumping
lamming123014583_lamming
lemming12269393_lemming
lumping123314643_lumping
mummying15263723_mummying
mumping143411633_mumping
nimming12358143_nimming
numbing12269033_numbing
plumbing15286433plumbing
pluming123412043plu_ming
plumping15277633plumping
primming15268173primming
pumping144213553_pumping
ramming123115063_ramming
rimming123411073_rimming
saucing10311003sau_cing
saunaing937013saunaing
sauteing937913sauteing
scamping153510193scamping
scheming1636633scheming
scramming1634883scramming
scubaing1335733scubaing
scudding1335673scudding
scuffing17287113scuffing
sculking15307913sculking
sculling112910993sculling
sculping13298943sculping
scumbling1634423scumbling
scummier1445083scummier
scummily1743303scummily
seaming103222113s_eaming
seeming103216263s_eeming
shaming133016743s_haming
shammying2042953shammying
shimmying2042533shimmying
shlumping1733373shlumping
shucking18339433shucking
shunning12367843shunning
shunting123610433shunting
shushing15317743shushing
shuting113212053shu_ting
shutting12309693shutting
situating1038883situating
skimmings18243263skimmings
skimping17306243skimping
skulking12245903skulking
skulling13258103skulling
skunking12256653skunking
slammings14234123slammings
sliming102913953s_liming
slubbing13248033slubbing
sludging11268363sludging
sluffing15247303sluffing
slugging11339423slugging
sluicing1137063sluicing
sluing74315883slu__ing
slummier1235473slummier
slurping11278123slurping
slurring9288833slurring
slushing12299643slushing
smudging13255723smudging
smushing14287453smushing
smutting11278063smutting
snubbing13236673snubbing
snuffing15256803snuffing
snugging11286933snugging
soughing13259733soughing
sounding102712873sounding
souping104215533sou_ping
sourcing1158353sourcing
souring83219063sou_ring
sousing83517823sou_sing
southing122811823southing
spasming13227203spasming
spudding1335653spudding
spuing94313363spu__ing
spunking15258063spunking
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
squaring18158633squaring
squiring18177563squiring
squirming2143223squirming
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
staffing15247493staffing
stagging113310513stagging
staging93818373st_aging
staining9413373staining
staking123919803st_aking
staling83925423st_aling
stalking133512223stalking
stalling95116703stalling
stamina9310793st_amina
stammering1544523stammering
standing103413633standing
stanging104013653stanging
staning83922243st_aning
stapling112813153stapling
staring84527053st_aring
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
stashing123511583stashing
stating83725163st_ating
staving113915703st_aving
staying114017323st_aying
steading103613593steading
stealing93416603stealing
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemmier1245253stemmier
stepping13329073stepping
sterling93615553sterling
stetting93410713stetting
stewing113412493st_ewing
sticking153513463sticking
stiffing15248703stiffing
stifling122110913stifling
stilling93415323stilling
stilting93312403stilting
sting65330243st___ing
stinging103213453stinging
stinking133113543stinking
stinting93415743stinting
stirring9299653stirring
stobbing13227243stobbing
stocking152912503stocking
stodging11277463stodging
stoking123615593st_oking
stoning83717443st_oning
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stooping113012363stooping
stoping103716623st_oping
stopping133611413stopping
storing83921123st_oring
storying12249673storying
stotting92811163stotting
stounding1136233stounding
stowing113315133st_owing
strafing122111193strafing
strawing122411623strawing
straying122912693straying
streaming12239653streaming
strewing12289853strewing
striding102713603striding
striking133012233striking
string75327563st__ring
striping112612523striping
striving122611393striving
stroking132610943stroking
strowing122310563strowing
stroying122410593stroying
strunting1037873strunting
strutting1037003strutting
stuccoing1442493stuccoing
studdings1242933studdings
stuffings16233493stuffings
stummed12348553stumm_ed
stumpier1255883stumpier
stung65417153stu___ng
stying105414573st__ying
styling112910653st_yling
stymieing1542593stymieing
subbing123915583s_ubbing
subring104116263s_ubring
sucking143217413s_ucking
sudsing92910323s_udsing
sueding92613753s_ueding
sughing12359713s_ughing
suing65026363s_u__ing
suiting83419003s_uiting
sulking124514313s_ulking
summand1236263s_ummand
summating1437943s_ummating
summering1458753s_ummering
summit10311543s_ummi_t
summiting1445793s_ummiting
summits1137983s_ummits
summon1037623s_ummon_
summoning14115693s_ummoning
summons1158003s_ummons
sunning83715673s_unning
supping123814533s_upping
surfing112914483s_urfing
surging93115433s_urging
sussing84013703s_ussing
suturing9310373suturing
swamping16307923swamping
swarming1458223swarming
swimmings17263153swimmings
taming94023433_t_aming
tamping122815813_tamping
teaming103917593_teaming
teeming103513093_teeming
temping122710693_temping
terming104016003_terming
theming133610473_theming
thrumming1742903thrumming
thumbing16245513thumbing
thumping16296713thumping
timing93619303_t_iming
tombing123310533_tombing
tramming13279343tramming
trimming13318653trimming
trumping13308733trumping
tubbing123510093_tubbing
tubing93813093_tu_bing
tucking143415183_tucking
tufting11289873_tufting
tugging102611233_tugging
tumbling13219293_tumbling
tummies113012033_tummies
tuning74016843_tu_ning
tunning83514453_tunning
tupping123411663_tupping
turfing113010053_turfing
turning83713183_turning
tushing114214013_tushing
tusking124212063_tusking
tutting83515913_tutting
umping114815333__umping
whamming19275223whamming
whumping19325403whumping

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.843211970.3
2DLD Change Limit1461623077.31319986.6
3Display Results3073070.1262436.5
 (SQL Overall)1786913078.28221575.8
 
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.