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

Here are the results of your fuzzy-string dictionary search for “covalent” 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
covalent	13	4	922	(None)
bivalent	13	4	612	2	bivalent
coagent	10	3	1397	2	co_agent
coparent	12	4	1225	2	coparent
covalence	16	4	584	2	covalence
covalency	19	4	383	2	covalency
covalently	18	10	360	2	covalently
divalent	12	4	778	2	divalent
bivalents	14	4	412	3	bivalents
cadent	9	41	2035	3	c__adent
cavalero	13	4	476	3	cavalero
cavaletti	14	4	315	3	cavaletti
chalet	11	38	2599	3	c_hale_t
chevalet	16	5	812	3	chevale_t
cholent	12	3	1325	3	c_holent
coagents	11	3	844	3	co_agents
coaled	9	50	2270	3	co_ale_d
coaler	8	41	2170	3	co_ale_r
coalers	9	44	1933	3	co_alers
coaliest	10	3	1622	3	co_aliest
coaling	10	37	2282	3	co_aling
coalpit	11	4	850	3	co_alpit
cobalt	10	3	1739	3	cobal__t
cogent	9	3	2100	3	co__gent
coherent	13	4	1247	3	coherent
coinvent	13	4	818	3	coinvent
collect	11	33	1459	3	co_llect
collet	8	40	3036	3	co_lle_t
comment	13	103	1770	3	co_mment
compleat	14	7	1015	3	compleat
complect	16	5	901	3	complect
concent	11	44	2251	3	co_ncent
condolent	12	4	983	3	condolent
confluent	14	4	690	3	confluent
consent	9	37	2311	3	co_nsent
content	9	43	2615	3	co_ntent
convent	12	39	1941	3	co_nvent
coolant	9	3	1646	3	co_olant
coolest	9	3	1864	3	co_olest
coparents	13	4	797	3	coparents
copayment	18	4	589	3	copayment
copyleft	18	4	398	3	copyleft
corpulent	13	4	684	3	corpulent
corslet	9	3	1806	3	corsle_t
cotangent	12	4	683	3	cotangent
couplet	11	47	1794	3	couple_t
covalences	17	4	583	3	covalences
covariant	14	4	786	3	covariant
coven	10	69	2504	3	cov__en_
covenant	13	4	969	3	covenant
covens	11	49	1926	3	cov__ens
coverlet	13	4	1301	3	coverle_t
covert	11	49	2550	3	cov__ert
covet	10	56	3894	3	cov__e_t
exhalent	18	6	557	3	exhalent
loyalest	11	14	672	3	loyalest
monovalent	15	5	422	3	monovalent
movement	15	4	943	3	movement
opulent	9	3	883	3	_opulent
overlent	11	27	1529	3	_overlent
polyvalent	18	5	348	3	polyvalent
prevalent	14	12	806	3	prevalent
talent	6	3	2332	3	__talent
tervalent	12	4	557	3	tervalent
trivalent	12	4	648	3	trivalent
univalent	12	4	565	3	univalent
valet	8	43	3787	3	__vale_t

Search took 9 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	146162	0.173	1032896.0
2	DLD Change Limit	146162	67	8.470	17256.4
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	8.673	20603.1