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

Here are the results of your fuzzy-string dictionary search for “content” with Change Limit: [1] [2] [3]

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.

42 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
content	9	43	2615	(None)
concent	11	44	2251	1	concent
consent	9	37	2311	1	consent
contend	10	35	1189	1	contend
contents	10	40	1821	1	contents
contest	9	35	2323	1	contest
context	16	39	1343	1	context
convent	12	39	1941	1	convent
candent	10	4	1736	2	candent
coagent	10	3	1398	2	coagent
cogent	9	3	2100	2	co_gent
coinvent	13	4	818	2	coinvent
comment	13	103	1770	2	comment
conceit	11	32	1807	2	conceit
concents	12	25	1660	2	concents
concept	13	33	1444	2	concept
concert	11	33	2522	2	concert
confect	14	36	1427	2	confect
congest	10	46	1877	2	congest
connect	11	35	1574	2	connect
consents	10	27	1589	2	consents
constant	10	5	1559	2	constant
contact	11	440	2068	2	contact
conte	7	66	3320	2	conte__
contemn	11	3	780	2	contemn
contemns	12	3	740	2	contemns
contempt	14	4	747	2	contempt
contends	11	28	1057	2	contends
contented	12	3	1304	2	contented
contes	8	44	3291	2	conte_s
contests	10	34	1338	2	contests
contexts	17	37	865	2	contexts
continent	11	4	1563	2	continent
contort	9	14	2234	2	contort
convect	14	31	1448	2	convect
convene	12	33	1432	2	convene
convents	13	26	1460	2	convents
convert	12	37	2147	2	convert
intent	6	31	2277	2	_intent
ponent	8	28	2159	2	pon_ent
portent	9	36	1964	2	portent
potent	8	42	2335	2	po_tent

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	42	3.343	32207.9
3	Display Results	42	42	0.030	1400.0
	(SQL Overall)	178691	42	3.749	47663.6