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

157 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
pyrogen133735(None) 
pirogen1038261pirogen
pyrogens1437291pyrogens
acrogen1038202acrogen
cryogen1345042cryogen
hydrogen1646282hydrogen
kerogen1236092kerogen
lysogen1144362lysogen
progeny1389462p_rogeny
progun968782p_rogun
proven114314772p_roven
pyrogenic1748922pyrogenic
pyrone112714472pyrone_
pyrones123113302pyrones
pyrope132810532pyrope_
pyropes142210192pyropes
pyroxene2045082pyroxene
zymogen2243692zymogen
acrogens1147243acrogens
aerogel836523aerogel
amylogen1444263amylogen
androgen1046313androgen
biogen9310253_biogen
brogan9311043_brogan
broken124011523_broken
cryogens1444723cryogens
cryogeny1743553cryogeny
cyanogen14104513cyanogen
cymogene1644723cymogene
cytogeny1744083cytogeny
endogen938613endogen
epirogeny1583583epirogeny
estrogen946573estrogen
exogen1436513_exogen
frogmen1335893_frogmen
frozen18408443_frozen
glycogen1543063glycogen
gyron95314623gyro__n
gyrose105310253gyrose_
halogen1138393halogen
hyalogen1544053hyalogen
hydrogel1644753hydrogel
hydrogens1746063hydrogens
hypogea1645473hypogea
hypogean1744993hypogean
hypogene1746943hypogene
ionogen837123ionogen
kerogens1345763kerogens
kronen10348913_kronen
lysogens1244523lysogens
lysogeny1543393lysogeny
mitogen1036963mitogen
morgen9312203mor_gen
nitrogen945823nitrogen
orogeny11107023_orogeny
pangen94115913p_angen
paragon10311023paragon
parge85831853par_ge_
parged104922043par_ged
parges94529543par_ges
parget94529393par_get
parole84425253parole_
paroled104217633paroled
parolee94119643parolee
paroles95025883paroles
pathogen1446463pathogen
perigean1146353perigean
perigee101113393perigee
perigon1039853perigon
petrogeny1544973petrogeny
phylogeny2143753phylogeny
phytogeny2143873phytogeny
pirog83913673pirog__
piroghi13303843piroghi
pirogi9299013pirog_i
pirogies1139423pirogies
pirogue1045413pirogue
pirogues1135473pirogues
pocosen1146833pocosen
pogey116017893p__ogey
porose84818743porose_
preen75925053p_r_een
premen105017803p_remen
probe94320813p_robe_
probed114114823p_robed
prober104516073p_rober
probes104119453p_robes
proem94818273p_ro_em
prog75729003p_rog__
progged12409803p_rogged
progger11319373p_rogger
progs86624153p_rog_s
projet15315183p_rojet
prolan8414693p_rolan
prole74527793p_role_
proleg94612113p_roleg
proles84627203p_roles
prone75332623p_rone_
pronged113912393p_ronged
propel103714063p_ropel
propend123311273p_ropend
propene112716043p_ropene
proper104319953p_roper
propmen1338763p_ropmen
prose75835123p_rose_
prosed94921093p_rosed
proser84223463p_roser
proses84733473p_roses
protea82214763p_rotea
protean92412193p_rotean
protei82615313p_rotei
protein92414733p_rotein
protend104012793p_rotend
proton84318893p_roton
prove104823193p_rove_
proved125016033p_roved
prover113819723p_rover
proves114322253p_roves
prower114218123p_rower
purge85324603pur_ge_
purged104918263pur_ged
purger94717233pur_ger
purges94421763pur_ges
pylon103614003pylo__n
pyogenic1648583py_ogenic
pyoses114314303py_oses
pyran10514473pyr__an
pyre94925553pyr__e_
pyrene113210733pyr__ene
pyrenes123511223pyrenes
pyres105523883pyr__es
pyrex175211213pyr__ex
pyrexes19305843pyrexes
pyrite11913313pyrite_
pyrites12812203pyrites
pyro96019393pyro___
pyrola1139003pyro_la
pyrolas1239863pyrolas
pyronine1349513pyronine
pyros105718293pyro__s
pyrosis12411653pyrosis
pyroxenes2145453pyroxenes
pyroxenic2345453pyroxenic
pyrrole1246033pyrrole_
pyrroles1345453pyrroles
roger64521413__roger
rouen54920903__rouen
roven85521973__roven
rowen84921153__rowen
syren85216743syr__en
trogon73611753_trogon
unroven10238143unroven
yeomen1138183_yeomen
yogee9518063_y_ogee
yogin98317743_y_ogin
zymogene2343743zymogene
zymogens2343673zymogens

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.406440125.6
2DLD Change Limit1340271577.06318975.9
3Display Results1571570.0463413.0
 (SQL Overall)1786911577.51523777.9
 
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.