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

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

77 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
elect	7	43	2703	(None)
eject	14	50	1604	1	eject
elects	8	33	1500	1	elects
erect	7	41	2933	1	erect
select	8	26	2117	1	select
alec	6	64	3006	2	alec_
alecs	7	66	2073	2	alecs
alert	5	47	4065	2	alert
bleat	7	57	3700	2	bleat
blent	7	62	3095	2	blent
blest	7	64	3172	2	blest
blet	6	62	4767	2	ble_t
cleat	7	63	3506	2	cleat
cleft	10	62	2285	2	cleft
clept	9	57	2577	2	clept
defect	12	48	1617	2	defect
deflect	13	39	997	2	deflect
deject	16	45	1284	2	deject
delict	9	43	2033	2	delict
detect	9	42	1740	2	detect
edict	8	47	2228	2	edict
educt	8	50	1710	2	educt
effect	14	3	744	2	effect
egest	6	52	2234	2	egest
ejecta	15	33	739	2	ejecta
ejects	15	40	995	2	ejects
eldest	7	29	1268	2	eldest
elected	10	28	1261	2	elected
electee	9	25	1324	2	electee
elector	9	33	1325	2	elector
electro	9	28	1003	2	electro
elegit	7	12	1289	2	elegit
elegy	9	3	930	2	elegy
elemi	7	3	1250	2	elemi
elicit	8	4	1720	2	elicit
elint	5	54	3647	2	elint
eluent	6	3	1548	2	eluent
enact	7	35	2536	2	enact
epact	9	49	2153	2	epact
erects	8	41	1618	2	erects
eruct	7	40	2235	2	eruct
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
fleck	14	82	1359	2	fleck
fleet	8	59	3233	2	fleet
gleet	6	55	3234	2	gleet
lech	9	68	2544	2	_lech
leech	10	49	1321	2	leech
leet	4	59	5790	2	_leet
left	7	63	4048	2	_left
lent	4	63	6053	2	_lent
lept	6	64	4088	2	_lept
lest	4	69	5632	2	_lest
let	3	64	8147	2	_le_t
neglect	10	4	736	2	neglect
pleat	7	47	3447	2	pleat
prelect	11	10	1383	2	prelect
reelect	9	115	1563	2	reelect
refect	11	43	1933	2	refect
reflect	12	39	1371	2	reflect
reject	15	41	1628	2	reject
relent	6	44	3185	2	relent
relet	5	47	4982	2	rele_t
relict	8	36	2390	2	relict
reluct	8	39	1611	2	reluct
resect	8	44	2470	2	resect
sect	6	74	4362	2	_sect
selects	9	19	1214	2	selects
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	77	2.110	25497.6
3	Display Results	77	77	0.013	5923.1
	(SQL Overall)	178691	77	2.216	80636.7