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

186 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
pandect1231095(None) 
pandects1335841pandects
candent10417362candent
pander93725522pande_r
panders103423732panders
pandit93820752pand_it
pendent10314722pendent
abduct11108543_abduct
abject17137703_abject
addict10711203_addict
adduct1087373_adduct
adept81219643_a_dept
advect12309123_advect
affect1448903_affect
anent54931843_an_ent
ardent73022613_ardent
aspect10612823_aspect
baddest112611143baddest
baldest102313533baldest
bandeau1038523bandeau
banded105223173bande_d
bander93928223bande_r
banders104324563banders
bandit93821133band_it
bannet84925333banne_t
blandest113811043blandest
cadent94120363ca_dent
cadet85339343ca_de_t
candela1089743candela
cathect1439863cathect
conduct121411593conduct
confect143614273confect
connect113515743connect
convect143114483convect
damndest1276003damndest
dander811222993dande_r
danders93921183danders
dandiest103415033dandiest
dankest122611673dankest
darndest1067223darndest
fanjet16311393fanje_t
fondest11312403fondest
gander84322763gande_r
ganders93521703ganders
gannet74321853ganne_t
grandest10311573grandest
haddest122711993haddest
handed114919983hande_d
hander104526433hande_r
handers114224333handers
handiest123417773handiest
handout11314103handout
handset113016823handset
hardest113118413hardest
indent73021243_indent
indict93115573_indict
induct93212743_induct
infect113413443_infect
inject153210233_inject
insect83916583_insect
kindest12311503kindest
lancet84223573lance_t
landed84619243lande_d
lander74028483lande_r
landers84026213landers
lankest112714113lankest
maddest112311213maddest
paciest112917803paciest
packet144726503packe_t
pact86648723pa___ct
padded114113503padde_d
padder103415493padde_r
padders113312873padders
paddock17104733paddock
palest83926223pa_lest
palet74650803pa_le_t
paliest93021603paliest
pallet84232653palle_t
panacea1137783panacea
pancetta1244653pancetta
panda85022613pand__a
pandani1039903pandani
pandas95521963pand_as
pandemic1545543pandemic
pandemics1643933pandemics
pandered121812573pandered
panderer112210913panderer
pandied113913443pandied
pandies104224503pandies
pandits103914213pandits
pandoor10358583pandoor
pandora1039543pandora
pandore10411853pandore
pandour10408213pandour
pandura1037143pandura
pandy115021173pand__y
pane64950293pan_e__
paned85437183pan_e_d
panel76023623pan_e_l
panels84716523pan_els
panes76148693pan_e_s
panged104722333pange_d
pangen94115913pange_n
pangene102711963pangene
pangens103112063pangens
panic93923903pan_ic_
panics103815363pan_ics
panier84425503panie_r
paniers94717333paniers
panne76623653panne__
panned94123433panne_d
panner84224763panne_r
panners93621273panners
pannes85522853panne_s
pant66061263pan___t
panted95024823pante_d
panzer174213233panze_r
panzers184012013panzers
pardee93922023parde_e
parent83230423pa_rent
parget94529393parge_t
parsec105914483parsec_
parsecs11429923parsecs
patent84524923pa_tent
patient9617073patient
payment14310703payment
pendant10314853pendant
pended103819013pende_d
pendency1646073pendency
pendents1139413pendents
perfect141010833perfect
pinder94523453pinde_r
pinders103720473pinders
piniest93121133piniest
pinkest132812623pinkest
planet84228353plan_e_t
plangent1138803plangent
ponded105218773ponde_d
ponder94521693ponde_r
ponders103618843ponders
ponent82821593pon_ent
porrect1159743porrect
praefect1544773praefect
praelect1247533praelect
predict12315323predict
prefect141011073prefect
prelect111013833prelect
product1279233product
project1838453project
prosect11313393prosect
protect11313633protect
prudent10310433prudent
pundit92914183pund_it
pungent10311233pungent
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
randiest93418773randiest
rankest112713813rankest
saddest92412383saddest
sanded84920613sande_d
sander74828533sande_r
sanders84025943sanders
sandiest93218683sandiest
sandlot8311693sandlot
sandpit1049633sandpit
sanest64426693san_est
scandent1148493scandent
spandex1735833spande_x
sundeck1445273sundeck
syndet10311963synde_t
tandem9311403tande_m
tandems1037633tandems
tangent8314993tangent
tannest72617853tannest
tanrec837803tanrec_
tanrecs934823tanrecs
transect10410053transect
unadept1046603unadept
wander104423713wande_r
wanders114221333wanders
waniest103819113waniest
wannest103915003wannest
zander163417113zande_r
zanders173015793zanders
zaniest163214773zaniest

Search took 9 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.1561145455.1
2DLD Change Limit1340271867.92316916.2
3Display Results1861860.1231512.2
 (SQL Overall)1786911868.20221786.3
 
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.