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

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

34 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
extent	13	27	1491	(None)
extant	13	27	1475	1	extant
extend	14	26	752	1	extend
extents	14	26	1017	1	extents
attent	6	28	1832	2	attent
detent	7	36	2448	2	detent
eaten	5	53	2305	2	eaten_
eluent	6	3	1548	2	eluent
entente	7	4	1295	2	entente
event	8	59	2444	2	e_vent
except	17	9	765	2	except
exert	12	46	2414	2	ex_ert
exeunt	13	3	870	2	exeunt
exigent	15	3	951	2	exigent
existent	15	4	826	2	existent
expect	17	5	890	2	expect
expend	16	24	750	2	expend
expert	15	5	1535	2	expert
exsect	15	5	850	2	exsect
exsert	13	4	1436	2	exsert
extends	15	22	711	2	extends
extern	13	4	847	2	extern
externe	14	3	857	2	externe
externs	14	3	823	2	externs
extinct	16	4	690	2	extinct
extort	13	5	1397	2	extort
intent	6	31	2277	2	intent
latent	6	41	2430	2	latent
patent	8	45	2492	2	patent
potent	8	42	2335	2	potent
sextant	14	29	1196	2	sextant
sextet	13	9	1687	2	sexte_t
stent	5	56	3451	2	_stent
tent	4	61	5986	2	__tent

Search took 3 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	82551	0.360	496363.9
2	DLD Change Limit	82551	34	2.423	34069.7
3	Display Results	34	34	0.013	2615.4
	(SQL Overall)	178691	34	2.796	63909.5