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

157 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
peccant1331173(None) 
decant93524222de_cant
descant104315592descant
impeccant1743612impeccant
peasant9314922peasant
pecan91919032pe_can_
pecans101515832pe_cans
peccancy1643952peccancy
peccantly1843952peccantly
peccary1636282peccary
peccavi1643092peccavi
pechan13511542pechan_
pechans14810502pechans
pedant9319492pe_dant
penchant1549582penchant
pendant10314852pendant
pennant9312492pennant
percent113520602percent
recant83228682re_cant
secant84023292se_cant
accent105116263_accent
bacchant1747803bacchant
bezant17814543be_zant
bezzant1746893bezzant
cant66362033___cant
chant105932693__chant
decane93818873de_cane
decants103514443de_cants
decent94023703de_cent
defiant11311923defiant
descants112910143descants
descent102616293descent
desiccant1444193desiccant
deviant11311313deviant
discant103017263discant
eclat7523603_ecla_t
eluant6315093_eluant
enchant12313123enchant
errant6618733_errant
etchant1249823etchant
expectant2045673expectant
extant132714753_extant
gelant72821673ge_lant
gellant83214053gellant
hepcat13611823hepca_t
incant82418513_incant
jessant1438443jessant
leant56737783le__ant
levant9314493le_vant
meant76537213me__ant
mecca1139933mecca__
meccas1239493mecca_s
mediant103516703mediant
medicant13910833medicant
merchant1548823merchant
octant81216553_octant
opencast1244873opencast
operant9317223ope_rant
pageant10312783pageant
pant66061263p___ant
passant9813943passant
peacing124117073peacing
peacoat11412913peacoat
pean66147173pe__an_
peans75437643pe__ans
peanut8318183pe__anut
peart76440753pe__art
peasants1038263peasants
peat65967933pe__a_t
peccable1648123peccable
peccavis1743133peccavis
peching154513903peching
pecking164017783pecking
pectase112410363pectase
pectate112214693pectate
pecten102711103pecten_
pectens11189203pectens
pectin102615533pectin_
pectins112315233pectins
pedants10310113pe_dants
pekan111613973pe_kan_
pekans121710553pe_kans
pelican1139433pelican_
pelicans1238093pelicans
peltast9310513peltast
pemican1348163pemican_
pemicans1447043pemicans
penang92511113pe_nang
penchants1646203penchants
pendants1139093pendants
pendent10314723pendent
penman10312323penman_
pennants1037063pennants
pent66559073pe___nt
pentane9415743pentane
percale11314093percale
percents122713373percents
percept133112523percept
perianth1348553perianth
periapt11313413periapt
permeant12310913permeant
perpent112318813perpent
persalt9315413persalt
petulant1048793petulant
pheasant1347083pheasant
picante11310523p_icante
piccata1345703piccata
pieplant1268733pieplant
piquant1848003piquant
pissant91012503pissant
plant75437113p__lant
pleasant1048323pleasant
pliant83918823p_liant
precast11314853precast
precent113520263precent
predicant1449393predicant
pregnant1149883pregnant
preplant12712913preplant
pschent1437413pschent
pulsant9310563pulsant
reaccent1278573reaccent
reactant10311433reactant
reboant9315093reboant
recane83022873re_cane
recants93217093re_cants
recast83422773re_cast
recent83630853re_cent
rechart12314333rechart
recoat84024273recoa_t
recount9315173recount
recreant10311283recreant
recusant1049463recusant
regnant8312843regnant
regrant8317323regrant
reliant7319243reliant
remnant9312643remnant
replant93318533replant
reptant92817073reptant
scant79735073__scant
sealant73118303sealant
seawant103613413seawant
secants93413893se_cants
sejant133114483se_jant
sejeant1489723sejeant
servant10313633servant
sextant142911963sextant
siccan1037593siccan_
speccing15306643speccing
teacart91113193teacart
tenant6322473te_nant
vacant11415133_vacant
verdant11313293verdant
versant10313833versant
vesicant1347503vesicant
webcast1445553webcast
wiccan1335033wiccan_
wiccans1434603wiccans

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.406440125.6
2DLD Change Limit1340271576.89319443.9
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.35924282.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.