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

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

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.

42 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
summital	12	4	470	(None)
somital	9	3	940	2	s_omital
submittal	13	4	388	2	submittal
summit	10	3	1154	2	summit__
summited	13	24	641	2	summited
summitry	15	4	332	2	summitry
summits	11	3	798	2	summit_s
committal	15	4	372	3	committal
cubital	11	3	710	3	cu_bital
gummata	12	4	461	3	gummata_
gummite	12	3	613	3	gummit_e
gummites	13	4	617	3	gummites
gunmetal	11	4	321	3	gunmetal
luminal	9	37	1100	3	lu_minal
pulpital	12	4	387	3	pulpital
ruminal	9	28	999	3	ru_minal
scimitar	12	4	359	3	scimitar
semimetal	13	4	575	3	semimetal
seminal	9	12	1341	3	s_eminal
simitar	9	3	673	3	s_imitar
spital	8	38	1387	3	s__pital
staminal	10	4	698	3	staminal
stomatal	10	4	583	3	stomatal
submit	10	3	1267	3	submit__
submits	11	3	975	3	submit_s
submittals	14	5	288	3	submittals
subtotal	10	4	626	3	subtotal
subviral	13	4	526	3	subviral
suffixal	21	4	285	3	suffixal
suicidal	11	4	607	3	suicidal
summa	9	47	1331	3	summ__a_
summae	10	39	1101	3	summ__ae
summas	10	43	1316	3	summ__as
summate	11	36	1166	3	summat_e
summated	13	29	883	3	summated
summates	12	26	1049	3	summates
summing	12	29	1238	3	summi_ng
summiteer	13	4	300	3	summiteer
summiting	14	4	579	3	summiting
sundial	8	5	986	3	sundi_al
surgical	11	4	625	3	surgical
survival	14	4	392	3	survival

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	42	7.266	20115.9
3	Display Results	42	42	0.013	3230.8
	(SQL Overall)	178691	42	7.699	23209.6