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 “peters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
peters8662459(None) 
deters74724681deters
meters85625831meters
paters84935841paters
peers75130271pe_ers
pelters93720311pelters
pesters93827091pesters
peter74427591peter_
petters93722361petters
pewters124113351pewters
aethers103614942aethers
afters94717072afters
alters64924222alters
asters65631602asters
beaters94925042beaters
beers75628392be_ers
belters93819412belters
betels84515062betels
betters94422092betters
biters83925242biters
caters85336502caters
ceders93817672ceders
centers94420602centers
cetes75731102cete_s
citers85022982citers
daters74827372daters
deers64930522de_ers
defers105116942defers
deter65028042deter_
dieters83216432dieters
doters74423912doters
eaters65535952eaters
egers65120372_egers
enters64425642enters
esters64627732esters
ethers94518412_ethers
ewers86018822_ewers
eyers86521332_eyers
festers104121392festers
fetes85630142fete_s
fetors91014472fetors
fetters103517902fetters
fevers125414892fevers
gaters74728642gaters
getters84216102getters
haters94930402haters
heaters104225222heaters
heders104119762heders
hefters134312002hefters
hetero9312632hetero
heteros10312682heteros
hewers123715272hewers
hexers165612752hexers
inters64328052inters
jeers124818132je_ers
jesters144118192jesters
jetes124922842jete_s
kelters113813752kelters
kiters105218592kiters
leers54828982le_ers
legers74518312legers
lepers84817322lepers
letters73819852letters
levers94621322levers
liters65429882liters
maters85032392maters
meeters94714542meeters
melters93918312melters
meteors94610012meteors
meter75130322meter_
metes74736212mete_s
metiers93312842metiers
metres85121562metres
miters84328782miters
nesters74422792nesters
netters73618582netters
neuters74212272neuters
niters64624212niters
noters64021002noters
oaters65029792oaters
openers9339492openers
otters64021512otters
outers64230172outers
oxters134813272oxters
pacers105124542pacers
pagers94423252pagers
palters94021682palters
papers105125322papers
parers85530742parers
pasters94531732pasters
patens84820862patens
pater74740732pater_
pates76047892pate_s
patters94825192patters
patzers184210572patzers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
pears75138612pe_ars
peckers153312672peckers
pectens11189202pectens
pedes85327292pede_s
pedlers103013272pedlers
peeks115021112pe_eks
peelers93615592peelers
peels75226422pe_els
peens76428192pe_ens
peepers113713672peepers
peeps95822362pe_eps
peer66238352pe_er_
peery105719442pe_ery
pees65257372pe_e_s
pekes114623562peke_s
peles75738082pele_s
pelter83321622pelter_
penes75839222pene_s
penners93414182penners
pensters103012122pensters
peppers103311442peppers
peres76246642pere_s
perter84422282perter_
pester84827592pester_
petals84719812petals
petard95013802petard
petards104311152petards
petered103314972petered
petrel83111532petrel
petrels9279372petrels
pets66248332pet__s
petter83924772petter_
pewees11311392pewees
pewter114013672pewter_
piecers114112252piecers
piers75926332p_iers
pikers124717392pikers
pipers104318662pipers
pitiers93812652pitiers
platers93924092platers
pleaters103613792pleaters
pliers84715152pliers
plyers114912982plyers
poetess938932poetess
pokers124617922pokers
polers84225642polers
porters93722702porters
posers84223972posers
posters93928012posters
pothers123818622pothers
potters94024342potters
potzers184010542potzers
pouters94221872pouters
powers113822322powers
powters124015662powters
praters94921652praters
prefers123713332prefers
presters103419012presters
preterm11310162preterm
preterms1237222preterms
pretors9316822pretors
preyers124412372preyers
priers84521192priers
pryers115012242pryers
pulers83820282pulers
punters93617052punters
putters94219192putters
raters63936582raters
refers93921082refers
renters74224822renters
resters74130402resters
retears72814922retears
retems83914572retems
revers94529632revers
seaters74028942seaters
seders74420282seders
seers55136382se_ers
setters73822062setters
severs94121122severs
sewers94719722sewers
specters122811062specters
speers85019952spe_ers
spelters103912242spelters
spewers124210662spewers
steers63820982steers
taters64932202taters
teeters74018302teeters
tenters73921112tenters
testers74124542testers
tethers103815312tethers
tetters74320472tetters
titers64526412titers
toters65026362toters
ureters7311822ureters
utters63817122utters
veers84521362ve_ers
venters103717732venters
vetoers10359472vetoers
vetters104016322vetters
vexers165210402vexers
voters95017442voters
waters95030642waters
webers11310942webers
welters103516062welters
westers105221962westers
wethers135214692wethers
wetters103817752wetters
zesters163517292zesters

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512062.50033020.4
3Display Results2062060.0633269.8
 (SQL Overall)1786912062.90661490.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.