Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pathogenies” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

70 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
pathogenies	17	5	506	(None)
pathogenes	16	4	595	1	pathogen_es
pathogene	15	4	519	2	pathogen_e_
pathogeneses	18	5	458	2	pathogeneses
pathogenic	18	6	621	2	pathogeni_c
pathogens	15	4	571	2	pathogen__s
petrogenies	14	6	666	2	petrogenies
autogenies	11	4	748	3	_autogenies
cytogenies	16	4	644	3	cyt_ogenies
mahoganies	16	4	393	3	ma_hoganies
ontogenies	11	4	707	3	ont_ogenies
pathogen	14	4	646	3	pathogen___
pathogenesis	18	5	497	3	pathogenesis
pathogeny	18	4	374	3	pathogen__y
pathologies	17	4	873	3	pathologies
phylogenies	20	5	517	3	phylogenies
phytogenies	20	5	578	3	phytogenies
progenies	12	3	1412	3	p__rogenies
asthenies	12	7	806	4	asth__enies
atonies	7	53	2095	4	_at_o__nies
biogenies	12	4	851	4	__biogenies
cryogenies	16	4	512	4	_cryogenies
endogenies	12	4	706	4	_endogenies
epeirogenies	15	5	246	4	epeirogenies
epirogenies	14	6	437	4	epirogenies
gasogenes	11	4	572	4	ga_sogen_es
gazogenes	20	4	369	4	ga_zogen_es
heterogenies	16	9	556	4	heterogenies
homogenies	16	11	858	4	_homogenies
iatrogenic	13	4	516	4	iatrogeni_c
isogenies	10	19	881	4	__isogenies
lysogenies	14	57	845	4	_lysogenies
monogenies	13	4	879	4	_monogenies
oogenies	9	3	1158	4	___oogenies
orogenies	10	4	1053	4	__orogenies
orthoepies	15	5	374	4	ortho_epies
orthogeneses	16	6	506	4	orthogeneses
pachytenes	20	5	237	4	pachyten_es
paedogeneses	16	11	435	4	paedogeneses
paedogenic	16	5	524	4	paedogeni_c
pahoehoes	17	5	225	4	pa_ho_ehoes
paleogene	12	4	523	4	paleogen_e_
pangenes	11	26	1282	4	pa__ngen_es
patchoulies	18	5	186	4	patcho_ulies
patencies	13	4	917	4	pat___encies
pathogenetic	20	5	453	4	pathogenetic
pathogenicities	23	7	231	4	pathogen~~icit~~ies
pathogenicity	24	6	268	4	pathogenicity
pathoses	13	4	1277	4	patho___ses
patiences	13	6	743	4	pat__iences
patisseries	13	5	290	4	patisseries
patooties	11	4	718	4	pat_o_oties
patrilinies	13	5	416	4	patrilinies
patrimonies	15	5	369	4	patrimonies
patronesses	13	4	647	4	patronesses
patronise	11	9	844	4	patro__nise
patronises	12	9	843	4	patro__nises
patronizes	21	8	739	4	patro__nizes
petrogeneses	15	6	544	4	petrogeneses
philogynies	20	5	325	4	philogynies
phoenixes	21	4	339	4	p__ho_enixes
phonies	12	37	1751	4	p__ho__nies
phoresies	14	4	799	4	p__horesies
phosgenes	15	4	476	4	p__hosgen_es
photogenes	16	4	888	4	photogen_es
pythonesses	19	4	268	4	pythonesses
sapogenins	13	5	322	4	sa_pogenins
theogonies	14	4	503	4	__theogonies
xenogenies	18	4	477	4	_xenogenies
zoogenies	19	4	683	4	__zoogenies

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	148819	0.156	1145455.1
2	DLD Change Limit	148819	70	9.390	15848.7
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	9.576	18660.3