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

229 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
plummy1537566(None) 
plumy124213231plu_my
slummy13325861slummy
chummy18385892chummy
clammy15356332clammy
clumpy15409572clumpy
clumsy13326192clumsy
crummy15365892crummy
dummy134712782_dummy
glumly12356622glumly
glumpy14527192glumpy
gummy135413652_gummy
lumpy126615912_lumpy
mummy114913622_mummy
plucky17406582plucky
plum85122102plu_m_
plumb114514072plu_mb
plumbs12459332plumbs
plume94819462plu_me
plumed114412882plumed
plumes104318132plumes
plummer13298522plummer
plummet13278352plummet
plump115315262plu_mp
plumply1634222plumply
plumps124612612plumps
plums94619952plu_ms
plunky15377952plunky
plushy14406972plushy
pommy14449862p_ommy
rummy124212412_rummy
scummy15265222scummy
tummy124711992_tummy
yummy15429152_yummy
alum65227613alu_m_
alumin8513543alumin
alumna857343alumna
alumni856753alumni
alums75720603alu_ms
blimey13468453blimey
blimy125212823bl_imy
bloomy134510113bloomy
bluely113310083bluely
bluesy11448983bluesy
bluey104817053blu_ey
blume95619893blu_me
blumed114313643blumed
blumes105917793blumes
blurry11437673blurry
brumby15385953brumby
bumpy144715053_bumpy
calumny1443863calumny
chammy18488953chammy
clubby1534683clubby
clump115517453clu_mp
clumps1215314643clumps
clunky15447893clunky
commy144712643_commy
crumby15408113crumby
drumly1235703drumly
dumky154511343_dumky
dumpy135414753_dumpy
elmy95616793el__my
emmy116013243__emmy
flamy135217473fl_amy
flimsy14345563flimsy
fluffy14315783fluffy
flukey16459813flukey
fluky154512293flu_ky
flume106021173flu_me
flumed124915263flumed
flumes115119733flumes
flummery1833053flummery
flummox2141413flummox
flump124614723flu_mp
flumps135112503flumps
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643flu_ty
frumpy16466883frumpy
fumy127118583_fu_my
gammy135514893_gammy
gemmy135211053_gemmy
gleamy12398113gleamy
gloomy12528763gloomy
gluey95715263glu_ey
gluily10308293gluily
glum75825103glu_m_
glume85120463glu_me
glumes94516813glumes
glummer12417983glummer
glums84621423glu_ms
gremmy1454473gremmy
grumpy14498153grumpy
gumma105313103_gumma
hammy155113433_hammy
haulmy14455553haulmy
humpy155115673_humpy
immy114611833__immy
jammy194810193_jammy
jemmy19498553_jemmy
jimmy19538503_jimmy
jumpy195712813_jumpy
kludgy15294223kludgy
klutzy2243003klutzy
lamby125114843_lamby
lemma94811033_lemma
limby125714073_limby
limey104721043_limey
limy95727713_l_imy
loamy105913343_loamy
lucky145515013_lucky
lum55542933_lu_m_
luma65527523_lu_ma
lumas75622913_lumas
lumen75220903_lumen
lummox1733053_lummox
lump86531703_lu_mp
lumps95624983_lumps
lums65734243_lu_ms
luny77324133_lu_ny
lusty85417573_lusty
mammy115215163_mammy
mommy114010753_mommy
mumm75718863_mumm_
mumms85513153_mumms
palmy126016733p_almy
phlegmy1841503phlegmy
pigmy13299433p_igmy
plaguy12386413plaguy
plashy14448873plashy
plasm94114633plasm_
plasma103810913plasma
plasms103711333plasms
platy105021663pl_aty
play95928983pl__ay
plenty11311413plenty
plisky1533713plisky
ploidy1237483ploidy
plotty11208853plotty
ploy96123603pl__oy
pluck134212303plu_ck
plucks14379733plucks
plug74915993plu__g
plugs85213493plu_gs
plumage1245503plumage
plumate1149803plumate
plumbed14317273plumbed
plumber13339983plumber
plumbery17315533plumbery
plumbic1543963plumbic
plumbum1543733plumbum
plumbums1642943plumbums
plumier113510043plumier
pluming123412043pluming
plummest14276413plummest
plummets14304773plummets
plummier1434123plummier
plumose1135963plumose
plumped14318643plumped
plumpen13276403plumpen
plumper13318773plumper
plumule1134303plumule
plunge93811053plunge
plunk114514403plu_nk
plunks124711163plunks
plural839823plural
plus66324833plu__s
pluses83618073pluses
plush105614713plu_sh
plushly15385383plushly
plutei8408903plutei
pluton838853pluton
ply86323553pl___y
pouchy16538663pouchy
pouffy17395883pouffy
pouty107018813pou_ty
primly13439623primly
pudgy124911163p_udgy
puffy164410753p_uffy
puggy124612323p_uggy
pulley113713403pulley
pulpy124612363p_ulpy
puma85424123p_u_ma
pumas95121563p_umas
pummel12278043p_ummel
pump105726853p_u_mp
pumps115520603p_umps
punky144419393p_unky
punny104217713p_unny
punty106021613p_unty
puny95526993p_u_ny
puppy114912413p_uppy
pursy105016413p_ursy
purty105019403p_urty
pushy134614353p_ushy
pussy105614843p_ussy
putty104721403p_utty
pygmy16334223p_ygmy
rammy124312493_rammy
shammy16388503shammy
shimmy16306413shimmy
shlumpy1742863shlumpy
slimly11408903slimly
slimsy11407723slimsy
slimy105417423sl_imy
sludgy11366253sludgy
sluicy1166483sluicy
slum65430513slu_m_
slummed12359273slummed
slummer113711203slummer
slump94816633slu_mp
slumps104313583slumps
slums74623433slu_ms
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
splurgy1343023splurgy
spumy124610363spu_my
stemmy13417033stemmy
stumpy13458133stumpy
summa94713313_summa
swimmy16234353swimmy
tammy124013223_tammy
thrummy1742173thrummy
tommy124712233_tommy
umm711921263__umm_
whammy19375293whammy

Search took 6 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.390458182.1
2DLD Change Limit1127162294.90622975.1
3Display Results2292290.0763013.2
 (SQL Overall)1786912295.37233263.4
 
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.