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

390 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
pyrenes12351122(None) 
gyrenes11267521gyrenes
pyrene113210731pyrene_
pyrexes19305841pyrexes
pyrones123113301pyrones
arenes64928392_arenes
cymenes1477412cymenes
gyrene10227242gyrene_
parents93418122parents
pareses94718882pareses
penes75839222p__enes
pinenes93416672pinenes
preens85020112p_reens
prees75937172p_re_es
prexes154915952p_rexes
prezes173614692p_rezes
prunes83419062p_runes
purees84721682pure_es
pureness101110182pureness
purines94420762purines
pyrans11411062pyran_s
pyres105523882pyr__es
pyrites12812202pyrites
pyrone112714472pyrone_
pyropes142210192pyropes
pyroxenes2145452pyroxenes
serenes73222902serenes
styrenes11116622styrenes
syrens94911992syren_s
xylenes1745092xylenes
achenes12313493achenes
agenes74720253_agenes
agrees74915323agre_es
akenes104817343_akenes
alkenes114212753alkenes
amylenes13105703amylenes
apyrases1337243apyrases
arenas65021993_arenas
arene55329413_arene_
aretes64425353_aretes
bareges105212033bareges
bareness10912813bareness
benes75536233__benes
biremes1138773biremes
boranes93720403boranes
boreens9310403boreens
bredes94818473_bredes
brees75632553_bre_es
brens75823363_bren_s
brents84717273_brents
breves115516423_breves
brines85028853_brines
butenes9313033butenes
bygones1335913bygones
bylines1239243bylines
byres104421383byr__es
byrnies12378573byrnies
careens94514703careens
cranes84330753_cranes
cremes104517993_cremes
crenel84213063_crenel
crenels93711013_crenels
crepes105419343_crepes
crones84729243_crones
cyeses11510123cy_eses
cymene1377393cymene_
cypreses1535143cypreses
denes65639723__denes
dienes75719903_dienes
direness9311303direness
drees65628523_dre_es
drones75023433_drones
dynes95917583dy__nes
epergnes1156713epergnes
epicenes1249253epicenes
ernes55224813_er_nes
ethenes103313873ethenes
eyres84921773eyr__es
eyries93816813eyr_ies
frees86131393_fre_es
freres94716173_freres
furanes103214863furanes
genes65133093__genes
gerents82612923gerents
grebes93813613_grebes
greens75716873_greens
grees65132473_gre_es
gyrases11368313gyrases
gyrates113610263gyrates
gyres94820323gyr__es
gyrons105511223gyron_s
heredes11313133heredes
hirees95117293hire_es
hyaenas1334983hyaenas
hyenas1288953hy_enas
hygienes1543413hygienes
hymens1437993hymen_s
hyraces1537913hyraces
hyraxes2045703hyraxes
indenes82916253indenes
irones64724013_irones
kernes104717533ker_nes
ketenes114813503ketenes
krewes1337923_krewes
kyries133411373kyr_ies
larees65323113lare_es
lenes54738523__lenes
liernes739623liernes
lurexes1436073lurexes
lycees11428863lyce_es
lyres85019963lyr__es
lysines10369093lysines
marines93928013marines
mirexes1636993mirexes
moreens939963moreens
moreness10911573moreness
murexes1636973murexes
murines93718223murines
myceles1435213myceles
myrtles1235733myrtles
nenes55329673__nenes
oyezes1835053oy_ezes
padrones112711043padrones
paleness10312983paleness
panes76148693p__anes
pangenes112612823pangenes
pannes85522853p_annes
parades104121463parades
parangs104314373parangs
parcener1238473parcener
parceners1337453parceners
parches143720003parches
pardner10239473pardner
pardners11269193pardners
parent83230423paren_t
parented11912213parented
pareos87023773pare_os
parers85530743pare_rs
pares77164483par__es
paresis93315093paresis
pareus85420743pare_us
pareve114613013pareve_
parges94529543par_ges
paries84742513par_ies
parietes10714543parietes
parings104219213parings
parises94827183parises
parles86334403par_les
paroles95025883paroles
parries93925843parries
parses85534703par_ses
parties93230863parties
partner92811393partner
partners102711133partners
parures9512693parures
parvenues1444643parvenues
parvenus1335653parvenus
patens84820863paten_s
patents94815203patents
patines95225763patines
pavanes123612653pavanes
pawnees12298173pawnees
payees114812903paye_es
payments1536943payments
pedes85327293p__edes
peened94318163p_eened
peens76428193p_een_s
peeries93623023peeries
pees65257373p__e_es
peeves113814873p_eeves
pekes114623563p__ekes
peles75738083p__eles
pends85527193p__ends
penis75129323p__enis
pens65649643p__en_s
pentenes10315633pentenes
peones83821043p_eones
percents122713373percents
perches143717953perches
perdues103511333perdues
pereons92815003pereons
peres76246643p__eres
perinea9313033perinea
perpends13227753perpends
perpents122312043perpents
perries93226603perries
perses85428063per_ses
pertness10310093pertness
perukes133210113perukes
peruses94018163peruses
pewees11311393pewe_es
phereses1348093phereses
phoebes1435813phoebes
phones114121213p_hones
phrases12711463phrases
phreaks1634543phreaks
phrenic1438773phrenic
phrensies1445743phrensies
phrensy1533623phrensy
phyleses1645183phyleses
phytanes1645763phytanes
pieces104217273p_ieces
pierces113411193pierces
pinene82915643pinene_
pines76048863p__ines
pinones94717073pinones
piranas9912603piranas
pirates93020333pirates
pirns76020093pir_n_s
planes85028083p_lanes
plebes104313623p_lebes
plexes155313543p_lexes
polyenes13510063polyenes
polygenes1557503polygenes
pones74547043p__ones
porches143815673porches
pores75849033por__es
porgies103017003porgies
porkies133416493porkies
pornos85015253por_nos
porns75527343por_n_s
portends11358963portends
portents103512823portents
poteens92910883poteens
potences12710693potences
prances113618773p_rances
prangs94816233p_rangs
pranks124814723p_ranks
prases84429023p_rases
prates84633163p_rates
praxes156215183p_raxes
precess11310863p_recess
precis103416703p_recis
pree67044733p_re_e_
preed85128123p_re_ed
preen75925053p_re_en
preened103214993preened
preener93114833preener
preeners102712813preeners
prefer113813203p_refer
prefers123713333p_refers
premed114617763p_remed
premeds12389593p_remeds
premen105017803p_remen
premies113823063p_remies
prenames12311643p_renames
preops104911943p_reops
preps96220693p_re_ps
prese75228383p_rese_
preset84430983p_reset
presets94216423p_resets
press75425953p_re_ss
presses93523153p_resses
prests84021263p_rests
pretest9517633p_retest
prevues1239263p_revues
prexies163415003p_rexies
preyed125313203p_reyed
preyer114413733p_reyer
preyers124412363p_reyers
preys105717783p_re_ys
prices104524543p_rices
prides94324183p_rides
pries74339533p_r_ies
primes104225263p_rimes
princes113015143p_rinces
prinks124315383p_rinks
prints84320103p_rints
prises84133173p_rises
prizes173819813p_rizes
probes104119453p_robes
proles84627203p_roles
prone75332623p_rone_
prongs94314483p_rongs
propenes122816513propenes
proses84733473p_roses
proves114322253p_roves
prudes94215443p_rudes
prune75119633p_rune_
pruned93413113p_runed
pruner83413453p_runer
pruners93710723p_runers
prunus8399363p_runus
pryers115012243prye_rs
pugrees10218523pugre_es
puisnes937423puisnes
puranas9712643puranas
puree74632843pure_e_
pureed95017813pure_ed
purfles122511843purfles
purges94421763pur_ges
purine85321893purine_
purins83722653purin_s
purlines103514053purlines
purples112712833purples
purses84826373pur_ses
pursues94111373pursues
pyes95528993py___es
pygmies15205673pygmies
pyins105815863py_in_s
pylons113011243pylon_s
pyoses114314303py_oses
pyran10514473pyran__
pyranose1344923pyranose
pyranoses1445853pyranoses
pyre94925553pyr__e_
pyrenoid1446873pyrenoid
pyrenoids1544803pyrenoids
pyretic143210783pyretic
pyrex175211213pyr__ex
pyrexia19225463pyrexia
pyrexias20224993pyrexias
pyrexic21235353pyrexic
pyridines1546473pyridines
pyrite11913313pyrite_
pyrogen1337353pyrogen
pyrogens1437293pyrogens
pyrolas1239863pyrolas
pyronines1458323pyronines
pyrope132810533pyrope_
pyros105718293pyr__os
pyrosis12411653pyrosis
pyroxene2045083pyroxene_
pyrroles1345453pyrroles
pyrrols1235403pyrrols
pyxes175911403py__xes
pyxides2034423pyxides
pyxies18338293py_xies
rareness81112853rareness
redes65139133__redes
rees45364193__re_es
reges65628793__reges
rends65129953__rends
renest64529713__renest
renew83917513__renew
renews93811753__renews
rentes65431193__rentes
rents55935183__rents
rerents73319423rerents
retenes76324623retenes
rexes124526953__rexes
runes55530223__runes
sarees65329943sare_es
scenes84520353_scenes
screens95212183screens
screes85023973scre_es
serene63522353serene_
serener73415763serener
serenest82717623serenest
serines74229543serines
shrines104618693shrines
sirees64624583sire_es
sirens65318153siren_s
skenes104616633_skenes
soreness8914793soreness
spareness1139863spareness
sphenes123013163sphenes
spiremes12397623spiremes
sprees85620643spre_es
styrene10116693styrene_
sureness8912903sureness
sycees11409653syce_es
syren85216743syren__
syrettes1136963syrettes
syringes122810213syringes
syrinxes18294423syrinxes
ternes65422903ter_nes
terpenes102111573terpenes
terrenes82212603terrenes
threes97117323thre_es
thrones105715843thrones
treens65317873_treens
trees55835763_tre_es
trends75513543_trends
trienes74118413trienes
trines64132563_trines
trones65629283_trones
tureens7289873tureens
tyees86019453ty_e_es
tynes85920303ty__nes
tyrants1037453tyrants
tyres84725233tyr__es
uptrends1142833uptrends
urines64724123_urines
venenes102712133venenes
wrens85016243_wren_s
xylene1645793xylene_
yens75832263_y_en_s
yentes95517603_y_entes
yeses85119323_y_eses

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273905.68623571.4
3Display Results3903900.1432727.3
 (SQL Overall)1786913906.23528659.3
 
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.