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

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

38 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
coherence	16	7	694	(None)
coherences	17	8	704	1	coherences
coherency	19	7	455	1	coherency
adherence	15	6	489	2	adherence
coherencies	18	8	477	2	coherencies
coherent	13	4	1247	2	coheren_t
conference	17	9	901	2	conference
incoherence	18	5	519	2	incoherence
inherence	14	4	927	2	inherence
adherences	16	6	488	3	adherences
clarence	12	4	645	3	c_larence
coerce	10	3	1040	3	co_er__ce
coerect	11	9	1335	3	co_ere_ct
cohere	11	27	1699	3	coher___e
cohered	13	35	1469	3	cohere__d
coherently	18	5	432	3	coherently
coherer	12	29	1278	3	cohere__r
coherers	13	23	1073	3	cohere_rs
coheres	12	29	1769	3	cohere__s
cohering	14	24	1383	3	coherin_g
commence	16	14	910	3	co_mmence
competence	18	4	672	3	competence
conferences	18	9	881	3	conferences
conferrence	18	9	657	3	conferrence
congruence	15	5	507	3	congruence
convergence	19	11	654	3	convergence
coprince	14	4	709	3	co_prince
covalence	16	4	584	3	covalence
credence	13	8	782	3	c_redence
deference	15	7	849	3	deference
incoherences	19	5	491	3	incoherences
inference	14	4	1103	3	inference
inherences	15	6	897	3	inherences
inherency	17	4	593	3	inherency
reference	14	8	1009	3	reference
reverence	14	7	1016	3	reverence
tolerance	11	4	598	3	tolerance
vehemence	19	4	360	3	vehemence

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	38	7.000	21234.4
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	7.439	24020.8