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

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

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.

66 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
spontaneities	15	6	227	(None)
spontaneity	16	5	149	3	spontaneit__y
continuities	14	5	624	4	_continuities
frontalities	15	5	557	4	fronta_lities
instantaneities	15	7	116	4	instantaneities
simultaneities	16	6	81	4	simultaneities
spontaneous	13	6	283	4	spontane__ous
atonalities	11	4	840	5	aton_a_lities
concavities	18	4	612	5	_conca_vities
concinnities	16	5	441	5	_concinnities
contiguities	15	5	444	5	_contiguities
contrarieties	15	6	381	5	_contrarieties
dentalities	12	4	954	5	_denta_lities
diaphaneities	19	6	130	5	diaphaneities
discontinuities	18	7	218	5	discontinuities
fontanelles	14	5	216	5	_fontane_lles
idoneities	11	4	499	5	ido___neities
importunities	17	6	272	5	importun_ities
inanities	9	3	1244	5	__in_an_ities
insanities	10	4	942	5	__insan_ities
intensities	11	10	891	5	__intensities
longanimities	16	6	237	5	_longanimities
mentalities	13	4	1002	5	_menta_lities
mortalities	13	4	842	5	_morta_lities
mundanities	14	4	441	5	_mundan_ities
nonentities	11	5	826	5	_non_entities
nonparities	13	4	858	5	_nonpa_rities
obtundities	14	5	226	5	__obtundities
opportunities	17	7	185	5	opportun_ities
orotundities	13	5	253	5	oro_tundities
pantalettes	13	5	326	5	_pantale_ttes
penalities	12	13	1347	5	_pen_a_lities
pentameries	15	5	475	5	_pentame_ries
pentapeptides	17	6	150	5	_pentapeptides
pentlandites	15	5	167	5	_pentlandit_es
polarities	12	12	1177	5	_po_la_rities
portabilities	17	4	1021	5	_portabilities
posterities	13	6	903	5	_post_erities
potabilities	16	4	1131	5	_po_tabilities
profanities	16	7	625	5	_profan_ities
rotundities	12	5	376	5	_ro_tundities
sanities	8	12	1977	5	s____an_ities
socialities	13	4	929	5	s_ocia_lities
sodalities	11	13	870	5	s_o_da_lities
solemnities	13	5	436	5	s_olemn_ities
sonnetizes	19	4	535	5	s_on__netizes
sonorities	10	9	1065	5	s_on__orities
sovranties	13	4	384	5	s_ovran__ties
sparsities	12	4	732	5	sp___arsities
spasticities	16	5	462	5	spast_icities
spatialities	14	6	556	5	sp_atialities
specialities	16	5	679	5	specia_lities
spinneries	12	4	573	5	spin__ne_ries
spinosities	13	4	494	5	spin__osities
spiralities	13	4	801	5	sp_ira_lities
spondylitis	17	5	146	5	spon_dyliti_s
spondylitises	19	6	122	5	spon_dylitises
sponginesses	15	4	477	5	spongine_sses
spontaneously	18	6	237	5	spontaneously
spontaneousness	17	7	171	5	spontaneousness
sportinesses	14	4	787	5	sportine_sses
spottinesses	14	4	568	5	spottine_sses
stannites	9	4	702	5	s___tannit_es
strontianites	13	6	164	5	strontian_it_es
tonalities	10	17	1173	5	_ton_a_lities
totalities	10	12	1078	5	_to_ta_lities

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.403	443402.0
2	DLD Change Limit	124790	66	8.410	14838.3
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.843	20207.1