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

252 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
pyrexes1930584(None) 
prexes154915951p_rexes
pyrenes123511221pyrenes
gyrenes11267522gyrenes
hyraxes2045702hyraxes
lurexes1436072lurexes
mirexes1636992mirexes
murexes1636972murexes
pareses94718882pareses
plexes155313542p_lexes
praxes156215182p_raxes
prees75937172p_re_es
prexies163415002p_rexies
prezes173614692p_rezes
purees84721682pure_es
pyrene113210732pyrene_
pyres105523882pyr__es
pyrex175211212pyrex__
pyrexia19225462pyrexia
pyrexias20224992pyrexias
pyrexic21235352pyrexic
pyrites12812202pyrites
pyrones123113302pyrones
pyropes142210192pyropes
pyxes175911402py__xes
rexes124526952__rexes
agrees74915323agre_es
annexes1437203annexes
apexes1539133_apexes
apyrases1337243apyrases
arenes64928393_arenes
aretes64425353_aretes
bareges105212033bareges
biremes1138773biremes
boraxes163511633boraxes
bredes94818473_bredes
brees75632553_bre_es
breves115516423_breves
bruxes154811023_bruxes
byres104421383byr__es
byrnies12378573byrnies
cortexes1797613cortexes
cremes104517993_cremes
crepes105419343_crepes
cruxes154911563_cruxes
culexes1636993culexes
cyeses11510123cy_eses
cymenes1477413cymenes
cypreses1535143cypreses
desexes1537833desexes
dexes135224513__dexes
drees65628523_dre_es
exes116530813___exes
eyres84921773eyr__es
eyries93816813eyr_ies
fedexes1835473fedexes
flexes164512953_flexes
frees86131393_fre_es
freres94716173_freres
grebes93813613_grebes
grees65132473_gre_es
gyrases11368313gyrases
gyrates113610263gyrates
gyrene10227243gyrene_
gyres94820323gyr__es
heredes11313133heredes
hexes155123043__hexes
hirees95117293hire_es
hyraces1537913hyraces
ibexes15436163_ibexes
ilexes134510253_ilexes
indexes15339453indexes
kexes166216823__kexes
krewes1337923_krewes
kyries133411373kyr_ies
larees65323113lare_es
latexes1438313latexes
lexes127225263__lexes
lycees11428863lyce_es
lynxes1634323ly_nxes
lyres85019963lyr__es
myceles1435213myceles
myrtles1235733myrtles
oryxes1674523_oryxes
oyezes1835053oy_ezes
parades104121463parades
parches143720003parches
parents93418123parents
pareos87023773pare_os
parers85530743pare_rs
pares77164483par__es
paresis93315093paresis
pareus85420743pare_us
pareve114613013pareve_
parges94529543par_ges
paries84742513par_ies
parietes10714543parietes
parises94827183parises
parles86334403par_les
paroles95025883paroles
parries93925843parries
parses85534703par_ses
parties93230863parties
parures9512693parures
paxes144928423p__axes
payees114812903paye_es
pedes85327293p__edes
peeries93623023peeries
pees65257373p__e_es
peeves113814873p_eeves
pekes114623563p__ekes
peles75738083p__eles
penes75839223p__enes
perches143717953perches
perdues103511333perdues
pereons92815003pereons
peres76246643p__eres
perplexes2044683perplexes
perries93226603perries
perses85428063per_ses
perspexes2043843perspexes
perukes133210113perukes
peruses94018163peruses
pewees11311393pewe_es
phereses1348093phereses
phloxes1935513phloxes
phoebes1435813phoebes
phrases12711463phrases
phreaks1634543phreaks
phyleses1645183phyleses
pieces104217273p_ieces
pierces113411193pierces
pinenes93416673pinenes
pirates93020333pirates
pixes144323173p__ixes
plebes104313623p_lebes
plexus15377283p_lexus
poleaxes1767273poleaxes
porches143815673porches
pores75849033por__es
porgies103017003porgies
porkies133416493porkies
poxes145325723p__oxes
prases84429023p_rases
prates84633163p_rates
praxis154012253p_raxis
precess11310863p_recess
precis103416703p_recis
pree67044733p_re_e_
preed85128123p_re_ed
preen75925053p_re_en
preens85020113p_reens
prefer113813203p_refer
prefers123713333p_refers
prefixes20389233p_refixes
premed114617763p_remed
premeds12389593p_remeds
premen105017803p_remen
premies113823063p_remies
premixes193110083p_remixes
preops104911943p_reops
preps96220693p_re_ps
prese75228383p_rese_
preset84430983p_reset
presets94216423p_resets
press75425953p_re_ss
presses93523153p_resses
prests84021263p_rests
pretest9517633p_retest
prevues1239263p_revues
prex135722973p_rex__
prexy174611583p_rex_y
preyed125313203p_reyed
preyer114413733p_reyer
preyers124412363p_reyers
preys105717783p_re_ys
prices104524543p_rices
prides94324183p_rides
pries74339533p_r_ies
primes104225263p_rimes
prises84133173p_rises
prizes173819813p_rizes
probes104119453p_robes
proles84627203p_roles
proses84733473p_roses
proves114322253p_roves
proxies163014933p_roxies
prudes94215443p_rudes
prunes83419063p_runes
pryers115012243prye_rs
pugrees10218523pugre_es
puree74632843pure_e_
pureed95017813pure_ed
pureness101110183pureness
purfles122511843purfles
purges94421763pur_ges
purines94420763purines
purples112712833purples
purses84826373pur_ses
pursues94111373pursues
pyes95528993py___es
pygmies15205673pygmies
pyoses114314303py_oses
pyrans11411063pyr_ans
pyre94925553pyr__e_
pyretic143210783pyretic
pyrexial20234973pyrexial
pyrite11913313pyrite_
pyrogen1337353pyrogen
pyrogens1437293pyrogens
pyrolas1239863pyrolas
pyrone112714473pyrone_
pyrope132810533pyrope_
pyros105718293pyr__os
pyrosis12411653pyrosis
pyroxene2045083pyroxene
pyroxenes2145453pyroxenes
pyrroles1345453pyrroles
pyrrols1235403pyrrols
pyxides2034423pyxides
pyxies18338293py_xies
pyxis17458633py__xis
raxes124729393__raxes
redes65139133__redes
rees45364193__re_es
reges65628793__reges
sarees65329943sare_es
screes85023973scre_es
serenes73222903serenes
sexes126126223__sexes
silexes1438653silexes
sirees64624583sire_es
spiremes12397623spiremes
sprees85620643spre_es
styraxes1833493styraxes
styrenes11116623styrenes
sycees11409653syce_es
syrens94911993syre_ns
syrettes1136963syrettes
syrinxes18294423syrinxes
telexes1438353telexes
threes97117323thre_es
trees55835763_tre_es
tyees86019453ty_e_es
tyres84725233tyr__es
unsexes14248923unsexes
vertexes18105633vertexes
vexes155719123__vexes
vortexes18114053vortexes
xeroxes13246443xeroxes
xylenes1745093xylenes
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.390458182.1
2DLD Change Limit1340272525.72023431.3
3Display Results2522520.0932709.7
 (SQL Overall)1786912526.20328807.2
 
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.