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

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

75 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
vegetated	14	4	508	(None)
vegetate	12	4	667	1	vegetate_
vegetates	13	4	640	1	vegetates
hebetated	15	4	466	2	hebetated
regelated	11	3	972	2	regelated
revegetated	16	4	370	2	revegetated
venenated	13	4	590	2	venenated
venerated	13	3	995	2	venerated
acetated	11	20	1068	3	_acetated
agitated	10	3	841	3	_agitated
begetter	11	13	631	3	beget_ter
cogitated	13	4	632	3	cogitated
deaerated	11	3	1111	3	deaerated
defeated	13	28	1216	3	defe_ated
defecated	16	3	749	3	defecated
delectated	14	4	672	3	delectated
delegated	12	3	837	3	delegated
dentated	10	4	1170	3	de_ntated
digitated	12	8	696	3	digitated
egested	9	3	812	3	_ege_sted
elevated	12	11	829	3	_elevated
estated	8	37	1557	3	_e_stated
federated	14	3	842	3	federated
gelated	9	36	1563	3	__gelated
generated	11	3	1020	3	generated
gestated	10	29	1057	3	ge_stated
hebetate	13	4	705	3	hebetate_
hebetates	14	4	643	3	hebetates
hesitated	13	7	778	3	hesitated
legated	9	25	1398	3	leg__ated
levitated	13	4	641	3	levitated
meditated	13	4	808	3	meditated
negated	9	34	1323	3	neg__ated
negotiated	12	4	445	3	negotiated
overstated	14	11	944	3	overstated
penetrated	13	4	730	3	penetrated
regeared	10	3	943	3	rege_ared
regelate	9	3	1208	3	regelate_
regelates	10	3	1111	3	regelates
regrated	10	28	1633	3	reg_rated
regretted	11	3	723	3	regret_ted
regulated	11	3	1046	3	regulated
reheated	12	24	1500	3	rehe_ated
relegated	11	3	976	3	relegated
repeated	11	31	1744	3	repe_ated
reseated	9	32	2026	3	rese_ated
restated	9	31	2018	3	re_stated
revegetate	14	4	405	3	revegetate_
revegetates	15	5	393	3	revegetates
revetted	12	22	1094	3	revet_ted
rewetted	12	22	835	3	rewet_ted
segregated	13	4	452	3	segregated
tegulated	11	4	663	3	tegulated
vaginated	14	32	815	3	vaginated
vedette	11	6	600	3	vedet_te_
vedettes	12	6	594	3	vedet_tes
vegetable	15	4	568	3	vegetable
vegetables	16	4	270	3	vegetables
vegetably	18	4	395	3	vegetably
vegetal	11	5	630	3	vegeta__l
vegetally	16	4	421	3	vegetally
vegetant	12	4	696	3	vegeta_nt
vegetating	15	4	570	3	vegetating
vegetation	14	4	821	3	vegetation
vegetative	17	4	457	3	vegetative
vegete	10	3	948	3	vege__te_
vegetive	15	4	554	3	vegetive_
venenate	11	4	793	3	venenate_
venenates	12	4	758	3	venenates
venerate	11	3	1290	3	venerate_
venerates	12	3	1226	3	venerates
veritates	12	3	1097	3	veritates
vesicated	15	11	765	3	vesicated
vetted	10	43	1632	3	v__et_ted
vignetted	14	4	349	3	vignet_ted

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	148641	0.436	409841.7
2	DLD Change Limit	148641	75	6.203	23962.8
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	6.672	26782.2