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

257 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
whumped1833563(None) 
chumped17379491chumped
humped144015241_humped
thumped15387411thumped
whomped18345471whomped
whupped18365411whupped
bumped134414002_bumped
champed174111482champed
chomped17329772chomped
chummed17396442chummed
clumped143610662clumped
crumped144311222crumped
dumped123814492_dumped
flumped15377712flumped
grumped13337332grumped
hummed144812672_hummed
humper134115882_humper
humphed1835422_humphed
jumped183511552_jumped
lumped114216962_lumped
mumped133813162_mumped
plumped14318642plumped
pumped133915562_pumped
shlumped1643442shlumped
slumped123710152slumped
stumped124210152stumped
thumbed15336172thumbed
thumper14356952thumper
trumped12439712trumped
tumped114216232_tumped
umped104717272__umped
whammed18345132whammed
whapped18367572whapped
wheeped16387512wheeped
whelped16355642whelped
whimper17297722whimper
whipped18379332whipped
whooped16326932whooped
whopped18358002whopped
whump154910042whump__
whumps16427092whump_s
wimped144211512w_imped
amped104820513__amped
bethumped1941493bethumped
blumed114313643blum_ed
bummed134211723_bummed
bumper123714343_bumper
burped116215503_burped
camped134720233_camped
champer163813413champer
chapped172711443chapped
cheeped153410593cheeped
chimed145814833chim_ed
chipped174110813chipped
chirped15379783chirped
chomper163810073chomper
chopped174511013chopped
chucked19469733chucked
chuffed19316643chuffed
chugged1584823chugged
chump145315443chump__
chumps154313823chump_s
chunked17428213chunked
churned13358373churned
churred13409173churred
chuted124611843chu_ted
clamped144012043clamped
clomped14398973clomped
comped135919873_comped
couped115019313cou_ped
cramped144712183cramped
crimped143910763crimped
crumbed14378473crumbed
crumpet133711063crumpet
crumpled15296873crumpled
cupped134413983_cupped
cusped114312043_cusped
damped124315583_damped
drummed13306323drummed
dumbed124012083_dumbed
dumper114615213_dumper
duped95118323_du_ped
dupped124411643_dupped
exhumed2043413exhum_ed
flumed124915263flum_ed
fumed116118823_fum_ed
gaumed104610323gaum_ed
gazumped2341403gazumped
gimped123911473_gimped
gulped104610373_gulped
gummed123811663_gummed
hammed144116973_hammed
hamper134518653_hamper
happed144820103_happed
harped124418403_harped
hasped125014443_hasped
heaped124516903_heaped
helped124714153_helped
hemmed144211463_hemmed
hempen1338963_hempen
hipped144317693_hipped
homed115425423_hom_ed
hooped125518183_hooped
hoped115628183_h_oped
hopped144318113_hopped
hued86925853_hu__ed
huffed163710153_huffed
hugged124113643_hugged
hulked144611303_hulked
hulled103920013_hulled
humbled153711813_humbled
humid114213763_hum_id
hummer133615273_hummer
humored1336723_humored
hump116228723_hump__
humpers142713523_humpers
humph155712213_hump_h
humphs16528163_humphs
humpier143110723_humpier
humps126322803_hump_s
humpy155115673_hump_y
humvee1439203_humvee
hunted104417013_hunted
hurled104617453_hurled
hushed134416673_hushed
husked144212223_husked
hutted104616333_hutted
hymned1535323_hymned
hyped145313333_h_yped
imped105117983__imped
inhumed1375573inhum_ed
jauped16457903jau_ped
jumper173612373_jumper
lamped114017543_lamped
limped114817123_limped
louped95316383lou_ped
lumpen104010663_lumpen
lumper103816653_lumper
mummed104411553_mummed
mumper123513523_mumper
numbed114111443_numbed
pimped134913483_pimped
plumbed14317273plumbed
plumed114412883plum_ed
plumiped1533313plumiped
plumpen13276403plumpen
plumper13318783plumper
primped14479153primped
pulped114612533_pulped
pumper124415553_pumper
pupped105013273_pupped
ramped114617903_ramped
repumped1534383repumped
rhumbaed1672753rhumbaed
rhymed15416713rhym_ed
romped114513653_romped
rouped95717353rou_ped
rumpled123810013_rumpled
scamped144711963scamped
schlumped1941953schlumped
sculped12398253sculped
scummed14347913scummed
shamed125120213sham_ed
shammed153911423shammed
shaped125020103sh_aped
sharped134112053sharped
shimmed15338583shimmed
shipped153312103shipped
shopped153512213shopped
shrimped1634213shrimped
shucked17389833shucked
shunned11417843shunned
shunted11339783shunted
shushed14348493shushed
shuted103913173shu_ted
skimped16256223skimped
slummed12359273slummed
slurped10368753slurped
souped95017673sou_ped
spumed114711543spum_ed
stamped124812813stamped
stomped124110533stomped
stummed12348553stummed
stumper113610093stumper
summed114014043_summed
supped114415703_supped
swamped15498443swamped
tamped114317043_tamped
temped113912893_temped
themed125912583them_ed
thrummed1642843thrummed
thudded1333433thudded
thump126211573thump__
thumpers15365713thumpers
thumps13449353thump_s
thunked15386853thunked
tramped124312433tramped
tromped124210293tromped
trumpet113810723trumpet
tupped114013233_tupped
upped103715163__upped
urped84615283__urped
usurped1035153usurped
vamped144211013_vamped
wapped144416473w_apped
warmed124516893warm_ed
warped124816413w_arped
wauked144210573wau_ked
wauled104713963wau_led
whacked20458623whacked
whaled134612033wh_aled
whanged15447613whanged
whapper17348273whapper
wharfed1734423wharfed
wheeled14318473wheeled
wheepled1733303wheepled
wheezed23296463wheezed
whelmed16375163whelmed
whetted14256693whetted
whidded1634423whidded
whiffed2064473whiffed
whiled134514133wh_iled
whimpered20144023whimpered
whimpers18276613whimpers
whimsey18373893whimsey
whimsied1743113whimsied
whined134715203wh_ined
whinged15409153whinged
whipper173611383whipper
whippet17328843whippet
whirled14368043whirled
whirred14386943whirred
whished17428023whished
whisked18336913whisked
whisper15298013whisper
whisted144010013whisted
whited134814083wh_ited
whizzed2234063whizzed
whomp155011323whomp__
whomps16457603whomp_s
whoofed17374513whoofed
whoopee15287523whoopee
whooper15297153whooper
whopper17328503whopper
whored135512123wh_ored
whorled14366903whorled
whumping19325403whumping
whup125714163whu_p__
whups134210003whu_p_s
wimpled15338823w_impled
wiped114722083w__iped
wisped123411893w_isped
wombed14419233w_ombed
wormed124314303worm_ed
wounded12329763wounded
wrapped15338023wrapped
yauped12408333yau_ped

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272575.61023890.7
3Display Results2572570.0803212.5
 (SQL Overall)1786912576.08029390.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.