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

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

98 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
dexies	14	50	1834	(None)
defies	10	46	2405	1	defies
demies	9	48	2580	1	demies
denies	7	47	2964	1	denies
dexes	13	52	2451	1	dex_es
dexie	13	47	1689	1	dexie_
doxies	14	39	1785	1	doxies
aeries	6	47	3778	2	aeries
belies	8	46	3105	2	belies
bevies	11	40	1730	2	bevies
davies	10	50	2051	2	davies
deairs	7	40	1378	2	deairs
dearies	8	35	2627	2	dearies
deaves	10	53	1953	2	deaves
debits	9	42	1450	2	debits
debyes	12	3	810	2	debyes
decides	11	42	1765	2	decides
deciles	10	44	1772	2	deciles
decries	10	33	1980	2	decries
dees	5	63	5663	2	de__es
defied	11	50	1638	2	defied
defier	10	51	1865	2	defier
defiers	11	39	1399	2	defiers
defiles	11	40	1684	2	defiles
defines	11	41	1868	2	defines
defis	9	67	1750	2	defi_s
deices	9	41	1937	2	deices
deifies	11	33	1745	2	deifies
deils	6	57	2286	2	de_ils
deities	8	26	2192	2	deities
deixis	14	3	724	2	deixis
deixises	16	3	569	2	deixises
dekes	10	52	2445	2	de_kes
deles	6	51	3925	2	de_les
delimes	10	3	1419	2	delimes
delis	6	49	2854	2	deli_s
dellies	8	36	2221	2	dellies
delves	10	49	1708	2	delves
demes	8	60	3269	2	de_mes
demise	9	46	1832	2	demise
demises	10	37	1956	2	demises
demits	9	49	1807	2	demits
denes	6	56	3972	2	de_nes
denied	8	43	1863	2	denied
denier	7	44	2069	2	denier
deniers	8	45	1518	2	deniers
denims	9	52	1432	2	denims
derbies	10	30	1605	2	derbies
derides	9	34	2085	2	derides
derives	11	40	1781	2	derives
derries	8	31	2462	2	derries
desires	8	13	1613	2	desires
deuces	9	40	1551	2	deuces
devices	13	32	1258	2	devices
devils	10	44	1281	2	devils
devise	10	42	1575	2	devise
devises	11	41	1676	2	devises
dewier	10	40	1346	2	dewier
dewiest	11	3	1234	2	dewiest
dexter	14	38	1089	2	dexter
didies	8	46	2183	2	didies
dies	5	56	5352	2	d__ies
dixits	14	42	1031	2	dixits
dobies	9	44	2209	2	dobies
dogies	8	50	2225	2	dogies
dories	7	52	3236	2	dories
doxie	13	60	1715	2	doxie_
dries	6	47	3367	2	d_ries
duties	7	49	2190	2	duties
eddies	8	33	1316	2	eddies
exes	11	65	3081	2	_ex_es
exiles	13	48	1640	2	_exiles
exines	13	57	1580	2	_exines
exits	12	55	1591	2	_exits
genies	7	53	2494	2	genies
hexes	15	51	2304	2	hex_es
kexes	16	62	1682	2	kex_es
levies	9	39	1986	2	levies
lexes	12	72	2526	2	lex_es
lexis	12	59	1603	2	lexi_s
moxies	15	43	1740	2	moxies
newies	9	10	1407	2	newies
nixies	13	53	1387	2	nixies
pixies	15	49	1551	2	pixies
prexies	16	34	1500	2	prexies
pyxies	18	33	829	2	pyxies
relies	6	50	3642	2	relies
reties	6	54	3619	2	reties
rexes	12	45	2695	2	rex_es
rexines	14	47	1915	2	rexines
series	6	45	4097	2	series
sexes	12	61	2622	2	sex_es
sexier	13	3	1068	2	sexier
sexiest	14	21	1222	2	sexiest
taxies	13	58	1733	2	taxies
vegies	10	43	1427	2	vegies
vexes	15	57	1912	2	vex_es
vexils	16	4	717	2	vexils

Search took 4 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.343	520965.0
2	DLD Change Limit	82551	98	2.640	31269.3
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	3.013	59306.7