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

258 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
thumbed1533617(None) 
thumped15387411thumped
chummed17396442chummed
chumped17379492chumped
crumbed14378472crumbed
dumbed124012082_dumbed
humbled153711812_humbled
hummed144812672_hummed
humped144015242_humped
numbed114111442_numbed
plumbed14317272plumbed
rhumbaed1672752rhumbaed
themed125912582them_ed
thrummed1642842thrummed
thudded1333432thudded
thumb124511282thumb__
thumbs13377442thumb_s
thumper14356952thumper
thunked15386852thunked
tombed113812132t_ombed
trumped12439712trumped
tubbed114712222t_ubbed
tubed85818042t_u_bed
tumbled123412242t_umbled
tumped114216232t_umped
whumped18335632whumped
bedumbed1643023bedumbed
benumbed1543193benumbed
bethumped1941493bethumped
blubbed11338393blubbed
blumed114313643blum_ed
blurbed12337613blurbed
bombed134113873_bombed
bulbed114312773_bulbed
bumbled144113043_bumbled
bummed134211723_bummed
bumped134414003_bumped
chamber164011063chamber
champed174111483champed
chimed145814833chim_ed
chomped17329773chomped
chucked19469733chucked
chuffed19316643chuffed
chugged1584823chugged
chunked17428213chunked
churned13358373churned
churred13409173churred
chuted124611843chu_ted
climbed14336983climbed
clubbed14307453clubbed
clumber134011443clumber
clumped143610663clumped
combed135516543_combed
crumber13339643crumber
crumbled15357443crumbled
crumped144311223crumped
cubed105519703_cu_bed
cumber124016703_cumber
curbed114615873_curbed
daubed104611783dau_bed
drubbed13406983drubbed
drumbled14266033drumbled
drummed13306323drummed
dubbed124113213_dubbed
dumber114414173_dumber
dumped123814493_dumped
embed105014303__embed
exhumed2043413exhum_ed
flubbed15306633flubbed
flumed124915263flum_ed
flumped15377713flumped
fubbed144711243_fubbed
fumbled153710493_fumbled
fumed116118823_fum_ed
gaumed104610323gaum_ed
grubbed13406433grubbed
grumbled14256753grumbled
grumped13337333grumped
gummed123811663_gummed
hammed144116973_hammed
hemmed144211463_hemmed
herbed123513453_herbed
hobbed144114303_hobbed
homed115425423_hom_ed
hotbed123310683_hotbed
hued86925853_hu__ed
huffed163710153_huffed
hugged124113643_hugged
hulked144611303_hulked
hulled103920013_hulled
humble133615053_humble
humbler143411943_humbler
humbles143215803_humbles
humbly164010523_humbly
humbug1434803_humbug
humid114213763_hum_id
hummer133615273_hummer
humored1336723_humored
humper134115883_humper
humphed1835423_humphed
humvee1439203_humvee
hunted104417013_hunted
hurled104617453_hurled
hushed134416673_hushed
husked144212223_husked
hutted104616333_hutted
hymned1535323_hymned
imbed105013653__imbed
inhumed1375573inhum_ed
jambed184811403_jambed
jumbled19379963_jumbled
jumped183511553_jumped
lambed115614783_lambed
limbed114513183_limbed
lubed85319893_lu_bed
lumber103817773_lumber
lumped114216963_lumped
mumbled143010763_mumbled
mummed104411553_mummed
mumped133813163_mumped
number103913223_number
plumber13339993plumber
plumed114412883plum_ed
plumped14318643plumped
pumped133915563_pumped
rhumb12438653rhumb__
rhumba13375553rhumb_a
rhumbas14305163rhumbas
rhumbs13366773rhumb_s
rhymed15416713rhym_ed
rubbed114515083_rubbed
rumbaed12287493_rumbaed
rumbled124514593_rumbled
scumbled1535053scumbled
scummed14347913scummed
shambled16156153shambled
shamed125120213sham_ed
shammed153911423shammed
shimmed15338583shimmed
shlumped1643443shlumped
shucked17389833shucked
shunned11417843shunned
shunted11339783shunted
shushed14348493shushed
shuted103913173shu_ted
slubbed12339283slubbed
slumber113811003slumber
slummed12359273slummed
slumped123710153slumped
snubbed12347443snubbed
spumed114711543spum_ed
strummed1344473strummed
stubbed12378083stubbed
stumbled1335623stumbled
stummed12348553stummed
stumped124210153stumped
subbed114116673_subbed
summed114014043_summed
tabbed114215363t_abbed
tamed85528513t_am_ed
tamped114317043t_amped
taunted84310963taunted
tauted75317113tau_ted
teamed95418593team_ed
teemed95114873teem_ed
temped113912893t_emped
termed94816703term_ed
thacked173810203thacked
thanked15469153thanked
thawed13458463th_awed
thebe107515433th_ebe_
thebes115914493th_ebes
theme105921733them_e_
themes115319253them_es
thieved1434973thieved
thighed1535273thighed
thimble1435873thimble
thimbles1536023thimbles
thinned11399173thinned
thirled11328093thirled
tholed105113873th_oled
thonged12376843thonged
thorned11479403thorned
thoued10429003th_oued
thrawed1435593thrawed
thrived14458183thrived
throbbed1643163throbbed
throned115412173throned
thrummer1542933thrummer
thrusted1265223thrusted
thud85613913thu___d
thuggee1245263thuggee
thumbing16245513thumbing
thumbkin1942113thumbkin
thumbless1643433thumbless
thumbnut15122743thumbnut
thump126211573thum__p
thumpers15365713thumpers
thumps13449353thum_ps
thunder1136973thunder
thyme134612473thym_e_
thymes144810743thym_es
thymey17426313thym_ey
thymier1534393thymier
timber104012683t_imber
timed85223613t_im_ed
tommed113310143t_ommed
touched134914963touched
toughed123511693toughed
toured74216153tou_red
toused74122013tou_sed
tousled84710363tousled
touted74419743tou_ted
touzled17367153touzled
trammed123810713trammed
tramped124312433tramped
trembled1335253trembled
trimmed12348933trimmed
tromped124210293tromped
truced95312053tru_ced
trucked143910813trucked
trudged10298043trudged
truebred1142753truebred
trued65117693tru__ed
trumpet113810723trumpet
trunked12358413trunked
trussed84010033trussed
trusted83412793trusted
tubber104313203t_ubber
tube65828663t_u_be_
tuber75420683t_u_ber
tubes74826453t_u_bes
tucked134017493t_ucked
tufted10359283t_ufted
tugged93813523t_ugged
tumble103215643t_umble
tumbler113412823t_umbler
tumbles113816023t_umbles
tumbrel11406853t_umbrel
tumid84114023t_um_id
tuned64622313t_u_ned
tunned74014493t_unned
tupped114013233t_upped
turbid979713t_urbid
turfed103110963t_urfed
turned73914473t_urned
tushed104615893t_ushed
tusked114112153t_usked
tutted75117443t_utted
tutued7349413t_utued
umbel93612843__umbel
umber94617593__umber
umped104717273__umped
unhumbled1743073unhumbled
whammed18345133whammed
whomped18345473whomped
whupped18365413whupped
wombed14419233_wombed

Search took 10 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.440406115.9
2DLD Change Limit1340272588.92015025.4
3Display Results2582580.1102345.5
 (SQL Overall)1786912589.47018869.2
 
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.