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

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

43 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
collocations	16	4	640	(None)
collocation	15	4	717	1	collocation_
allocations	13	4	777	2	_allocations
collations	12	3	1285	2	coll__ations
collections	15	4	793	2	collec_tions
colligations	15	5	684	2	colligations
collimations	16	5	687	2	collimations
collocating	16	4	591	2	collocati_ng
collocational	17	5	305	2	collocational
colorations	13	9	1189	2	co_lorations
convocations	19	4	736	2	convocations
allocation	12	4	857	3	_allocation_
allocutions	13	5	398	3	_allocutions
bilocations	15	4	529	3	_bilocations
coeducations	17	4	587	3	coeducations
collaborations	18	7	274	3	collaborations
collation	11	3	1399	3	coll__ation_
collection	14	4	820	3	collec_tion_
colligation	14	5	745	3	colligation_
collimation	15	5	757	3	collimation_
collocates	14	4	812	3	collocat__es
collodions	13	4	459	3	collo__dions
colocating	15	4	862	3	co_locati_ng
coloration	12	9	1318	3	co_loration_
complications	21	4	743	3	complications
concoctions	14	4	826	3	concoc_tions
condonations	15	4	800	3	condonations
conglobations	18	5	394	3	conglobations
connotations	14	4	728	3	connotations
consociations	17	4	751	3	consociations
consolations	14	4	974	3	consolations
convocation	18	4	788	3	convocation_
coronations	13	4	1070	3	co_ronations
corotations	13	4	977	3	co_rotations
corporations	16	12	948	3	corporations
coruscations	16	4	525	3	coruscations
dislocations	15	13	698	3	dislocations
echolocations	20	5	262	3	echolocations
locations	11	25	1274	3	___locations
mislocations	16	14	565	3	mislocations
pollinations	14	4	723	3	pollinations
reallocations	15	5	380	3	reallocations
relocations	13	3	1114	3	_relocations

Search took 5 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	95024	0.376	475242.0
2	DLD Change Limit	95024	43	3.813	24921.1
3	Display Results	43	43	0.016	2687.5
	(SQL Overall)	178691	43	4.205	42494.9