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

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

65 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
envision	11	4	595	(None)
envisions	12	4	561	1	envisions
division	12	6	668	2	division
elision	7	23	1110	2	e_lision
environ	10	4	476	2	envi_ron
envisioned	14	5	293	2	envisioned
evasion	10	3	675	2	e_vasion
excision	17	4	627	2	excision
incision	10	4	760	2	incision
invasion	11	11	547	2	invasion
revision	11	3	871	2	revision
vision	9	3	1131	2	__vision
benison	9	3	712	3	ben_is_on
concision	13	4	849	3	concision
decision	11	4	852	3	decision
dentition	10	4	963	3	dentition
derision	9	3	907	3	derision
divisions	13	9	628	3	divisions
eclosion	10	4	689	3	eclosion
edition	8	3	1085	3	e_dition
effusion	14	4	460	3	effusion
elisions	8	22	1042	3	e_lisions
elusion	7	23	1095	3	e_lusion
emersion	10	4	773	3	emersion
emission	10	4	767	3	emission
emulsion	10	4	592	3	emulsion
enation	7	34	1923	3	en_ation
ensign	7	3	752	3	en__sign
enviro	9	3	630	3	envi_ro_
environs	11	4	467	3	envi_rons
enviros	10	3	491	3	envi_ros
envisage	12	4	265	3	envisage
envisioning	15	5	284	3	envisioning
erasion	7	3	1196	3	e_rasion
erosion	7	3	1111	3	e_rosion
evasions	11	3	654	3	e_vasions
eversion	11	3	871	3	eversion
eviction	13	22	868	3	e_viction
evulsion	11	5	506	3	evulsion
excisions	18	4	638	3	excisions
incisions	11	4	735	3	incisions
infixion	18	4	368	3	infixion
infusion	11	4	652	3	infusion
inhesion	11	11	637	3	inhesion
invasions	12	11	541	3	invasions
inversion	12	4	721	3	inversion
lenition	8	3	1008	3	len_ition
nasion	6	39	1408	3	_n_asion
pavilion	13	4	490	3	pavilion
pension	9	4	1220	3	pen__sion
pervasion	14	4	607	3	pervasion
prevision	14	4	800	3	prevision
provision	14	4	763	3	provision
recision	10	3	1027	3	recision
redivision	14	5	387	3	redivision
reinvasion	13	4	301	3	reinvasion
rendition	10	5	893	3	rendition
revisions	12	3	859	3	revisions
television	13	5	246	3	television
tension	7	3	1180	3	ten__sion
unison	6	4	903	3	un_is_on
vendition	13	4	569	3	vendition
venison	10	3	644	3	ven_is_on
virion	9	3	1068	3	__virion
visions	10	3	1102	3	__visions

Search took 7 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.406	440125.6
2	DLD Change Limit	146162	65	6.516	22431.2
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	6.938	25755.4