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

Here are the results of your fuzzy-string dictionary search for “summational” 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.

85 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
summational	15	5	367	(None)
subnational	13	5	456	2	subnational
subrational	13	4	548	2	subrational
summation	13	4	780	2	summation__
summations	14	5	678	2	summation_s
mutational	12	4	650	3	mu_tational
nutational	10	4	703	3	nu_tational
salvational	14	4	371	3	salvational
sensational	11	4	637	3	sensational
situational	11	4	458	3	situational
stational	9	4	850	3	s__tational
suctional	11	4	768	3	su__ctional
summating	14	3	794	3	summati_n_g
agitational	12	4	482	4	agitational
aspirational	14	5	499	4	aspirational
avocational	16	4	517	4	avocational
binational	12	4	636	4	_binational
citational	12	6	644	4	_citational
educational	14	4	487	4	educational
emotional	11	4	666	4	__emotional
equational	19	4	560	4	_equational
foundational	16	5	284	4	foundational
functional	15	11	666	4	fu_nctional
gemmation	14	4	596	4	gemmation__
gemmations	15	4	499	4	gemmation_s
gestational	12	4	509	4	gestational
gradational	13	5	446	4	gradational
gyrational	14	4	474	4	_gyrational
ideational	11	4	648	4	_ideational
irrational	10	4	720	4	_irrational
junctional	19	10	534	4	ju_nctional
lactational	13	4	464	4	lactational
librational	13	4	454	4	librational
limitational	14	5	351	4	limitational
locational	12	4	659	4	_locational
matinal	9	3	1260	4	___mati_nal
matronal	10	4	811	4	___matronal
mediational	14	4	562	4	mediational
migrational	14	4	472	4	migrational
motional	10	5	867	4	___motional
narrational	11	4	543	4	narrational
national	8	3	1153	4	___national
negational	11	4	715	4	_negational
nonnational	11	10	782	4	nonnational
nonrational	11	10	909	4	nonrational
notational	10	4	810	4	_notational
nutritional	11	5	476	4	nutritional
ommatidial	15	5	165	4	_ommatidial
operational	13	4	749	4	operational
ovational	12	4	685	4	__ovational
probational	15	4	708	4	probational
promotional	15	5	563	4	promotional
radiational	12	4	593	4	radiational
rational	8	4	1254	4	___rational
relational	10	4	770	4	_relational
rotational	10	4	807	4	_rotational
salutational	12	5	332	4	salutational
sectional	11	4	941	4	s__ectional
semitonal	11	5	704	4	s_emit_onal
speciational	16	5	431	4	speciational
squamation	21	5	353	4	squamation__
squamations	22	7	274	4	squamation_s
sublation	11	3	1101	4	sublation__
sublations	12	4	1011	4	sublation_s
submarginal	16	5	215	4	submarginal
submaximal	23	5	196	4	submaxi_mal
subregional	14	5	236	4	subregional
sudation	9	3	1080	4	su_dation__
sudations	10	3	990	4	su_dation_s
sulcation	11	7	1073	4	sulcation__
sulcations	12	8	958	4	sulcation_s
sulfation	12	8	878	4	sulfation__
sulfations	13	10	781	4	sulfation_s
summative	16	4	620	4	summati__ve
summital	12	4	470	4	summ__i_tal
summiting	14	4	578	4	summiti_n_g
supernational	15	5	561	4	supernational
supranational	15	5	298	4	supranational
suprarational	15	5	291	4	suprarational
tuitional	9	4	604	4	tu__itional
unemotional	13	5	348	4	unemotional
valuational	14	4	404	4	valuational
variational	14	4	477	4	variational
vibrational	16	4	435	4	vibrational
vocational	15	4	695	4	_vocational

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.170	1051123.5
2	DLD Change Limit	148819	85	9.063	16420.5
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	9.279	19257.6