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

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

67 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
collections	15	4	793	(None)
collection	14	4	820	1	collection_
bolections	14	13	729	2	bo_lections
collations	12	3	1285	2	coll_ations
collecting	15	4	828	2	collecti_ng
collectives	18	4	603	2	collectives
collectors	14	4	659	2	collect_ors
collocations	16	4	640	2	collocations
confections	18	4	1139	2	confections
connections	15	4	1070	2	connections
convections	18	4	1149	2	convections
corrections	15	4	886	2	corrections
recollections	17	5	472	2	recollections
bilections	14	13	650	3	_bilections
bolection	13	11	767	3	bo_lection_
coactions	13	4	974	3	co__actions
coalitions	12	4	792	3	coal_itions
codirections	17	4	469	3	codirections
cofunctions	18	4	501	3	cofunctions
collation	11	3	1399	3	coll_ation_
collectible	17	10	451	3	collectible
collectibles	18	8	361	3	collectibles
collective	17	4	712	3	collecti_ve
collectivise	19	5	390	3	collectivise
collectivism	21	6	374	3	collectivism
collectivist	19	6	462	3	collectivist
collector	13	4	639	3	collect_o_r
collects	12	27	978	3	collect___s
collegians	13	4	442	3	colle_gians
colleting	12	3	1105	3	colle_ti_ng
colligations	15	5	683	3	colligations
collimations	16	5	687	3	collimations
collisions	12	4	632	3	coll_isions
collocation	15	4	717	3	collocation_
collodions	13	4	459	3	coll_odions
collusions	12	4	597	3	coll_usions
colorations	13	9	1189	3	colorations
compactions	19	4	653	3	compactions
completions	17	4	690	3	comple_tions
conceptions	17	4	1059	3	conceptions
concoctions	14	4	825	3	concoctions
conductions	16	4	966	3	conductions
confection	17	4	1118	3	confection_
conflictions	19	4	522	3	conflictions
congestions	14	4	931	3	congestions
connection	14	4	1053	3	connection_
consecutions	16	4	704	3	consecutions
contentions	13	4	1209	3	contentions
convection	17	4	1112	3	convection_
conventions	16	4	1053	3	conventions
convictions	18	4	804	3	convictions
correction	14	4	881	3	correction_
deflections	17	18	732	3	deflections
elections	11	24	1497	3	__elections
flections	14	23	921	3	__flections
inflections	16	4	698	3	inflections
lections	10	24	1384	3	___lections
nonelections	14	5	638	3	nonelections
objections	21	4	563	3	_objections
olfactions	15	6	387	3	_olfactions
pollutions	12	4	543	3	poll_utions
prelections	15	12	1046	3	prelections
recollection	16	5	485	3	recollection_
reelections	13	16	794	3	reelections
reflections	16	17	855	3	reflections
selections	12	3	1087	3	_selections
subcollections	20	6	172	3	~~sub~~collections

Search took 6 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	121633	0.140	1276364.3
2	DLD Change Limit	121633	67	5.750	21153.6
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	5.936	30102.9