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

416 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
grumped1333733(None) 
crumped144311221crumped
trumped12439711trumped
bumped134414002_bumped
chumped17379492chumped
clumped143610662clumped
cramped144712182cramped
crimped143910762crimped
crumbed14378472crumbed
crumpet133711062crumpet
crumpled15296872crumpled
drummed13306322drummed
dumped123814492_dumped
flumped15377712flumped
gaumed104610322gaum_ed
gazumped2341402gazumped
gimped123911472g_imped
grasped11409062grasped
grimed104714092grim_ed
griped104114712gr_iped
gripped13419342gripped
groped107515062gr_oped
grouped11419192grouped
grubbed13406432grubbed
grudged11317162grudged
grueled937132grueled
gruffed1544942gruffed
grumbled14256752grumbled
grume86218162grum_e_
grumes94415552grum_es
grummer12338782grummer
grummet12298872grummet
grump105115312grump__
grumphy18443622grumphy
grumpier1334802grumpier
grumps114510572grump_s
grumpy14498152grump_y
grunted9339282grunted
gulped104610372g_ulped
gummed123811662g_ummed
humped144015242_humped
jumped183511552_jumped
lumped114216962_lumped
mumped133813162_mumped
plumped14318642plumped
primped14479152primped
pumped133915562_pumped
ramped114617902_ramped
romped114513652_romped
rumpled123810012_rumpled
slumped123710152slumped
stumped124210152stumped
thumped15387412thumped
tramped124312432tramped
tromped124210292tromped
trumpet113810722trumpet
tumped114216232_tumped
umped104717272__umped
whumped18335632whumped
amped104820513__amped
armed86324433ar_m_ed
aruspex1642543aruspex
blumed114313643blum_ed
brimmed14386783brimmed
bruised10389503bruised
bruited104110353bruited
brume95817983brum_e_
brumes106417073brum_es
brushed133811213brushed
bruted95113263bru_ted
bruxed16466983bru_xed
bummed134211723_bummed
bumper123714343_bumper
burped116215503_burped
camped134720233_camped
champed174111483champed
chomped17329773chomped
chummed17396443chummed
clamped144012043clamped
clomped14398973clomped
comped135919873_comped
couped115019313cou_ped
crammed143710123crammed
craped116120533cr_aped
crapped143912633crapped
creeped12329713creeped
creped114115713cr_eped
crimper136510423crimper
crimpled15366933crimpled
crisped124010113crisped
cropped143812073cropped
crudded1235733crudded
cruised103710223cruised
crumber13339643crumber
crumbled15357443crumbled
crump115616423crump__
crumpets14335943crumpets
crumple13368363crumple
crumples14348813crumples
crumply16336093crumply
crumps124514343crump_s
crupper13338563crupper
crushed134111973crushed
crusted103712763crusted
cupped134413983_cupped
cusped114312043_cusped
damped124315583_damped
drammed13378073drammed
draped105314363dr_aped
dripped13408083dripped
drooped11368433drooped
dropped13329293dropped
drubbed13406983drubbed
drudged11277613drudged
drugged11367183drugged
drumbled14266033drumbled
drumhead1542653drumhead
drummer12407503drummer
drupe85012993dru_pe_
drupes94912653dru_pes
dumbed124012083_dumbed
dumper114615213_dumper
duped95118323_du_ped
dupped124411643_dupped
eructed10228653eructed
erumpent1245453erumpent
erupted10207173erupted
flumed124915263flum_ed
framed125116523fram_ed
frapped15318853frapped
frugged13387293frugged
fruited11389093fruited
frump126912563frump__
frumpier1534173frumpier
frumps13479783frump_s
frumpy16466883frump_y
fumed116118823_fum_ed
galoped11138083galoped
galumphed1841423galumphed
gamed95126393g_am_ed
gammed124216163g_ammed
gaped96123533g__aped
gapped124217123g_apped
gasped104814293g_asped
gauged94713473gau_ged
gawped13509073g_awped
gazumper2241463gazumper
gemmed12329573g_emmed
gipped124815903g_ipped
glimed105312283glim_ed
glimpsed1442773glimpsed
glommed13265443glommed
glopped13347613glopped
glued75118363glu__ed
glugged11396623glugged
glume85120463glum_e_
glumes94516813glum_es
glummer12417983glummer
glumpier1334873glumpier
glumpy14527193glump_y
glutted937243glutted
gormed105013833gorm_ed
gouged96214593gou_ged
grabbed13368643grabbed
graced105217903gr_aced
graded94919553gr_aded
grafted124110223grafted
grained93814273grained
gramme114210333gramme_
grammes123611323grammes
gramp106218323gramp__
grampa115010173gramp_a
grampas12399253grampas
gramps114114273gramp_s
grampus12356313grampus
granted94715103granted
grape84824663gr_ape_
grapes95123123gr_apes
grapey126012303gr_apey
graphed1498473graphed
grappled14336093grappled
grasper10389793grasper
grassed93812793grassed
grated84523923gr_ated
graupel1034133graupel
graved114818813gr_aved
grayed115415643gr_ayed
grazed174115913gr_azed
greased93812393greased
greaved12408913greaved
greed75125693gr__eed
greened93111263greened
greeted93111383greeted
greyed114610603gr_eyed
gridded11387583gridded
grided95117043gr_ided
grieved1235283grieved
grifted12379583grifted
grilled94012833grilled
grimaced1463313grimaced
grime85021323grim_e_
grimes94619033grim_es
grimier103210433grimier
grimmer123510093grimmer
grinded104210633grinded
grinned9378553grinned
gripe84622963gr_ipe_
griper94114613gr_iper
gripes94619873gr_ipes
gripey124111203gr_ipey
gripmen1235033gripmen
grippe115310323grippe_
gripper124410713gripper
grippes124810373grippes
gritted94110903gritted
groaned9259973groaned
groined92710813groined
grokked1233673grokked
grommet12268453grommet
groomed11379503groomed
grooved12347253grooved
grope84821613gr_ope_
groper94517253gr_oper
gropes95220403gr_opes
grossed93812263grossed
grouched15356663grouched
grounded1136573grounded
grouper104210093grouper
groused94712843groused
grouted94111503grouted
groved114413703gr_oved
growled12278173growled
grubber12417913grubber
grudge9388583grudge_
grudger10368313grudger
grudges10349423grudges
grue55825713gru__e_
gruel66014743gru__el
grueler837023grueler
gruelled1034893gruelled
grues65721963gru__es
gruffer1475793gruffer
grum75625083grum___
grumble12349233grumble
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
grummest13286363grummest
grummeted1552153grummeted
grummets13275033grummets
grumose1035723grumose
grumous1086613grumous
grumphie1642763grumphie
grumphies1743653grumphies
grumpiest1435023grumpiest
grumpily1643463grumpily
grumping14266903grumping
grumpish1643763grumpish
grunge8359583grunge_
grunger9389783grunger
grunges93310403grunges
grunter83110783grunter
gruntled10274943gruntled
grutched15284673grutched
grutten885283grutten
guided94014113g_uided
guiled84315383g_uiled
guimpe1134723guimpe_
guimpes1245073guimpes
guised84612173g_uised
gulfed114810013g_ulfed
gulled84521373g_ulled
gulper93410213g_ulper
gummer114615453g_ummer
gumweed1433943g_umweed
gunned83513093g_unned
gurged95513363g_urged
gurgled10399123gurgled
gushed114816243g_ushed
gusted84316723g_usted
gutted84716363g_utted
guyed1049893g_u_yed
gypped15377113g_ypped
harumphed2041543harumphed
hummed144812673_hummed
humper134115883_humper
humphed1835423_humphed
imped105117983__imped
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
premed114617763prem_ed
prepped11329903prepped
primed115118913prim_ed
primmed14388853primmed
promoed12310083promoed
prompted1536903prompted
propped113311963propped
pruned93413113pru_ned
pulped114612533_pulped
pumper124415553_pumper
pupped105013273_pupped
rammed113117303_rammed
raped85334623_r_aped
rapped114122683_rapped
rasped94715203_rasped
reaped94122453_reaped
repped114616723_repped
repumped1534383repumped
rimed84826373_rim_ed
rimmed114812303_rimmed
rimpled123311423_rimpled
riped85226433_r_iped
ripped114419013_ripped
romper104213683_romper
roped84630813_r_oped
rouped95717353_rouped
rubbed114515083_rubbed
rubied94312413_rubied
ruched124314633_ruched
rucked134718763_rucked
rued55729793_ru__ed
ruffed134312743_ruffed
rugged94215383_rugged
ruined74813323_ruined
ruled65822523_ru_led
rumbaed12287493_rumbaed
rumbled124514593_rumbled
rumen74419503_rum_en
rummer104715483_rummer
rumored1046643_rumored
rump86729083_rump__
rumple103913013_rumple
rumples113313133_rumples
rumply13348573_rumply
rumps95922293_rump_s
rumpus10458893_rumpus
rupee7321283_ru_pee
rushed104419863_rushed
rusted75020923_rusted
rutted74518403_rutted
scamped144711963scamped
scrimped1555313scrimped
scrummed1554313scrummed
sculped12398253sculped
scummed14347913scummed
shlumped1643443shlumped
shrimped1634213shrimped
siruped1036013siru_ped
skimped16256223skimped
slummed12359273slummed
slurped10368753slurped
souped95017673sou_ped
spumed114711543spum_ed
stamped124812813stamped
stomped124110533stomped
strummed1344473strummed
strumpet1256033strumpet
stummed12348553stummed
stumper113610093stumper
summed114014043_summed
supped114415703_supped
swamped15498443swamped
syruped1334543syru_ped
tamped114317043_tamped
temped113912893_temped
thrummed1642843thrummed
thumbed15336173thumbed
thumper14356953thumper
trammed123810713trammed
tramper113812163tramper
trampled13247903trampled
trapped124512213trapped
trimmed12348933trimmed
tripped123911693tripped
triumphed1741943triumphed
trompe105611263trompe_
trompes114111623trompes
trooped104010723trooped
trouped103910983trouped
truced95312053tru_ced
trucked143910813trucked
trudged10298043trudged
trued65117693tru__ed
trump95615123trump__
trumpery1533613trumpery
trumpeted1443053trumpeted
trumpets12315573trumpets
trumps104611883trump_s
trunked12358413trunked
trussed84010033trussed
trusted83412793trusted
tupped114013233_tupped
unrumpled1443673unrumpled
upped103715163__upped
urped84615283__urped
usurped1035153usurped
vamped144211013_vamped
whomped18345473whomped
whupped18365413whupped
wimped144211513_wimped
wrapped15338023wrapped
yauped12408333yau_ped

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 Filter1786911340270.423422437.4
2DLD Change Limit1340274167.01319111.2
3Display Results4164160.1602600.0
 (SQL Overall)1786914167.59623524.4
 
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.