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

249 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
peter7442759(None) 
deter65028041deter
meter75130321meter
pater74740721pater
peer66238351pe_er
pelter83321621pelter
perter84422281perter
pester84827591pester
peters86624591peters
petter83924771petter
pewter114013671pewter
aether94213672aether
after85719792after
alter54828502alter
apter76120202apter
aster55434892aster
beater84729392beater
beer65635992be_er
belter84720962belter
betel74419902betel
better84723702better
biter75030032biter
cater74840722cater
ceder85322232ceder
center84421412center
cete64934782cete_
cetes75731102cetes
citer74827332citer
cuter74728232cuter
dater65332312dater
deer56739022de_er
defer94619752defer
defter104215922defter
deters74724682deters
dexter143810892dexter
dieter73516772dieter
doter65428622doter
eater54639842eater
eger55923562_eger
enter54726382enter
ester54727712ester
ether84518772_ether
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
feater95224052feater
fester94723512fester
fete75734922fete_
feted94420932feted
fetes85630142fetes
fetor81214532fetor
fetter94120382fetter
fever115617952fever
fewer115216122fewer
feyer115014522feyer
gater64533652gater
getter74117612getter
hater85034752hater
heater94828302heater
heder95623632heder
hefter124313922hefter
hetero9312632hetero
hewer115719932hewer
hexer155116682hexer
inter55028492inter
jeer115426462je_er
jester134319152jester
jete115927252jete_
jetes124922842jetes
kelter103214372kelter
kiter95523212kiter
later54843922later
leer46239352le_er
lefter93613432lefter
leger65721502leger
leper74820742leper
letter63722582letter
lever85125162lever
liter54736342liter
mater74438862mater
meeter83616502meeter
melter83520112melter
merer75126232merer
mete64438132mete_
meted85424432meted
meteor84910072meteor
meters85625832meters
metes74736212metes
metier83517692metier
metre74821302metre
miter75734792miter
muter74525542muter
neater64424312neater
nester64124182nester
nether94014162nether
netter63722022netter
neuter63713792neuter
never86218642never
newer85717462newer
niter55028972niter
noter55025642noter
oater55433732oater
ofter84116872ofter
opener83910992opener
otter54423972otter
outer55633302outer
oxter123414092oxter
pacer96131612pacer
pager84728202pager
paler75436932paler
palter84423262palter
paper95128662paper
parer75839902parer
paster85734372paster
pate65350462pate_
pated85237842pated
paten74827342paten
paters84935832paters
pates76047892pates
patter84628262patter
patzer173111642patzer
paver104225832paver
pawer104422972pawer
payer105125722payer
pear69745232pe_ar
pearter9412742pearter
peatier94017232peatier
pecker144615362pecker
pecten102711102pecten
pedes85327282pedes
pedler93614612pedler
pee56066512pe_e_
peed76239182pe_ed
peek106031432pe_ek
peel65535612pe_el
peeler83517382peeler
peen65938082pe_en
peep85833692pe_ep
peeper103614802peeper
peers75130272pe_ers
peery105719442pe_ery
pees65257372pe_es
peke105926202peke_
pekes114623562pekes
pele65539552pele_
peles75738082peles
pelted94617752pelted
pelters93720312pelters
penes75839222penes
penner84616662penner
penster92811952penster
pepper93512942pepper
per56353092p__er
pere66450262pere_
perea75026442perea
peres76246642peres
pesters93827092pesters
pestier94317402pestier
pet56477302pet__
petal76526892petal
petard95013802petard
petered103314962petered
petit74332652petit
petrel83111532petrel
pets66248332pet_s
petted94121522petted
petters93722362petters
petti75119452petti
pettier94213612pettier
petto76021042petto
petty105320292petty
pewee10319972pewee
pewters124113352pewters
piecer105213082piecer
pier66035292p_ier
piker115622842piker
piper96523192piper
pitier84019822pitier
plater84427692plater
pleater93916332pleater
plier75221282plier
plyer106214332plyer
poker115122882poker
poler74431792poler
porter84224412porter
poser75128772poser
poster84129172poster
pother113818852pother
potter83926982potter
potzer174411212potzer
pouter83923982pouter
power105325952power
powter114116032powter
prater84825352prater
prefer113813202prefer
prester93519622prester
preterm11310152preterm
pretor8315742pretor
preyer114413732preyer
prier75027762prier
pryer104415312pryer
puler74826622puler
punter84320022punter
purer75127902purer
putter83921442putter
rater54943282rater
refer84822142refer
renter64527412renter
rester63832432rester
rete44944132rete_
retear63115482retear
retem74221952retem
seater64534152seater
seder64826752seder
seer45547042se_er
serer55935502serer
setter64023722setter
sever85426052sever
sewer84426212sewer
specter113111732specter
speer74623902spe_er
spelter94113702spelter
spewer115112142spewer
steer55423862steer
tater54138612tater
teeter65420312teeter
tenter64623932tenter
tester64227152tester
tether93716102tether
tetter64322452tetter
titer55430612titer
toter55932132toter
ureter6313202ureter
utter54218762utter
veer76229572ve_er
venter94218722venter
vetoer93410062vetoer
vetter93417642vetter
vexer155513522vexer
voter85121052voter
water84733312water
weber10313522weber
weer75535092we_er
welter93417382welter
wester94222892wester
wether123315392wether
wetter93919442wetter
yester93417982yester
zester153617792zester

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 Filter178691538000.0931921408.6
2DLD Change Limit538002496.6268119.5
3Display Results2492490.0763276.3
 (SQL Overall)1786912496.79526297.4
 
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.