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

465 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
perrons9311548(None) 
pereons92815001pereons
perron83216621perron_
persons93717011persons
errors63311312_errors
ferrous1049792ferrous
garrons82713462garrons
herons94820542he_rons
marrons93216972marrons
merlons93311272merlons
neurons7410442neurons
operons91411742ope_rons
pardons103817622pardons
parrots9312742parrots
parsons93516872parsons
partons94620512partons
patrons93818102patrons
pedros9312182pedro_s
pennons939712pennons
peons75327182pe__ons
pereions10310852pereions
pereon83517452pereon_
perigons11310082perigons
periods10312242periods
pernods1038482pernods
perries93226602perries
person83517872person_
persona92812452persona
personas102511882personas
petrols92913082petrols
petrous92714422petrous
pierrots1044962pierrots
prions84317782p_rions
pyrrols1235402pyrrols
sermons9311782sermons
terrors73112212terrors
aeons57624653ae__ons
aleurons867013aleurons
aprons8316993_aprons
argons75018203_argons
arrows92813483_arrows
arsons63917213_arsons
barons85025383_barons
barrens94414323barrens
barrows123411683barrows
baryons121010473baryons
beacons11410733beacons
beckons15279143beckons
begroans1145503begroans
belons84119413be_lons
berlins93216013berlins
berries94423553berries
betons84919553be_tons
bicrons113410473bicrons
borons85520543_borons
borrows12349253borrows
burros85114993burro_s
burrows12399093burrows
burtons9310853burtons
carbons115418943carbons
cardons104519943cardons
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryons1337103carryons
cartons94122473cartons
ceros74726073ce_ro_s
cerous85821203ce_rous
chevrons1665463chevrons
cirrous93111063cirrous
citrons92913223citrons
cordons104415763cordons
crepons1139323crepons
croons85418423_croons
cupferrons1751393cupferrons
currans9310613currans
dacrons103211033dacrons
deacons10310393deacons
decrowns14265063decrowns
dehorns11428363dehorns
demons94917723de_mons
dendrons1047393dendrons
derries83124623derries
derris73615273derr_is
devons104512253de_vons
diurons838823diurons
durions839963durions
earns55927563_ear_ns
ebons74316093_e_bons
eikons1038503_eikons
enrols61213383_enrols
eons46638713_e__ons
epigons1048183epigons
ergots74512373_ergots
erns45428233_e_r_ns
eros45238453_e_ro_s
errand758793_errand
errands847603_errands
errant6618733_errant
errants7410643_errants
erring73816483_erring
error53712233_erro_r
errs45622533_err__s
euros54920243_euro_s
exons125813343_e_xons
farrows13259783farrows
felons93615763fe_lons
fenurons1174963fenurons
fermions1336203fermions
ferns85220083fe_r_ns
ferrels10248623ferrels
ferreous1146033ferreous
ferrets103111393ferrets
ferries103521083ferries
ferrums1265983ferrums
fervors1336233fervors
fleurons1155343fleurons
frons86124043__frons
furrows13327793furrows
garcons102411643garcons
garron73113493garron_
genros74211333genro_s
germans1079473germans
germens1078633germens
girons75014373_girons
gorgons938853gorgons
guerdons1044233guerdons
gyrons105511223_gyrons
hadrons113314303hadrons
harrows132611033harrows
hereon93914363hereon_
heriots10312063heriots
herns84825583he_r_ns
heroes94923823he_roes
heroins103518013heroins
heron85025503he_ron_
heros84930863he_ro_s
herries104025073herries
herring113615883herring
herrings12379533herrings
horrors1078693horrors
hyperons1649203hype_rons
introns73515023introns
irons55324133__irons
jargons1558203jargons
jerboas1636163jerboas
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
jetons134512613je_tons
jettons1437273jettons
karroos1139313karroos
kelsons1137323kelsons
kerns94719563ke_r_ns
kerrias11289513kerrias
kerries113317913kerries
kroons103711243_kroons
ladrons83813193ladrons
lardons83914493lardons
learns65513743lear_ns
legions84611783legions
lemons84415053le_mons
leprous938843leprous
leptons91910433leptons
lesions73813873lesions
lessons73811023lessons
leukons1135753leukons
macrons113514893macrons
maroons92615553maroons
marron83717543marron_
marrows122911823marrows
matrons93517633matrons
melons84117713me_lons
meltons9410923meltons
merinos9311983merinos
merlins93015813merlins
merlon83012353merlon_
merlots92710123merlots
mesons83215843me_sons
metros84217803metro_s
microns113814783microns
mikrons13428413mikrons
mirrors938623mirrors
morions94014643morions
morons84919543_morons
morrions1077673morrions
morros83714673morro_s
morrows12318723morrows
narrows10258843narrows
natrons73215663natrons
negroni846833negroni
negronis947263negronis
nektons1136393nektons
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
nephrons1346853nephrons
nerols6914883ne_rols
nervous1037143nervous
neuron6310373neuron_
neurone739433neurone
neurones839673neurones
neutrons838293neutrons
newtons1036813newtons
operon8811773ope_ron_
orlons6411013_orlons
overruns1138173overruns
padrone102512073padrone
padrones112711043padrones
padroni10278613padroni
paeons83915523p_aeons
paragons11311503paragons
pardon94618733pardon_
pareos87023773pareo_s
pargos95719043pargo_s
parians93519733parians
parlors9312913parlors
parlous9414293parlous
parols84722613p_arols
parous84024163p_arous
parrals94414573parrals
parrels94713493parrels
parries93925843parries
parring103222063parring
parrot8320663parro_t
parroty1247863parroty
parrs75928673parr__s
parson83817903parson_
partans94418283partans
parton84720993parton_
parvos116614753parvo_s
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
peahens12307573peahens
peans75437643pe__ans
pearls84715393pear_ls
pears75138613pear__s
pecans101515833pe_cans
pechans14810503pechans
pectens11189203pectens
pectins112315233pectins
pedro8313153pedro__
peens76428193pe__ens
peeress939503peeress
peeries93623023peeries
peering103520353peering
peers75130273peer__s
peins76128063pe__ins
pekans121710553pe_kans
pekins121812233pe_kins
pekoes124410423pe_koes
pelon74423213pe_lon_
pelorus939273pelorus
pelotons1038913pelotons
pengos94612413pengo_s
pennon8310643pennon_
pens65649643pe___ns
pensions10311693pensions
peon65635243pe__on_
peones83821043pe__ones
peony105717563pe__ony
peperoni1246273peperoni
peperonis1346623peperonis
pepinos1137693pepinos
peplos101211543peplo_s
pepos96620083pe_po_s
pepsins11310433pepsins
peptone11310763peptone
peptones12311033peptones
percent113520603percent
percents122713373percents
perches143717953perches
percoid12312313percoid
percoids1339663percoids
percuss1137163percuss
perdues103511333perdues
perdus93711273pe_rdus
peregrins1246963peregrins
pereion9312053pereion_
peres76246643pe_r_es
perform1439283perform
performs1547483performs
pergola1067623pergola
pergolas1158233pergolas
perhaps1446123perhaps
peridots1138323peridots
perigon1039853perigon_
perilous10310693perilous
perils84121853pe_rils
period9314983perio_d
peris75537073pe_r_is
peritus9311803peritus
perking143716463perking
perks115325803pe_r_ks
perming123416093perming
permits11314003permits
perms95524513pe_r_ms
perniones1148593perniones
pernod9310453perno_d
peroral9314793peroral
peroxy1838253pe_roxy
perpend12259353perpend
perpends13227753perpends
perpent112318813perpent
perpents122312043perpents
perps95521483pe_r_ps
perry105222713perr__y
perses85428063pe_rses
personae102410553personae
personal102311573personal
personals11238573personals
pertains102113423pertains
perukes133210113perukes
peruses94018163peruses
pervious1337543pervious
pervs105117373pe_r_vs
pesos77221623pe_so_s
pestos84719083pesto_s
petrels9279373petrels
petrol82714063petro_l
petronel1048143petronel
petronels1146063petronels
pharos11312063pharo_s
phonons123310253phonons
phons105221143p__hons
photons123814433photons
phytons15319063phytons
pierrot948833pierro_t
pigeons1039183pigeons
pinions93413603pinions
pinons86019943p_inons
pinyons12299003pinyons
pions75826393p__ions
pirns76020093p_ir_ns
pistons93016373pistons
pitons85319043p_itons
plectrons13258073plectrons
pleons84213343p_leons
pleuron976343pleuron_
plutons938343plutons
pogroms1237643pogroms
poisons9310353poisons
polarons1039863polarons
pompons1338553pompons
pons65850603p___ons
pontons93315553pontons
poons75430973p__oons
pornos85015253porno_s
porns75527343p_or_ns
porous84419483p_orous
portions10514413portions
potions93417423potions
praos74923563p_rao_s
prawns11509023p_rawns
preens85020113p_reens
preops104911943p_reops
prerinse1038633prerinse
prerock1536723prerock
presong1039843presong
pretors9316813pretors
prion75119993p_rion_
priors83914483p_riors
prisons9313223prisons
proas75028803p__roas
prods85523553p__rods
profs105120893p__rofs
progs86624153p__rogs
proms95426413p__roms
prone75332623p__rone
prong85218113p__rong
prongs94314483p__rongs
proofs114511683p_roofs
props95726883p__rops
pros65742783p__ro_s
pross76529403p__ross
protons93118003protons
prows106327013p__rows
pterins9812993pterins
purins83722653p_urins
purlins93415423purlins
purloins1077033purloins
purring104515823purring
purrs75320433purr__s
putons83515153p_utons
pylons113011243p_ylons
pyrans11411063p_yrans
pyrone112714473p_yrone
pyrones123113303p_yrones
pyros105718293p_yro_s
pyrrol1136273pyrro_l
pyrrole1246033pyrrole
pyrroles1345453pyrroles
pythons1537363pythons
reasons72514943reasons
reckons13269653reckons
recons84922993re_cons
recross989833recross
recrowns13246143recrowns
redons75222183re_dons
refront10313263refront
refronts1137773refronts
regions83613473regions
regrows11269153regrows
repros84216003repro_s
reroofs1037943reroofs
reruns66413743re_runs
retros63820193retro_s
seasons72614233seasons
sereins73716123sereins
serins64029673se_rins
serious73616283serious
sermon8413553sermon_
serous65023563se_rous
serows96016393se_rows
serrano768463serrano
serranos857873serranos
serries73925353serries
servos93812723servo_s
setons64620173se_tons
sextons143710413sextons
sorrows10278403sorrows
sparrows1344803sparrows
spermous1247933spermous
sporrans1045523sporrans
tarpons92612213tarpons
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
termors94712773termors
ternions838813ternions
terns55226873te_r_ns
terrains8410323terrains
terrane72814233terrane
terranes82514433terranes
terras63516973terr_as
terreens8246533terreens
terrene72411033terrene
terrenes82212603terrenes
terrets72913583terrets
terries73425633terries
terrine72517573terrine
terrines82117553terrines
territs72714503territs
terror63811733terro_r
testons7313563testons
thorons104511913thorons
turions7311573turions
turnons737863turnons
unpersons1146853unpersons
verdins112812333verdins
versions11310353versions
versos93812803verso_s
virions1039873virions
warrens103810893warrens
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
xenons132710483xe_nons
yarrows13277853yarrows
yearns9509543year_ns
zeroes154314343ze_roes
zeros144918113ze_ro_s
zircons1854963zircons

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.390458182.1
2DLD Change Limit1340274657.09618887.7
3Display Results4654650.1702735.3
 (SQL Overall)1786914657.65623340.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.