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

Here are the results of your fuzzy-string dictionary search for “designate” 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
designate	11	4	711	(None)
designated	13	4	593	1	designated
designates	12	4	636	1	designates
denigrate	11	6	869	2	denigrate
desiccate	14	4	592	2	desiccate
designative	16	5	433	2	designative
designator	12	4	471	2	designator
designee	10	8	775	2	design_ee
resinate	8	3	1677	2	resi_nate
assignat	9	4	568	3	assignat_
assignats	10	4	400	3	assignats
deaminate	12	4	1017	3	deaminate
deciduate	13	4	506	3	deciduate
decimate	13	4	1112	3	deci_mate
dedicate	12	3	1280	3	dedi_cate
definite	12	3	933	3	defi_nite
delegate	10	4	1046	3	deleg_ate
delicate	11	3	1549	3	deli_cate
delineate	10	4	779	3	delineate
denigrated	13	6	697	3	denigrated
denigrates	12	9	811	3	denigrates
denitrate	10	8	1053	3	denitrate
depilate	11	3	1170	3	depi_late
derivate	12	3	1120	3	deri_vate
derogate	10	3	1135	3	derog_ate
desalinate	11	4	667	3	desalinate
desecrate	12	4	908	3	desecrate
desiccated	16	4	499	3	desiccated
desiccates	15	4	538	3	desiccates
desiderate	12	4	627	3	desiderate
design	8	40	893	3	design___
designating	14	4	607	3	designating
designation	13	4	748	3	designation
designators	13	4	430	3	designators
designatory	16	5	338	3	designatory
designed	11	3	694	3	design_ed
designees	11	4	500	3	designees
designer	10	3	654	3	design_er
designers	11	3	600	3	designers
designing	12	3	662	3	designing
designs	9	32	831	3	design__s
desolate	9	4	1199	3	des_olate
desperate	12	4	1084	3	desperate
despumate	14	4	352	3	despumate
detonate	9	3	1119	3	de_tonate
deviate	11	3	1271	3	devi__ate
dominate	11	3	1285	3	domi_nate
emigrate	11	4	960	3	_emigrate
festinate	12	4	947	3	festinate
gelignite	11	4	399	3	gelignite
geminate	11	4	1181	3	gemi_nate
hesitate	11	6	997	3	hesi_tate
levigate	12	4	662	3	levig_ate
pepsinate	13	4	663	3	pepsi_nate
predesignate	16	5	284	3	~~pre~~designate
reignite	9	4	723	3	re_ignite
remigrate	12	4	922	3	remigrate
resinated	10	4	1328	3	resi_nated
resinates	9	3	1476	3	resi_nates
resituate	9	4	861	3	resituate
resonate	8	5	1351	3	res_onate
sigmate	10	7	1014	3	__sigmate
signage	9	3	777	3	__signage
undesignated	15	5	283	3	undesignated
vesicate	13	12	1005	3	vesi_cate

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	148641	0.436	409841.7
2	DLD Change Limit	148641	65	7.500	19818.8
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	7.966	22431.7