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

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

74 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
televisions	14	5	234	(None)
television	13	5	246	1	television_
televising	14	4	411	2	televisi_ng
televisors	13	5	224	2	televis_ors
elevations	13	3	863	3	_elevations
elisions	8	22	1042	3	_el__isions
envisions	12	4	561	3	_e_nvisions
previsions	15	4	774	3	_previsions
redivisions	15	5	380	3	redivisions
revisions	12	3	860	3	__revisions
televises	12	4	635	3	televis__es
televisor	12	5	232	3	televis_o_r
alleviations	15	5	451	4	alleviations
collisions	12	4	632	4	col_lisions
decisions	12	4	838	4	__decisions
declensions	14	4	333	4	decle_nsions
delegations	13	4	803	4	delegations
deletions	10	26	1093	4	dele__tions
delusions	10	3	705	4	del__usions
derisions	10	3	884	4	__derisions
divisions	13	9	628	4	__divisions
elections	11	24	1497	4	_ele_ctions
eledoisins	11	5	206	4	_eledoisi_ns
elegising	11	4	542	4	_elegisi_ng
elevation	12	3	923	4	_elevation_
elevons	10	6	757	4	_elev___ons
elision	7	23	1110	4	_el__ision_
elusions	8	26	1008	4	_el__usions
eluviations	14	11	579	4	_eluviations
emersions	11	4	728	4	_eme_rsions
envision	11	4	595	4	_e_nvision_
evasions	11	3	654	4	___evasions
eversions	12	3	836	4	_eve_rsions
excisions	18	4	638	4	_e_xcisions
indecisions	14	4	411	4	indecisions
lenitions	9	3	947	4	__lenitions
lesions	7	38	1387	4	__le__sions
lewissons	12	4	174	4	__lewissons
pervasions	15	4	566	4	pe_rvasions
perversions	16	4	541	4	perversions
precisions	14	4	937	4	_precisions
pretelevision	18	7	76	4	~~pre~~television_
prevision	14	4	801	4	_prevision_
provisions	15	4	721	4	_provisions
recensions	12	4	848	4	rece_nsions
recessions	12	4	893	4	rece_ssions
recisions	11	3	991	4	__recisions
redivision	14	5	387	4	redivision_
reeditions	11	4	765	4	re_editions
reemissions	13	4	415	4	re_emissions
reinvasions	14	4	279	4	reinvasions
relegations	12	4	897	4	relegations
religions	10	8	660	4	rel__igions
repetitions	13	7	802	4	repetitions
reprovisions	17	5	377	4	reprovisions
reversions	13	4	757	4	reve_rsions
revision	11	3	872	4	__revision_
secessions	12	4	646	4	sece_ssions
selections	12	3	1087	4	sele_ctions
supervisions	17	5	503	4	supervisions
teleshops	14	4	478	4	tele__shops
telesis	7	3	1079	4	tele__si__s
telethons	12	4	602	4	tele__thons
televiewers	17	5	204	4	televiewers
televiewing	18	5	191	4	televiewing
televiews	15	4	274	4	telev__iews
televise	11	4	606	4	televis___e
televised	13	4	424	4	televis__ed
televisual	13	5	116	4	televis_ual
tellurions	10	10	380	4	tel_lurions
telsons	7	3	922	4	tel___s_ons
tensions	8	3	1022	4	t__e_nsions
tolerations	11	5	813	4	tolerations
visions	10	3	1102	4	____visions

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.423	422437.4
2	DLD Change Limit	148819	74	9.390	15848.7
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	9.846	18148.6