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

Here are the results of your fuzzy-string dictionary search for “vexed” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
vexed	16	57	1311	(None)
exed	12	54	2059	1	_exed
hexed	16	56	1576	1	hexed
sexed	13	66	1854	1	sexed
vexer	15	55	1352	1	vexer
vexes	15	57	1912	1	vexes
axed	12	88	2961	2	_axed
boxed	15	43	1861	2	boxed
ceded	9	61	1855	2	ceded
cered	8	52	2744	2	cered
coxed	15	43	2281	2	coxed
deed	6	53	4090	2	de_ed
deked	11	57	1853	2	deked
deled	7	53	2654	2	deled
dewed	10	50	2030	2	dewed
dexes	13	52	2451	2	dexes
eked	9	67	1802	2	_eked
evened	10	10	1031	2	evened
exec	13	53	1394	2	_exec
exes	11	65	3081	2	_exes
eyed	8	66	2323	2	_eyed
faxed	16	62	2053	2	faxed
feed	8	45	3890	2	fe_ed
feted	9	44	2093	2	feted
feued	9	47	1566	2	feued
fixed	16	54	1695	2	fixed
flexed	17	41	908	2	flexed
foxed	16	51	1521	2	foxed
geed	6	54	3550	2	ge_ed
heed	8	64	3760	2	he_ed
hewed	12	56	1943	2	hewed
hexad	16	49	1062	2	hexad
hexer	15	51	1668	2	hexer
hexes	15	51	2304	2	hexes
jeed	12	54	2850	2	je_ed
jewed	16	51	1483	2	jewed
kexes	16	62	1681	2	kexes
keyed	13	6	938	2	keyed
lexes	12	72	2526	2	lexes
loxed	13	50	1705	2	loxed
maxed	15	58	2119	2	maxed
meed	7	49	3470	2	me_ed
meted	8	54	2443	2	meted
mewed	11	52	1801	2	mewed
mixed	15	57	1725	2	mixed
need	5	49	3415	2	ne_ed
nixed	13	57	1422	2	nixed
overed	10	22	1662	2	overed
peed	7	62	3918	2	pe_ed
poxed	15	48	1786	2	poxed
raxed	13	56	2266	2	raxed
reded	7	48	2911	2	reded
reed	5	55	4962	2	re_ed
refed	9	39	2192	2	refed
rewed	9	54	2545	2	rewed
rexes	12	45	2695	2	rexes
seed	5	55	4948	2	se_ed
sered	6	57	3729	2	sered
sewed	9	53	2516	2	sewed
sexes	12	61	2622	2	sexes
taxed	13	56	2029	2	taxed
teed	5	54	3926	2	te_ed
tewed	9	47	1853	2	tewed
unvexed	18	14	710	2	unvexed
vaned	9	46	2242	2	vaned
vealed	10	39	1632	2	vealed
vee	6	57	5018	2	ve_e_
veep	9	53	2509	2	ve_ep
veer	7	62	2957	2	ve_er
veered	10	36	1274	2	veered
vees	7	54	3943	2	ve_es
veges	9	41	1886	2	veges
vegged	12	49	1001	2	vegged
veiled	10	37	1454	2	veiled
veined	10	44	1391	2	veined
veld	8	53	2320	2	ve_ld
vend	8	66	2642	2	ve_nd
vended	11	44	1635	2	vended
venged	11	40	1198	2	venged
vented	10	46	1792	2	vented
verged	11	48	1515	2	verged
versed	10	45	1551	2	versed
vested	10	42	1735	2	vested
vetoed	10	35	982	2	vetoed
vetted	10	43	1632	2	vetted
vex	13	64	2917	2	vex__
vexedly	21	4	345	2	vexedly
vexers	16	52	1040	2	vexers
vexil	15	3	896	2	vexil
vext	14	69	2776	2	vex_t
viced	11	51	1818	2	viced
vied	8	63	2863	2	v_ied
viewed	13	4	599	2	viewed
vined	9	56	2615	2	vined
vised	9	55	1876	2	vised
vixen	15	30	1002	2	vixen
voled	9	53	2372	2	voled
voted	9	39	1914	2	voted
vowed	12	44	2457	2	vowed
waxed	16	60	1848	2	waxed
weed	8	56	3751	2	we_ed

Search took 2 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	101	1.673	32157.8
3	Display Results	101	101	0.016	6312.5
	(SQL Overall)	178691	101	1.782	100275.5