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

511 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
perron8321662(None) 
pereon83517451pereon
perrons93115481perrons
person83517871person
error53712232_error
garron73113492garron
hereon93914362hereon
heron85025502he_ron
marron83717542marron
merlon83012352merlon
neuron6310372neuron
operon8811772ope_ron
pardon94618732pardon
parrot8320662parrot
parson83817902parson
parton84720992parton
patron84018042patron
pedro8313152pedro_
pedros9312182pedros
pelon74423212pe_lon
pennon8310642pennon
peon65635242pe__on
pereion9312052pereion
pereons92815002pereons
perigon1039852perigon
period9314982period
pernod9310452pernod
perry105222712perr_y
persona92812452persona
persons93717012persons
petrol82714062petrol
pierrot948832pierrot
pleuron976342pleuron
prion75119992p_rion
pyrrol1136272pyrrol
sermon8413552sermon
terror63811732terror
aeon45634613ae__on
aero45435343ae_ro_
aleuron757383aleuron
apron7318833_apron
argon65520593_argon
arrow83414893_arrow
arson55118833_arson
baron78131243_baron
barren85317623barren
barrow114512773barrow
baryon111211613baryon
beacon10511373beacon
beckon14309383beckon
begroan1036103begroan
belon73924113be_lon
berlin83116373berlin
berry104521773berr_y
beton76022063be_ton
bicron103710773bicron
boron76727143_boron
borrow114310733borrow
burro75018493burro_
burros85114993burros
burrow114610813burrow
burton8311273burton
carbon104919043carbon
cardon94120853cardon
carrion9312673carrion
carrom10513403carrom
carrot8423123carrot
carryon1237033carryon
carton84522663carton
cero66329453ce_ro_
ceros74726073ce_ros
chevron1575783chevron
citron83112983citron
cordon95017293cordon
crepon1039943crepon
croon75522783_croon
cupferron1651303cupferron
curran8312023curran
dacron94310693dacron
deacon9510423deacon
decrown13206053decrown
dehorn10439653dehorn
demon86520313de_mon
dendron947653dendron
derris73615273derris
derry94721373derr_y
devon95113683de_von
diuron738573diuron
durion7510963durion
earn46737553_ear_n
ebon66821103_e_bon
eikon939463_eikon
enrol51014283_enrol
eon36052083_e__on
epigon937963epigon
ergo56420153_ergo_
ergot65422893_ergot
ern35738363_e_r_n
eros45238453_e_ros
err35626533_err__
errand758793_errand
errant6618733_errant
erred65915673_erred
erring73816483_erring
errors63311313_errors
errs45622533_err_s
euro45325273_euro_
euros54920243_euros
exon117116803_e_xon
farrow12309983farrow
felon84619293fe_lon
fenuron1075153fenuron
fermion1236763fermion
fern76129323fe_r_n
ferrel92810203ferrel
ferret93021173ferret
ferric1139993ferric
ferrous1049803ferrous
ferrum1147453ferrum
ferry116020803ferr_y
fervor1235643fervor
fleuron1055573fleuron
furrow12427743furrow
garcon92912483garcon
garrons82713463garrons
genro64914033genro_
genros74211333genros
german9611983german
germen9612313germen
giron66118993_giron
gorgon8310243gorgon
guerdon944343guerdon
gyron95314623_gyron
hadron102913753hadron
harrow122610783harrow
herein93717793herein
hereof123212373hereof
heriot9422343heriot
hern76134893he_r_n
hero74635783he_ro_
heroin94420593heroin
herons94820543he_rons
heros84930863he_ros
herring113615883herring
herry114922473herr_y
horror988723horror
hyperon1548183hype_ron
intron64215023intron
iron46728463__iron
jargon1448823jargon
jeon116821443je__on
jerboa1535633jerboa
jerkin17258113jerkin
jerrid14259143jerrid
jerry155016183jerr_y
jeton124815403je_ton
jetton1338033jetton
karroo10410013karroo
kelson1038153kelson
kern85326223ke_r_n
kerria10339923kerria
kerry124916093kerr_y
kroon94514483_kroon
ladron73413323ladron
lardon74415063lardon
learn55322663lear_n
legion75712983legion
lemon75618183le_mon
lepton82510803lepton
lesion64715063lesion
lesson64412043lesson
leukon1036143leukon
macron103615673macron
maroon83118203maroon
marrons93216973marrons
marrow112812613marrow
matron83918313matron
megaron10248303megaron
melon73922083me_lon
melton8311553melton
merino8315093merino
merlin83916683merlin
merlons93311273merlons
merlot83217613merlot
merman10513863merman
mermen10813813mermen
merry104721493merr_y
meson74118313me_son
metro74718803metro_
metros84217803metros
micron103714283micron
mikron12318503mikron
mirror848003mirror
morion86217733morion
moron76925423_moron
morrion959003morrion
morro73216953morro_
morros83714673morros
morrow113510093morrow
narrow9269153narrow
natron64116023natron
negroni846843negroni
nekton1036583nekton
nelson638423nelson
neocon836713neocon
neon47026423ne__on
nephron1246653nephron
nerol51017813ne_rol
neurone739443neurone
neurons7410453neurons
neutron737763neutron
newton936983newton
operons91411743ope_rons
orlon5415003_orlon
overran10311663overran
overrun1038023overrun
padrone102512073padrone
padroni10278613padroni
paeon74819493p_aeon
paragon10311023paragon
pardons103817623pardons
pareo74632603pareo_
pareos87023773pareos
parergon1144393parergon
pargo86723723pargo_
pargos95719043pargos
parian83223963parian
parlor8312673parlor
parol74826273p_arol
parr65731153parr__
parral85517533parral
parred95024073parred
parrel84515983parrel
parring103222063parring
parrots9312743parrots
parroty1247863parroty
parrs75928673parr_s
parry105323753parr_y
parsons93516873parsons
partan83820563partan
partons94620513partons
parvo107719183parvo_
parvos116614753parvos
patrol83213023patrol
patrons93818103patrons
patroon92811973patroon
peahen113410133peahen
pean66147173pe__an
pear69745233pear__
pearl75324463pear_l
pearls84715393pearls
pearly116414843pearly
pears75138613pear_s
peart76440753pear_t
peasen84815963peasen
pecan91919033pe_can
pechan13511543pechan
pecten102711103pecten
pectin102615533pectin
peen65938083pe__en
peer66238353peer__
peered93819493peered
peerie83617893peerie
peering103520353peering
peers75130273peer_s
peery105719443peer_y
pegbox1844013pegbox
pein65834943pe__in
pekan111613973pe_kan
pekin111514423pe_kin
pekoe114612363pe_koe
peloton938743peloton
pen56558843pe___n
pengo84317593pengo_
pengos94612413pengos
penman10312323penman
penmen10311493penmen
pennons939713pennons
pension9412203pension
peons75327183pe__ons
peony105717563pe__ony
peperoni1246273peperoni
pepino10310333pepino
peplos101211543peplos
pepo87622153pe_po_
pepos96620083pe_pos
pepsin10310853pepsin
peptone11310763peptone
per56353093pe_r__
percent113520603percent
perch124518833pe_rch
percoid12312323percoid
perdie94718513perdie
perdu84216273pe_rdu
perdue93912633perdue
perdus93711273perdus
perdy115417333pe_rdy
pere66450263pe_r_e
perea75026443pe_rea
peregrin1146993peregrin
pereia85217983pereia
pereions10310853pereions
peres76246643pe_res
perform1439283perform
pergola1067623pergola
peri65636973pe_r_i
peridot10514243peridot
perigons11310083perigons
peril75425953pe_ril
perils84121853perils
periods10312243periods
peris75537073pe_ris
perish114619063perish
periti8319953periti
perk106232843pe_r_k
perked134617693perked
perking143716463perking
perks115325803pe_rks
perky145319483pe_rky
perm85834633pe_r_m
permed115217353permed
permian112612283permian
perming123416093perming
permit10321683permit
perms95524513pe_rms
pernio8513143pernio
pernods1038483pernods
peroral9314793peroral
peroxy1838253peroxy
perp89029893pe_r_p
perpend12259353perpend
perpent112318813perpent
perps95521483pe_rps
perries93226603perries
perse75429523pe_rse
perses85428063perses
personae102410553personae
personal102311573personal
personas102511883personas
pert66759323pe_r_t
pertain92714963pertain
perter84422283perter
pertly115312553pertly
peruke123210393peruke
peruse84016843peruse
perv97224813pe_r_v
pervs105117373pe_rvs
peso66925823pe_so_
pesos77221623pe_sos
pesto75723723pesto_
pestos84719083pestos
petrel83111533petrel
petrols92913083petrols
petronel1048143petronel
petrous92714423petrous
petto76021043petto_
pharos11312063pharos
phon95925383p__hon
phonon114012033phonon
photon1111514833photon
phylon14318033phylon
phyton143610253phyton
pierrots1044963pierrots
pigeon949413pigeon
pinion83815893pinion
pinon76024533p_inon
pinyon11459763pinyon
pion67235303p__ion
pirn67128383p_ir_n
pirog83913673p_irog
piston83515923piston
piton76121583p_iton
plectron12228023plectron
pleon74216383p_leon
pluton838853pluton
pogrom1138593pogrom
poison8312223poison
polaron939843polaron
pompon1238943pompon
ponton83217643ponton
poon67341263p__oon
porn65636023p_or_n
porno75120653porno_
pornos85015253pornos
portion9615493portion
potion84519573potion
prao66229023p_rao_
praos74923563p_raos
prawn105312433p_rawn
preen75925053p_reen
preman104117453preman
premen105017803premen
prenoon9310043prenoon
preop94715873p_reop
preriot9316413preriot
prerock1536723prerock
presong1039843presong
pretor8315753pretor
preworn124711223preworn
prions84317783p_rions
prior74316173p_rior
prison8514023prison
pro55837263p__ro_
proa66229963p__roa
prod76129503p__rod
prof96134663p__rof
prog75729003p__rog
prom87631703p__rom
prone75332623p__rone
prong85218113p__rong
proof105221533p_roof
prop85932813p__rop
pros65742783p__ros
proton84318893proton
prow97030383p__row
pterin81014153pterin
purin75527593p_urin
purlin83615863purlin
purloin9107493purloin
purr64925813purr__
purred94218073purred
purring104515823purring
purrs75320433purr_s
puton73617913p_uton
pylon103614003p_ylon
pyran10514473p_yran
pyro96019393p_yro_
pyrone112714473p_yrone
pyros105718293p_yros
pyrrole1246033pyrrole
pyrrols1235403pyrrols
python1447143python
reason62616333reason
reborn810016963reborn
reckon123010543reckon
recon75624243re_con
recrown12257573recrown
redon65424883re_don
refront10313263refront
region74614903region
regrow10309883regrow
regrown11237363regrown
repro75315913repro_
repros84216003repros
reran57329103re_ran
reroof9315003reroof
rerun58722153re_run
retorn610923433retorn
retro55020953retro_
retros63820193retros
rewon86920583re_won
reworn98122203reworn
season62714903season
serein63318463serein
serin55434443se_rin
sermons9311783sermons
serow86720443se_row
serrano768463serrano
serry84824123serr_y
servo84516683servo_
servos93812723servos
seton55223543se_ton
sexton133610793sexton
sierran737193sierran
sorrow9339443sorrow
sparrow1234273sparrow
sporran936743sporran
tarpon82812803tarpon
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513te_non
termor84412513termor
tern46134803te_r_n
ternion739493ternion
terra54419673terr_a
terrae62915213terrae
terrain7410853terrain
terrane72814233terrane
terras63516973terras
terreen7257573terreen
terrene72411033terrene
terret63425623terret
terrine72517573terrine
territ63421383territ
terrors73112213terrors
terry84721873terr_y
teston6313303teston
thereon10199263thereon
thoron94713903thoron
turion6313163turion
turnon638193turnon
unperson1046383unperson
verdin103113023verdin
vermin113414523vermin
version10310923version
verso85314633verso_
versos93812803versos
virion9310683virion
warren95012863warren
weakon13357623weakon
weapon11288113weapon
weason93210823weason
whereon13196513whereon
xenon122612453xe_non
xerox1138623xe_rox
yarrow12287943yarrow
yearn86316433year_n
zero134822473ze_ro_
zeros144918113ze_ros
zircon1754953zircon

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 Filter1786911127160.376475242.0
2DLD Change Limit1127165115.78019501.0
3Display Results5115110.1732953.8
 (SQL Overall)1786915116.32928233.7
 
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.