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

489 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
thumps1344935(None) 
chumps154313821chumps
humps126322801_humps
thumbs13377441thumbs
thump126211571thump_
trumps104611881trumps
tumps95420791t_umps
whumps16427091whumps
bethumps1741992bethumps
bumps115921142_bumps
champs154915682champs
chimps155713662chimps
chomps155112222chomps
chump145315442chump_
chums125015832chum_s
clumps1215314642clumps
crumps124514342crumps
dumps105220102_dumps
flumps135112502flumps
frumps13479782frumps
grumps114510572grumps
hemps126917332_hemps
hump116228722_hump_
humph155712212_humph
humphs16528162_humphs
humpy155115672_humpy
hums96831422_hum_s
humus106215072_humus
jumps165116492_jumps
lumps95624982_lumps
mumps115619102_mumps
plumps124612612plumps
pumps115520602_pumps
rhumbs13366772rhumbs
rumps95922292_rumps
shlumps1434142shlumps
slumps104313582slumps
stumps104912282stumps
sumps95023432_sumps
tamps95524082t_amps
temps95417132t_emps
themes115319252themes
thesps11448262thesps
thorps113610892thorps
thrips11299012thrips
thrums11429122thrum_s
thuds95110132thu_ds
thugs95611992thu_gs
thujas1634432thujas
thumb124511282thum_b
thumped15387412thumped
thumper14356952thumper
thumpers15365712thumpers
thunks13459032thunks
thurls9418712thurls
thus76721472thu__s
thuyas1234772thuyas
thymes144810742thymes
thymus14324732thymus
tramps105114452tramps
tromps104911702tromps
trump95615122trump_
tump85927032t_ump_
tups65628762t_u_ps
turps74918732t_urps
umps85721942__umps
whomps16457602whomps
whump154910042whump_
whups134210002whu_ps
abamps1236253abamps
alums75720603alum_s
amps86230343__amps
arums75517833arum_s
bethump1642823bethump_
bhuts105812953bhu_ts
blimps12588153blimps
blumes105917793blumes
brumes106417073brumes
bumfs125414053_bumfs
bump106228243_bump_
bumph144911983_bumph
bumphs15467103_bumphs
bumpy144715053_bumpy
bums85934593_bum_s
burps94220173_burps
camps116330263_camps
champ145017963champ_
champy18509613champy
chams126028503cham_s
chaps125326063ch_aps
cheaps134613683cheaps
cheeps135312913cheeps
chemos13311723chemos
chimbs153910303chimbs
chimes134922573chimes
chimp145216473chimp_
chips125721253ch_ips
chirps135414003chirps
chomp144815663chomp_
chops125019873ch_ops
chubs125412623chu_bs
chucks174812933chucks
chufas14397673chufas
chuffs17427783chuffs
chugs115511943chu_gs
chum116318003chum__
chummy18385893chummy
chumped17379493chumped
chunks154210333chunks
chuppa1543973chuppa
chuppas1644123chuppas
churls115411073churls
churns114910233churns
churrs115111513churrs
chutes114615763chutes
chymes165912153chymes
clamps124515083clamps
clomps125212233clomps
clump115517453clump_
clumpy15409573clumpy
comps115526053_comps
coups95522473cou_ps
cramps125615563cramps
crimps124613453crimps
crumbs12409233crumbs
crump115616423crump_
cups85430823_cu_ps
cusps94913673_cusps
damps105220413_damps
dhutis1035923dhutis
doumas95314813doumas
doums85417643doum_s
drums85415873drum_s
dumas85420433_dumas
dumbs105915753_dumbs
dump95927093_dump_
dumpy135414753_dumpy
dups75929513_du_ps
equips17387193equips
exhumes1934323exhumes
flumes115119733flumes
flump124614723flump_
frump126912563frump_
frumpy16466883frumpy
fumes105224703_fumes
gamps105323713_gamps
gaums86217073gaum_s
gazumps2131873gazumps
geums85414113geum_s
gimps105915203_gimps
glumes94516813glumes
glumpy14527193glumpy
glums84621423glum_s
gramps114114273gramps
grumes94415553grumes
grump105115313grump_
grumpy14498153grumpy
gulps84715073_gulps
gums75030943_gum_s
hames106138703_hames
hams96446133_ham_s
haps96443463_h_aps
harps105926863_harps
hasps105114643_hasps
heaps105223223_heaps
helps105219343_helps
hemes105031083_hemes
hemp115725623_hemp_
hempy154912763_hempy
hems95534943_hem_s
hims95230973_him_s
hips96433703_h_ips
homes106938813_homes
homos105921783_homos
hoops105621073_hoops
hops97942633_h_ops
hubs96027143_hu_bs
hucks144322173_hucks
hues75235233_hu_es
huffs144514743_huffs
hugs86129753_hu_gs
hulas84920883_hulas
hulks125715483_hulks
hulls84923563_hulls
hum85542933_hum__
human102716033_human
humans112312433_humans
humic124113243_humic
humid114213763_humid
hummus1336243_hummus
humor101110513_humor
humors11129633_humors
humped144015243_humped
humper134115883_humper
humpers142713523_humpers
hunks125321453_hunks
huns76136933_hu_ns
hunts86826173_hunts
hup86437813_hu_p_
hurds95219073_hurds
hurls86522713_hurls
hurts86922823_hurts
husks125015453_husks
huts76737443_hu_ts
hymns1337523_hymns
hyps125418413_h_yps
imps86221123__imps
inhumes1296883inhumes
jaups144810533jau_ps
jump156621723_jump_
jumpy195712813_jumpy
kemps135012523_kemps
khoums1594013khoum_s
koumis1237613koumis
koumys1543303koumys
kumys1435933_kumys
lamps95624833_lamps
limps95522673_limps
loumas84812333loumas
loups75319623lou_ps
lumas75622913_lumas
lump86531703_lump_
lumpy126615913_lumpy
lums65734243_lum_s
metumps1334133metumps
mumms85513153_mumms
mump105425723_mump_
mums85732773_mum_s
mumus95517283_mumus
neumes83112623neumes
neums75414253neum_s
numbs94913093_numbs
ohms95514033oh_m_s
outjumps1942603outjumps
phuts104613503phu_ts
pimps114616983_pimps
plumbs12459333plumbs
plumes104318133plumes
plump115315263plump_
plums94619953plum_s
pomps115316193_pomps
primps124711823primps
pulps95116483_pulps
pumas95121563_pumas
pump105726853_pump_
pups86032233_pu_ps
quips164713373_quips
ramps96224633_ramps
repumps1334403repumps
rhemes115913183rhemes
rheums1135463rheum_s
rhombs13336493rhombs
rhumb12438653rhum_b
rhumba13375553rhumba
rhumbas14305163rhumbas
rhus75114053rhu__s
rhuses94911793rhuses
rhymes14419823rhymes
romps94617543_romps
roups75118903rou_ps
rump86729083_rump_
rumpus10458893_rumpus
rums64833473_rum_s
samps96124673_samps
scamps125014173scamps
schlumps1742743schlumps
sculps104611753sculps
scums95017423scum_s
scups95316653scu_ps
shamas113717933shamas
shames114726223shames
shamos114216983shamos
shams105829413sham_s
shamus114112813shamus
sharps115516083sharps
shims104422543shim_s
ships105123773sh_ips
shleps114710333shleps
shlump1345713shlump_
shlumpy1742863shlumpy
shnaps1148083shnaps
shops104222893sh_ops
shrimps14516753shrimps
shucks154010413shucks
shuls85319713shu_ls
shuns85018143shu_ns
shunts95712013shunts
shutes93518213shutes
shuts85622473shu_ts
simps94719763_simps
skimps14488043skimps
slump94816633slump_
slums74623433slum_s
slurps84410003slurps
soups75322943sou_ps
spumes1021314883spumes
stamps105614023stamps
stomps105612833stomps
stoups85313273stou_ps
strumas9419833strumas
strums84716453strum_s
stump94616463stump_
stumpy13458133stumpy
stums75320083stum_s
sumos75720093_sumos
sump86331533_sump_
sums65837583_sum_s
sups64834433_su_ps
swamps135910263swamps
tames75242013t_ames
tamis76728723t_amis
tamp86133003t_amp_
tams67247933t_am_s
taps66050673t__aps
tarps76527113t_arps
taunts65715663taunts
tauons63412673tauons
taupe7314163tau_pe
taupes8212673taupes
taus46342733tau__s
tauts56125513tau_ts
teams75726513team_s
teems76019783teem_s
temp85323333t_emp_
tempi94912203t_empi
tempo95214973t_empo
tempos103812293t_empos
tempt95124843t_empt
tempts10439453t_empts
terms75523473term_s
thacks154311923thacks
thanes94918983thanes
thanks134313133thanks
tharms115712243tharms
thaws116515463th_aws
thebes115914493thebes
thefts12387923thefts
thegns10547433thegns
theins95015423theins
theirs94610353theirs
them97427043them__
theme105921733them_e
themed125912583themed
thens85921833th_ens
theres96525473theres
thermes126214613thermes
thermos124610753thermos
therms115914873therms
theses96517973theses
thesis94913733thesis
thesp105410313thesp_
thetas93011573thetas
thews117416193th_ews
thicks154511993thicks
thighs1346623thighs
thills95515383thills
things104914283things
thinks134613353thinks
thins85826323th_ins
thiols95112763thiols
thirds10438603thirds
thirls95012063thirls
this76027383th__is
tholes94919783tholes
tholos94213003tholos
thongs104611183thongs
thorns95314093thorns
thorp104414263thorp_
thorpe113610093thorpe
thorpes125010353thorpes
thous86017253th_ous
thraws129211103thraws
threaps12488643threaps
threeps12687043threeps
threes97117323threes
thrip103012183thrip_
throbs118311373throbs
throes97518673throes
throws129715233throws
thrum104713633thrum__
thrummy1742173thrummy
thrusts10226523thrusts
thud85613913thu__d
thug86415483thu__g
thuja1535213thu_ja
thulia936113thulia
thulias1035743thulias
thumbed15336173thumbed
thumping16296713thumping
thunk124911853thu_nk
thurl84912683thu_rl
thusly1235133thusly
thuya1135583thu_ya
thyme134612473thym_e
thymey17426313thymey
thymi13418623thym_i
thymic16307413thymic
thymol1434463thymol
thymols1533843thymols
thymy16437923thym_y
times75630823t_imes
tips66436763t__ips
tombs97818733t_ombs
tomes76037383t_omes
toms68343493t_om_s
tops66248123t__ops
toughs105414983toughs
tours55325863tou_rs
touses64229673touses
touts54830393tou_ts
tramp96319773tramp_
trampy13499253trampy
trams75327673tram_s
traps75727483t_raps
traumas938583traumas
trims75021473trim_s
trips74923363t_rips
triumph1453333triumph
triumphs1542513triumphs
tromp95815803tromp_
trompe105611263trompe
trompes114111623trompes
troops85712773troops
truces84916333truces
trucks124711973trucks
trues54925323tru_es
trugs65516803tru_gs
trulls64110283trulls
trumped12439713trumped
trumpet113810723trumpet
trumpets12315573trumpets
trunks10429753trunks
truss54916923tru_ss
trusts64714433trusts
truths9449503truths
tsuris62710203tsuris
tubas75119573t_ubas
tubes74826453t_ubes
tubs65430063t_u_bs
tucks114721123t_ucks
tufas85314383t_ufas
tuffs115118263t_uffs
tufts85713273t_ufts
tugs56231673t_u_gs
tuis44829643t_u_is
tules54532793t_ules
tulips8137253tulips
tumid84114023t_umid
tummy124711993t_ummy
tumor71110693t_umor
tumors8810603t_umors
tumped114216233t_umped
tunas54224123t_unas
tunes55332193t_unes
tungs65520623t_ungs
tuns45138663t_u_ns
tup56037543t_u_p_
turds65021693t_urds
turfs84620443t_urfs
turks95320823t_urks
turns55623233t_urns
tusks94915533t_usks
tuts45838453t_u_ts
tutus55214813t_utus
tuxes124316043t_uxes
twerps11345153twerps
twirps11415013twirps
typps12549303t_ypps
tzuris15286913tzuris
ump76130443__ump_
ups55629053__u_ps
urps66920473__urps
usurps8105073usurps
vamps125415483_vamps
whams135515643wham_s
whaps135115163wh_aps
whaups14405753whaups
wheeps14439953wheeps
whelps14437843whelps
whims134515333whim_s
whips134917083wh_ips
whomp155011323whomp_
whoops14487863whoops
whops135013933wh_ops
whumped18335633whumped
whup125714163whu_p_
wimps125213803_wimps
yaups105910743yau_ps
yups96121603_yu_ps

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164897.65614722.6
3Display Results4894890.2961652.0
 (SQL Overall)1786914898.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.