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

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

86 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
erect	7	41	2933	(None)
eject	14	50	1604	1	eject
elect	7	43	2703	1	elect
erects	8	41	1618	1	erects
eruct	7	40	2235	1	eruct
areca	7	56	1863	2	areca
bereft	11	43	1730	2	bereft
beret	7	49	4636	2	bere_t
bract	9	63	3272	2	bract
brent	7	57	3413	2	brent
coerect	11	9	1335	2	coerect
crept	9	51	2589	2	crept
crest	7	46	3269	2	crest
defect	12	48	1617	2	defect
deject	16	45	1284	2	deject
detect	9	42	1740	2	detect
direct	9	38	1733	2	direct
dreck	12	48	1280	2	dreck
drest	6	55	3034	2	drest
edict	8	47	2228	2	edict
educt	8	50	1710	2	educt
effect	14	3	744	2	effect
egest	6	52	2234	2	egest
egret	6	33	2731	2	egre_t
ejecta	15	33	739	2	ejecta
ejects	15	40	995	2	ejects
elects	8	33	1500	2	elects
enact	7	35	2536	2	enact
epact	9	49	2153	2	epact
ere	3	63	5277	2	ere__
erected	10	32	1399	2	erected
erecter	9	31	1339	2	erecter
erectly	12	5	748	2	erectly
erector	9	35	1381	2	erector
ergot	6	54	2289	2	ergot
erica	7	3	1654	2	erica
erst	4	74	3643	2	er_st
eructs	8	36	1079	2	eructs
erupt	7	42	2006	2	erupt
event	8	59	2444	2	event
evert	8	49	2951	2	evert
evict	10	44	1714	2	evict
exact	14	35	1693	2	exact
exec	13	53	1394	2	exec_
execs	14	53	972	2	execs
exert	12	46	2414	2	exert
expect	17	5	890	2	expect
exsect	15	5	850	2	exsect
fret	7	58	4504	2	fre_t
gerent	7	32	2310	2	gerent
great	6	60	3424	2	great
greet	6	58	3532	2	greet
hereat	9	35	2741	2	hereat
merest	8	47	2511	2	merest
perfect	14	10	1083	2	perfect
preact	10	32	2039	2	preact
precut	10	20	1653	2	precut
prest	7	57	3635	2	prest
react	7	46	3433	2	react
rec	5	56	4546	2	_rec_
recit	7	52	3510	2	_recit
reck	10	61	3056	2	_reck
recs	6	57	3418	2	_recs
recta	7	42	2026	2	_recta
recti	7	36	1962	2	_recti
recto	7	45	2080	2	_recto
recut	7	47	2924	2	_recut
reerect	9	29	1588	2	reerect
reest	5	49	3809	2	reest
refect	11	43	1933	2	refect
reft	7	51	4127	2	_reft
reject	15	41	1628	2	reject
rent	4	66	6124	2	_rent
rerent	6	38	3245	2	rerent
resect	8	44	2470	2	resect
rest	4	64	5984	2	_rest
ret	3	59	8283	2	_re_t
sect	6	74	4362	2	_sect
select	8	26	2117	2	select
serest	6	48	3161	2	serest
tercet	8	36	2491	2	tercet
tract	7	56	3571	2	tract
treat	5	62	4035	2	treat
tret	4	66	5353	2	tre_t
wreck	14	46	1104	2	wreck
wrest	8	49	2543	2	wrest

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	53800	0.640	279204.7
2	DLD Change Limit	53800	86	4.623	11637.5
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	5.296	33740.7