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

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

56 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
colligates	13	4	771	(None)
colligate	12	4	829	1	colligate_
colligated	14	4	627	1	colligated
collimates	14	4	797	1	collimates
collates	10	30	1914	2	coll__ates
collimate	13	4	817	2	collimate_
collimated	15	5	608	2	collimated
collocates	14	4	812	2	collocates
obligates	12	20	785	2	_obligates
pollinates	12	4	730	2	pollinates
tollgates	10	4	605	2	toll_gates
califates	14	3	1011	3	c_alifates
castigates	13	4	755	3	castigates
celibates	13	5	863	3	c_elibates
cellmates	13	4	751	3	cell_mates
ciliates	10	4	1345	3	c_ili_ates
climates	12	3	1197	3	c__limates
coelomates	14	9	757	3	coelomates
cogitates	12	4	786	3	co_gitates
collages	11	35	1424	3	coll__ages
collate	9	29	1968	3	coll__ate_
collated	11	36	1506	3	coll__ated
colleagues	13	4	293	3	colleagues
colleges	11	24	1052	3	colleg__es
collegiate	13	4	507	3	collegiate_
collides	11	32	1447	3	colli__des
collieries	12	4	834	3	collieries
collies	9	43	2658	3	colli___es
colligating	15	4	571	3	colligating
colligation	14	5	745	3	colligation
colligations	15	5	684	3	colligations
colligative	17	5	435	3	colligative
collimator	14	9	484	3	collimator
collimators	15	9	478	3	collimators
collinses	11	3	828	3	colli_nses
collocate	13	4	867	3	collocate_
collocated	15	4	616	3	collocated
collogues	12	4	621	3	collog_ues
colocates	13	3	1285	3	co_locates
complicates	19	4	705	3	complicates
conjugates	20	4	469	3	conjugates
corrugates	13	4	518	3	corrugates
culminates	14	4	705	3	culminates
cultivates	15	4	651	3	cultivates
foliates	11	4	1275	3	fo_li_ates
ligates	8	23	1838	3	___ligates
obligate	11	19	830	3	_obligate_
obligated	13	18	690	3	_obligated
obligatos	12	19	506	3	_obligatos
palliates	11	3	1103	3	palli_ates
pollenates	12	4	674	3	pollenates
pollinate	11	4	771	3	pollinate_
pollinated	13	4	582	3	pollinated
profligates	17	5	370	3	profligates
tollgate	9	4	625	3	toll_gate_
vellicates	15	4	590	3	vellicates

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	140603	0.423	422437.4
2	DLD Change Limit	140603	56	5.826	24133.7
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	6.282	28444.9