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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
subgeneration	16	5	260	(None)
subgenerations	17	5	251	1	subgenerations
cogeneration	15	4	644	3	_cogeneration
degeneration	14	4	728	3	_degeneration
generation	11	3	1242	3	___generation
regeneration	13	4	819	3	_regeneration
cogenerations	16	5	591	4	_cogenerations
degenerations	15	4	635	4	_degenerations
generations	12	3	1142	4	___generations
inteneration	12	4	862	4	_inteneration
regenerations	14	4	714	4	_regenerations
suberization	23	5	924	4	sub_erization
subgenera	12	4	337	4	subgenera____
subornation	13	4	649	4	suborn__ation
subsaturation	15	5	307	4	subsaturation
subvention	15	7	467	4	subven___tion
sustentation	12	5	502	4	susten_tation
veneration	13	4	1234	4	___veneration
aberration	12	6	720	5	_ab_e_rration
abnegation	13	4	541	5	_ab__negation
acceleration	16	5	481	5	_acceleration
asseveration	15	5	289	5	_asseveration
augmentation	15	5	439	5	augmen_tation
benefaction	18	5	282	5	__b_enefaction
botheration	16	5	465	5	__botheration
cogenerator	14	5	417	5	_cogenerat_or
concentration	17	5	801	5	concentration
confederation	19	9	525	5	confederation
crenelation	13	4	685	5	__crenelation
deaeration	11	3	1301	5	___deaeration
deceleration	15	4	717	5	_deceleration
degenerating	15	4	566	5	_degenerating
degenerative	17	5	496	5	_degenerative
denegation	12	4	941	5	___denegation
denervation	15	6	794	5	___denervation
enervation	13	6	947	5	____enervation
exaggeration	21	5	386	5	exag_geration
exenteration	19	5	529	5	__exenteration
exoneration	18	4	765	5	__exoneration
federation	14	4	957	5	___federation
fulguration	15	12	333	5	fulg__uration
generating	12	3	1038	5	___generating
generational	13	5	481	5	___generational
generative	14	5	856	5	___generative
generator	10	6	759	5	___generat_or
incineration	14	4	629	5	_incineration
intenerations	13	4	746	5	_intenerations
intergeneration	16	7	339	5	intergeneration
itineration	11	5	632	5	__itineration
liberation	12	6	999	5	lib___eration
numeration	12	13	796	5	nu___meration
obliteration	14	5	389	5	_obliteration
outgeneraling	15	6	128	5	outgeneraling
oxygenation	22	5	287	5	oxygen__ation
penetration	13	4	989	5	___penetration
perseveration	18	5	380	5	perseveration
regenerating	14	4	633	5	_regenerating
regenerative	16	5	530	5	_regenerative
regenerator	12	5	456	5	_regenerat_or
remuneration	14	4	693	5	_remuneration
ruggedization	25	5	205	5	ruggedization
scatteration	14	5	292	5	s_catteration
segmentation	15	5	600	5	segmen_tation
segregation	13	4	638	5	s_eg_regation
sensation	9	5	1058	5	s___en_sation
separation	12	5	1043	5	s___eparation
sequestration	22	13	313	5	sequestration
serration	9	4	1406	5	s___e_rration
stagnation	11	4	554	5	stag_n__ation
suballocation	17	6	162	5	suballocation
suberizations	24	6	877	5	sub_erizations
subinfeudation	20	12	146	5	subinfeudation
subirrigation	16	5	264	5	subirrigation
subjection	21	6	597	5	sub__je_ction
subjugation	21	4	370	5	sub__jugation
subjunction	22	5	333	5	subjun__ction
sublation	11	3	1101	5	sub____lation
sublimation	15	5	718	5	sub__limation
subluxation	20	4	382	5	sub__luxation
submersion	14	4	434	5	sub__mer_sion
submunition	15	6	311	5	submun__ition
subordination	16	5	417	5	subordination
suborganization	27	6	218	5	suborganization
subornations	14	4	614	5	suborn__ations
subpopulation	19	6	266	5	subpopulation
subreption	14	4	582	5	sub__re_ption
subrogation	14	4	600	5	sub__rogation
subsaturations	16	7	257	5	subsaturations
subsection	14	9	678	5	sub__se_ction
subsidization	25	5	398	5	subsidization
substantiation	16	7	315	5	substantiation
substation	12	4	899	5	sub___station
subtilization	24	5	663	5	subtilization
subtraction	15	4	562	5	sub___traction
subventions	16	7	484	5	subven___tions
subversion	15	4	450	5	sub__ver_sion
suggestion	12	5	301	5	su_g_ge_stion
sulfonation	14	4	426	5	sulfon__ation
superelevation	19	6	300	5	superelevation
supererogation	17	6	306	5	su_pererogation
superfetation	18	5	522	5	superfetation
supernation	13	4	1166	5	su_pe_rnation
superstation	14	16	862	5	su_perstation
supination	12	4	988	5	su_pin__ation
suppuration	15	4	589	5	su__ppuration
suspiration	13	4	654	5	su__spiration
sustentations	13	5	478	5	susten_tations
susurration	11	4	479	5	su__surration
turbogenerator	17	9	74	5	turbogenerat_or
ulceration	12	4	726	5	_u__lceration
venerations	14	4	1131	5	___venerations

Search took 9 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	124790	0.140	1276364.3
2	DLD Change Limit	124790	111	8.390	14873.7
3	Display Results	111	111	0.080	1387.5
	(SQL Overall)	178691	111	8.610	20753.9