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

165 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
plenary123754(None) 
bleary115112552ble_ary
denary105316862_denary
leary85927382_le_ary
penury1148102p_enury
planar84212712planar_
plena75816392plena__
plenarily1444672plenarily
plenty11311412plen_ty
senary93716072_senary
agentry11165753agentry
alary86123443al__ary
alegar739283alegar_
alegars838933alegars
aplenty1237173aplen_ty
aweary1237303awe_ary
binary11312223_binary
blear75918683ble_ar_
blears85116453ble_ars
blenny1156203blen_ny
canary11314693_canary
catenary1346583catenary
cedary12419603_cedary
clary105719613cl__ary
cleanly1236323cleanly
clear76219053cle_ar_
clearly1236663cle_arly
clears84116563cle_ars
culinary1355853culinary
deary95826843_de_ary
decenary1446273decenary
denar65223293_denar_
denari710917353_denari
denars74621433_denars
dietary1158663dietary
dreary104611673dre_ary
entry82414263__entry
fleury12417353fle_ury
gentry103410443_gentry
glary96018543gl__ary
gleamy12398113gle_amy
glengarry145633glengarry
granary1157793granary
henry114014473_hen_ry
hymnary1843033hymnary
laniary1068013_laniary
leady95618603_le_ady
leafy116316213_le_afy
leaky125217723_le_aky
leanly93811503_leanly
lear47045953_le_ar_
learn55322663_le_arn
lears55938733_le_ars
leavy115715773_le_avy
leery85919133_le_ery
legacy1256653_legacy
lenity9612713_lenity
lunacy1136843_lunacy
lunar57017313_lunar_
lunars65012813_lunars
millenary1444583millenary
nary76931223___nary
olivary1345163olivary
palmary14338553palmary
panfry14456413p_anfry
pantry115014103p_antry
parcenary1643903parcenary
peaky145718153p_e_aky
pear69745233p_e_ar_
pearl75324463p_e_arl
pearly116414843p_e_arly
pears75138613p_e_ars
peart76440753p_e_art
peaty105725693p_e_aty
peavy135014843p_e_avy
peccary1636283peccary
pedlary13277543pedlary
peery105719443p_e_ery
peltry11288653p_eltry
penal75228373p_ena_l
penally121111773p_enally
penalty1267743p_enalty
penang92511113p_enang
penny105119453p_en_ny
perry105222713p_e_rry
pessary1246873pessary
petard95013803p_etard
phenate12412203phenate
phenoxy2243483phenoxy
pinery115214293p_inery
piscary1437423piscary
placard1236783placard
plagiary1443643plagiary
planaria1047353planaria
planarity1445323planarity
planate9314573planate
planer84122653planer_
planers94517943planers
planetary1443903planetary
plantar9369993plantar_
platy105021663pl__aty
play95928983pl__a_y
plea66830603ple_a__
pleach134211243ple_ach
plead85818463ple_a_d
pleads94613953ple_ads
pleas75627033ple_a_s
please84315733ple_ase
pleat74734473ple_a_t
pleats85218593ple_ats
plectra1145793plectra
pleiad947833pleia_d
pleiads1045223pleiads
plenaries11410383plenaries
plench134010813plen_ch
plenish1239943plenish
plenism11310113plenism
plenist9314333plenist
plenum1039503plen_um
plenums1136533plenums
pleonal937243pleona_l
pleonasm1243813pleonasm
pleura837533ple_ura
pleurae945863pleurae
pleural956673pleural
pleuras937413pleuras
plexal1536843plexa_l
plexor1535253plexor_
plexors1645423plexors
pliancy1435593pliancy
plunky15377953plun_ky
poetry1139383poe_try
poleward1455943poleward
polypary1855113polypary
prearm104512353pre_arm
predry1237873pre_dry
prelacy1437583prelacy
prename11412643prename
prepare111913623prepare
prepay13310313prepa_y
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
primary1437703primary
proletary1445843proletary
pulmonary1653023pulmonary
quinary1936933quinary
reentry1038033reentry
scenery1236563scenery
sentry92912053_sentry
septenary1443733septenary
sleazy18267393sle_azy
smeary114110803sme_ary
teary85124053_te_ary
ternary1038343ternary
thenar92610003thenar_
thenars10248523thenars
trinary1039173trinary
ulnar56013983ul_nar_
unary8315993__unary
urinary1037243urinary
venery123710663_venery
vicenary1654973vicenary
weary115620613_we_ary
zonary1838793_zonary

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.406440125.6
2DLD Change Limit1340271655.82623005.0
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.29528386.2
 
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.