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

242 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
plenum103950(None) 
plenums1136531plenums
frenum1188802frenum
ileum74512822ile_um
linum7313822_linum
oleum73613322ole_um
phenom1339472phenom
pileum10399512pile_um
plena75816392plen_a
plench134010812plench
plenism11310112plenism
plenty11311412plenty
plexus15377282plexus
plum85122102pl__um
splenium1246472splenium
acetum1038463acetum
agendum1144673agendum
alarum85411983alarum
album92312653al_bum
algum82711763al_gum
allium8311243allium
alum65227613al__um
aplenty1237173aplenty
avenue957953avenue
begum105213923_begum
benumb1235773_benumb
blellum1143663blellum
blench133710453blench
blend85317453blen_d
blende95413443blende
blends96012883blends
blenny1156203blenny
blent76230953blen_t
bluegum1263823bluegum
caecum1238183caecum
cecum11611843_cecum
centum104012363_centum
cleanup1144083cleanup
clench133910053clench
clonus85212413clonus
crinum1039333crinum
degum94711903_degum
denim85518843_denim
enuf7323843__enuf
fanum10313443_fanum
fleam106017283fle_am
flench144010813flench
flense938903flense
fraenum1255703fraenum
frenums1236203frenums
genom83716843_genom
genu55929073_genu_
genua64614153_genua
genus65319833_genus
geum75424553_ge_um
gleam86916733gle_am
glen56027203glen__
glens66519853glen_s
glum75825103gl__um
granum9310913granum
helium112311253helium
ileus54616893ile_us
ilium74614183il_ium
iterum837903iterum
larum74317973_larum
legume936913_legume
lehua837953_lehua
leku86519913_leku_
lemur739773_lemur
lend56233673_len_d
lends65326253_lends
lenes54738523_lenes
lenis56326863_lenis
leno47331393_len_o
lenos56024863_lenos
lens46146493_len_s
lense54523433_lense
lent46360533_len_t
lento57223393_lento
letup73712163_letup
leu36047403_le_u_
leud57223423_le_ud
linums838283_linums
locum94812173_locum
lum55542933_l__um
magnum1136733magnum
mentum104511713_mentum
menu65130233_menu_
menus75822843_menus
neum66723083_ne_um
odeum84610543ode_um
oleums8358783ole_ums
omentum1155933omentum
pablum1237503pablum
pallium1149013pallium
paynim1337363paynim
peanut8318183peanut
peen65938083peen__
peened94318163peened
peens76428193peen_s
peepul1035783peepul
pen56558843p_en__
penal75228373p_enal
pence94924453p_ence
pend75934533p_en_d
pends85527193p_ends
penes75839223p_enes
pengo84317593p_engo
penis75129323p_enis
penna74520203p_enna
penne75423853p_enne
penni74617903p_enni
penny105119453p_enny
pens65649643p_en_s
pent66559073p_en_t
penult8314653p_enult
penury1148103p_enury
peplum12156823peplum
perm85834633p_e_rm
phenix1837133phenix
phenol1149253phenol
phenoms1437813phenoms
phenyl1435323phenyl
phlegm1433093phle_gm
phylum1655153phylum
pignus937953pignus
pignut9311573pignut
pileous9510523pileous
pileup10437923pile_up
pileus84514943pile_us
pinetum1145553pinetum
pinup9612883p_inup
plague93610853plague
plaguy12386413plaguy
plan65833943plan__
planar84212713planar
planch133711443planch
plane74929143plan_e
planed94420913planed
planer84122653planer
planes85028083planes
planet84228353planet
plank115221143plan_k
planks124116753planks
plans75731273plan_s
plant75437113plan_t
plants84921803plants
planula935773planula
plaque17317643plaque
plasm94114633pl_asm
platinum1245443platinum
plea66830603ple__a
pleach134211243pleach
plead85818463ple_ad
pleads94613953pleads
pleas75627033ple_as
please84315733please
pleat74734473ple_at
pleats85218593pleats
pleb86123813ple__b
plebe95014873ple_be
plebes104313623plebes
plebs95814583ple_bs
plectrum1453953plectrum
pled75231433ple__d
pledge10469493pledge
pleiad947833pleiad
plenary1237543plenary
plenish1239943plenish
plenisms1237963plenisms
plenist9314333plenist
pleon74216383ple_on
pleonal937243pleonal
pleonasm1243813pleonasm
pleonic1139433pleonic
pleons84213343pleons
pleura837533pleura
plew97222813ple__w
plews105415353ple_ws
plex137321373ple__x
plexal1536843plexal
plexes155313543plexes
plexor1535253plexor
plink115219123plin_k
plinks124913263plinks
plinth11310453plinth
plonk114613983plon_k
plonks124210423plonks
plug74915993pl__ug
plumb114514073pl__umb
plumbum1543733plumbum
plume94819463pl__ume
plump115315263pl__ump
plums94619953pl__ums
plumy124213233pl__umy
plunge93811053plunge
plunk114514403plun_k
plunks124711163plunks
plunky15377953plunky
plus66324833pl__us
pneuma1035263pne_uma
podium112911913podium
poem86225773poe__m
polenta9310093polenta
polonium1248333polonium
possum1057953possum
prearm104512353prearm
prebuy1357423prebuy
precut102016533precut
prelim10311423prelim
premium13310363premium
prename11412643prename
presume11310303presume
prevue1179163prevue
prunus8399363prunus
pseud867043pse_ud
pudendum1442623pudendum
regnum957163regnum
rhenium1246243rhenium
rheum1038843rhe_um
sebum93814553_sebum
sedum84115573_sedum
selenium1048203selenium
sensum849353_sensum
serum75223473_serum
silenus7369693silenus
slum65430513sl__um
solanum946403solanum
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splenius1046033splenius
splent84720193splen_t
splents93912133splents
sternum947733sternum
telium82611393telium
vellum1136773vellum
velum10713383_velum
venom103914863_venom
venue84918213_venue
venus84918903_venus
ylem9217893yle__m

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.373479064.3
2DLD Change Limit1127162425.26621404.5
3Display Results2422420.0763184.2
 (SQL Overall)1786912425.71531267.0
 
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.