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

253 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
thumping1629671(None) 
chumping18349061chumping
humping153213071_humping
thumbing16245511thumbing
trumping13308731trumping
tumping123114241t_umping
whumping19325401whumping
bethumping2042022bethumping
bumping143812492_bumping
champing183610932champing
chomping18339882chomping
chumming18366202chumming
clumping15319882clumping
crumping15319902crumping
dumping133712912_dumping
flumping16287582flumping
grumping14266902grumping
humming153310672_humming
humphing1935162_humphing
jumping19319802_jumping
lumping123314642_lumping
mumping143411632_mumping
plumping15277632plumping
pumping144213552_pumping
shlumping1733372shlumping
slumping13359972slumping
stumping13289082stumping
tamping122815812t_amping
temping122710692t_emping
theming133610472them_ing
thrumming1742902thrumming
thudding1433982thudding
thunking16196952thunking
tramping132711272tramping
tromping13319602tromping
tupping123411662t_upping
umping114815332__umping
whomping19285942whomping
whupping19345242whupping
amping114317573__amping
bluming123511283blum_ing
bumming143410783_bumming
burping124012943_burping
camping143118973_camping
chapping183710723chapping
cheeping16329553cheeping
chiming153311833chim_ing
chipping18389793chipping
chirping16278863chirping
chopping183710263chopping
chucking20379503chucking
chuffing2055043chuffing
chugging1634913chugging
chunking18328053chunking
churning14237173churning
churring14298653churring
chuting132910733chu_ting
clamping154011153clamping
clomping15329653clomping
comping143518593_comping
couping124317023cou_ping
cramping153411853cramping
crimping15299783crimping
crumbing15267813crumbing
crumpling1645323crumpling
cupping144312383_cupping
damping133414003_damping
drumming14265783drumming
dumbing13319853_dumbing
dumpings14295763_dumpings
dumpling14217893_dumpling
duping104113633_du_ping
dupping133711043_dupping
exhuming2143303exhum_ing
fluming133512793flum_ing
fuming124013293_fum_ing
gauming11319713gaum_ing
gazumping2441443gazumping
gimping133710763_gimping
gulping11309753_gulping
gumming133810193_gumming
hamming153014093_hamming
happing153817233_happing
harping134118383_harping
hasping134414903_hasping
heaping133015853_heaping
helping133512223_helping
hemming15269973_hemming
hipping153915103_hipping
homing123718383_hom_ing
hooping133615703_hooping
hoping123719743_h_oping
hopping154115273_hopping
huffing17278833_huffing
hugging132710633_hugging
hulking153910983_hulking
hulling113619013_hulling
humbling16208673_humbling
humoring1456853_humoring
humpier143110723_humpier
hunting114317123_hunting
hurling113616413_hurling
hurting113914033_hurting
hushing144514473_hushing
husking154312053_husking
hutting113016033_hutting
hymning1635183_hymning
hyping15408483_h_yping
imping114315353__imping
inhuming1435853inhum_ing
jauping17307193jau_ping
lamping123116003_lamping
limping124614113_limping
louping104313983lou_ping
mumming114010023_mumming
numbing12269033_numbing
outjumping2242973outjumping
pimping143812123_pimping
plumbing15286433plumbing
pluming123412043plum_ing
primping15338893primping
pulping123612323_pulping
pupping114412503_pupping
ramping123316873_ramping
repumping1634813repumping
rhumbaing1742243rhumbaing
rhyming1634043rhym_ing
romping123113033_romping
rouping103715793rou_ping
rumpling13178763_rumpling
scamping153510193scamping
schlumping2041943schlumping
sculping13298943sculping
scumming15256793scumming
shaming133016743sham_ing
shamming16289413shamming
shaping133116183sh_aping
sharping143011373sharping
shimming16278253shimming
shipping163611253shipping
shopping163611293shopping
shrimping1734063shrimping
shucking18339433shucking
shunning12367843shunning
shunting123610433shunting
shushing15317743shushing
shuting113212053shu_ting
shutting12309693shutting
skimping17306243skimping
slumming13278383slumming
slurping11278123slurping
souping104215533sou_ping
spuming1248523spum_ing
stamping133310963stamping
stomping13309763stomping
strumming1454413strumming
stumming13347673stumming
summing122912383_summing
supping123814533_supping
swamping16307923swamping
taming94023433t_am_ing
taping94222393t__aping
tapping123317133t_apping
taunting93510933taunting
tauting83316383tau_ting
teaming103917593team_ing
teeming103513093teem_ing
tempting1357343t_empting
terming104016003term_ing
thacking183110043thacking
thanking16409523thanking
thawing14378683th_awing
thieving1535143thieving
thing96622983th___ing
thinking16289863thinking
thinning12319093thinning
thirling12248583thirling
tholing112812333th_oling
thorning1237513thorning
thouing11258603th_ouing
thrawing1535963thrawing
threaping15106113threaping
threeping15104803threeping
thriving15246353thriving
throning1238863throning
throwing1536723throwing
thrusting1335013thrusting
thumbkin1942113thumbkin_
thumbkins2042163thumbkins
thumbprint1951943thumbprint
thump126211573thump___
thumped15387413thump_ed
thumper14356953thump_er
thumpers15365713thumpers
thumps13449353thump__s
thymine1536643thym_ine
timing93619303t_im_ing
tipping122814973t_ipping
tombing123310533t_ombing
tomming12359243t_omming
toping94122993t__oping
topping123514623t_opping
touching143211343touching
toughing13278553toughing
touring82915193tou_ring
tousing82916993tou_sing
tousling938793tousling
touting84118453tou_ting
touzling1835503touzling
tramming13279343tramming
trampling1436973trampling
trapping132911393trapping
trimming13318653trimming
tripping133210923tripping
triumphing1842243triumphing
trooping112710283trooping
trouping11249503trouping
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trumpeting1543573trumpeting
trussing9268653trussing
trusting93411653trusting
tubbing123510093t_ubbing
tubing93813093t_u_bing
tucking143415183t_ucking
tufting11289873t_ufting
tugging102611233t_ugging
tumbling13219293t_umbling
tumpline1237113t_umpline
tuning74016843t_u_ning
tunning83514453t_unning
turfing113010053t_urfing
turning83713183t_urning
tushing114214013t_ushing
tusking124212063t_usking
tutting83515913t_utting
typing124110583t__yping
upping114013703__upping
urping93914053__urping
usurping1134163usurping
vamping152810233_vamping
whamming19275223whamming
whapping19317113whapping
wheeping17337103wheeping
whelping17245333whelping
whipping19328173whipping
whooping17286633whooping
whopping19357373whopping
wimping153911013_wimping
yauping13357243yau_ping

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.420425454.8
2DLD Change Limit1461622536.98620922.1
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.49923828.6
 
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.