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

206 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
thumbing1624551(None) 
thumping16296711thumping
chumming18366202chumming
chumping18349062chumping
crumbing15267812crumbing
dumbing13319852_dumbing
humbling16208672_humbling
humming153310672_humming
humping153213072_humping
numbing12269032_numbing
plumbing15286432plumbing
rhumbaing1742242rhumbaing
theming133610472them_ing
thrumming1742902thrumming
thudding1433982thudding
thumbkin1942112thumbkin_
thumbkins2042162thumbkins
thunking16196952thunking
tombing123310532t_ombing
trumping13308732trumping
tubbing123510092t_ubbing
tubing93813092t_u_bing
tumbling13219292t_umbling
tumping123114242t_umping
whumping19325402whumping
bedumbing1742843bedumbing
benumbing1642953benumbing
bethumping2042023bethumping
blubbing12257013blubbing
bluming123511283blum_ing
blurbing13326503blurbing
bombing143211393_bombing
bumbling15249763_bumbling
bumming143410783_bumming
bumping143812493_bumping
champing183610933champing
chiming153311833chim_ing
chomping18339883chomping
chucking20379503chucking
chuffing2055043chuffing
chugging1634913chugging
chunking18328053chunking
churning14237173churning
churring14298653churring
chuting132910733chu_ting
climbing15205983climbing
clubbing15266513clubbing
clumping15319883clumping
combing143714733_combing
crumbling1655083crumbling
crumping15319903crumping
cubing114213953_cu_bing
curbing123814023_curbing
daubing11358623dau_bing
drubbing14286053drubbing
drumbling1544033drumbling
drumming14265783drumming
dubbing133311213_dubbing
dumping133712913_dumping
exhuming2143303exhum_ing
flubbing16275883flubbing
fluming133512793flum_ing
flumping16287583flumping
fubbing15409573_fubbing
fumbling16208163_fumbling
fuming124013293_fum_ing
gauming11319713gaum_ing
grubbing14295403grubbing
grumbling1544083grumbling
grumping14266903grumping
gumming133810193_gumming
hamming153014093_hamming
hemming15269973_hemming
hobbing152811123_hobbing
homing123718383_hom_ing
huffing17278833_huffing
hugging132710633_hugging
hulking153910983_hulking
hulling113619013_hulling
humbug1434803_humb_ug
humoring1456853_humoring
humphing1935163_humphing
hunting114317123_hunting
hurling113616413_hurling
hurting113914033_hurting
hushing144514473_hushing
husking154312053_husking
hutting113016033_hutting
hymning1635183_hymning
inhuming1435853inhum_ing
jambing19328533_jambing
jumbling20217233_jumbling
jumping19319803_jumping
lambing123412413_lambing
limbing123410423_limbing
lubing94114043_lu_bing
lumping123314643_lumping
mumbling15198533_mumbling
mumming114010023_mumming
mumping143411633_mumping
plumbings16213363plumbings
pluming123412043plum_ing
plumping15277633plumping
pumping144213553_pumping
rhyming1634043rhym_ing
rubbing123412273_rubbing
rumbaing13185303_rumbaing
rumbling131910103_rumbling
scumbling1634423scumbling
scumming15256793scumming
shambling1735593shambling
shaming133016743sham_ing
shamming16289413shamming
shimming16278253shimming
shlumping1733373shlumping
shucking18339433shucking
shunning12367843shunning
shunting123610433shunting
shushing15317743shushing
shuting113212053shu_ting
shutting12309693shutting
slubbing13248033slubbing
slumming13278383slumming
slumping13359973slumping
snubbing13236673snubbing
spuming1248523spum_ing
strumming1454413strumming
stubbing13237453stubbing
stumbling1435003stumbling
stumming13347673stumming
stumping13289083stumping
subbing123915583_subbing
summing122912383_summing
tabbing123611913t_abbing
taming94023433t_am_ing
tamping122815813t_amping
taunting93510933taunting
tauting83316383tau_ting
teaming103917593team_ing
teeming103513093teem_ing
temping122710693t_emping
terming104016003term_ing
thacking183110043thacking
thanking16409523thanking
thawing14378683th_awing
thieving1535143thieving
thing96622983th___ing
thinking16289863thinking
thinning12319093thinning
thirling12248583thirling
tholing112812333th_oling
thorning1237513thorning
thouing11258603th_ouing
thrawing1535963thrawing
thriving15246353thriving
throbbing1743533throbbing
thrombin15104933thrombin_
thrombins1684713thrombins
throning1238863throning
throwing1536723throwing
thrusting1335013thrusting
thumb124511283thumb___
thumbed15336173thumb_ed
thumbnut15122743thumbnut
thumbprint1951943thumbprint
thumbs13377443thumb__s
thymine1536643thym_ine
timing93619303t_im_ing
tomming12359243t_omming
touching143211343touching
toughing13278553toughing
touring82915193tou_ring
tousing82916993tou_sing
tousling938793tousling
touting84118453tou_ting
touzling1835503touzling
tramming13279343tramming
tramping132711273tramping
trembling1435193trembling
trimming13318653trimming
tromping13319603tromping
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trussing9268653trussing
trusting93411653trusting
tubings10336483t_u_bings
tucking143415183t_ucking
tufting11289873t_ufting
tugging102611233t_ugging
tumblings14184843t_umblings
tuning74016843t_u_ning
tunning83514453t_unning
tupping123411663t_upping
turbine9310303t_urbine
turfing113010053t_urfing
turning83713183t_urning
tushing114214013t_ushing
tusking124212063t_usking
tutting83515913t_utting
umping114815333__umping
whamming19275223whamming
whomping19285943whomping
whupping19345243whupping

Search took 7 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 Limit1461622066.07624055.6
3Display Results2062060.0762710.5
 (SQL Overall)1786912066.57527177.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.