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

127 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
pyrogens143729(None) 
pyrogen1337351pyrogen_
acrogens1147242acrogens
cryogens1444722cryogens
hydrogens1746062hydrogens
kerogens1345762kerogens
lysogens1244522lysogens
pirogen1038262pirogen_
progeny1389462p_rogeny
pyrogenic1748922pyrogenic
pyrones123113302pyrone_s
pyropes142210192pyrope_s
pyroxene2045082pyroxene
pyroxenes2145452pyroxenes
zymogens2343672zymogens
acrogen1038203acrogen_
aerogels945593aerogels
amylogens1543603amylogens
androgens1145253androgens
biogens1038963_biogens
brogans1049663_brogans
cryogen1345043cryogen_
cryogeny1743553cryogeny
cyanogens1594043cyanogens
cymogene1644723cymogene
cymogenes1745813cymogenes
cytogeny1744083cytogeny
endogens1047953endogens
epirogeny1583583epirogeny
estrogens1045703estrogens
exogens1536883_exogens
glycogens1643123glycogens
gyrons105511223gyro__ns
halogens1237363halogens
hyalogens1643773hyalogens
hydrogels1764333hydrogels
hydrogen1646283hydrogen_
hypogene1746943hypogene
ionogens956823ionogens
kerogen1236093kerogen_
lysogen1144363lysogen_
lysogeny1543393lysogeny
mitogens1146973mitogens
morgens10310463mor_gens
nitrogens1045353nitrogens
orogeny11107023_orogeny
pangens103112073p_angens
paragons11311513paragons
parges94529543par_ge_s
pargets105215193par_gets
parolees104313993parolees
paroles95025893parole_s
pathogens1545713pathogens
perigees1189503perigees
perigons11310083perigons
petrogeny1544973petrogeny
phylogeny2143753phylogeny
phytogeny2143873phytogeny
pirogies1139423pirogies
pirogues1135473pirogues
pocosens1255263pocosens
pogeys124110353p__ogeys
preens85020113p_r_eens
probers113514583p_robers
probes104119453p_robe_s
process11310403p_rocess
proems104711163p_ro_ems
profess1237713p_rofess
progenies12314123p_rogenies
proggers12258163p_roggers
progress1137023p_rogress
progs86624153p_rog__s
progun968783p_rogun_
projets1639163p_rojets
prolans9314273p_rolans
prolegs10379993p_rolegs
proles84627203p_role_s
propels113412843p_ropels
propend123311273p_ropend
propends13249173p_ropends
propene112716043p_ropene
propenes122816513p_ropenes
propense122410103p_ropense
propers113619033p_ropers
prosers94219643p_rosers
proses84733473p_rose_s
proteans102811543p_roteans
proteas92015123p_roteas
proteins102114283p_roteins
protend104012793p_rotend
protends113010353p_rotends
proteus92511593p_roteus
protons93118003p_rotons
proven114314773p_roven_
provers123817793p_rovers
proves114322253p_rove_s
prowess1237903p_rowess
purgers104714003pur_gers
purges94421763pur_ge_s
pylons113011243pylo__ns
pyogenic1648583py_ogenic
pyoses114314303py_ose_s
pyrans11411063pyr__ans
pyrene113210733pyr__ene
pyrenes123511223pyr__enes
pyres105523883pyr__e_s
pyrexes19305843pyrexe_s
pyrites12812203pyrite_s
pyrolas1239863pyro_las
pyrone112714473pyro__ne
pyronine1349513pyronine
pyronines1458323pyronines
pyrope132810533pyrope__
pyros105718293pyro___s
pyrosis12411653pyro_sis
pyroxenic2345453pyroxenic
pyrroles1345453pyrrole_s
rogers74517913__rogers
rouens64814443__rouens
rowens94515303__rowens
syrens94911993syr__ens
trogons83410723_trogons
yogees10510633_y_ogees
yogins105114103_y_ogins
zymogen2243693zymogen_
zymogene2343743zymogene
zymogenes2444453zymogenes

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621277.56319325.9
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.06222164.6
 
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.