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

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

114 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
defi	8	63	2149	(None)
def	7	65	4672	1	def_
defis	9	67	1750	1	defis
deft	8	55	4022	1	deft
defy	11	49	2126	1	defy
deli	5	56	3129	1	deli
deni	5	69	2939	1	deni
befit	10	52	2266	2	befit
cedi	7	49	1927	2	cedi
daff	11	52	2968	2	daff
daft	8	55	3725	2	daft
de	3	70	4954	2	de__
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deb	6	63	4269	2	de_b
debit	8	57	2785	2	debit
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
dee	4	76	6582	2	de_e
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
defat	9	54	2669	2	defat
defer	9	46	1975	2	defer
defied	11	50	1638	2	defied
defier	10	51	1865	2	defier
defies	10	46	2405	2	defies
defile	10	52	1666	2	defile
define	10	47	1814	2	define
defog	10	4	852	2	defog
deific	12	3	731	2	deific
deify	12	41	1276	2	deify
deil	5	62	3162	2	deil
deke	9	52	2876	2	deke
del	4	67	5275	2	de_l
dele	5	68	4308	2	dele
delf	8	54	3657	2	delf
delfs	9	49	1867	2	delfs
delft	9	56	2332	2	delft
delis	6	49	2854	2	delis
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delt	5	78	5527	2	delt
deme	7	65	3628	2	deme
demic	10	51	1919	2	demic
demit	8	48	3230	2	demit
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
dene	5	66	4341	2	dene
denim	8	55	1884	2	denim
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desk	9	56	1890	2	desk
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devil	9	47	1473	2	devil
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	de_x
dexie	13	47	1689	2	dexie
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
deys	8	50	2747	2	deys
dif	7	68	4690	2	dif_
diff	11	62	2884	2	diff
difs	8	60	2732	2	difs
doff	11	62	2578	2	doff
duci	7	64	2262	2	duci
duff	11	43	2664	2	duff
dui	4	64	3338	2	d_ui
ef	5	73	4536	2	_ef_
eff	9	61	2862	2	_eff
efs	6	68	2960	2	_efs
eft	6	60	3882	2	_eft
heft	10	67	3629	2	heft
jefe	14	65	1688	2	jefe
kef	10	56	3966	2	kef_
kefir	12	45	791	2	kefir
kefs	11	59	2274	2	kefs
kepi	10	53	1563	2	kepi
kufi	11	9	1065	2	kufi
left	7	63	4048	2	left
lei	3	68	4638	2	le_i
neif	7	54	2949	2	neif
nevi	7	51	1642	2	nevi
peri	6	56	3697	2	peri
ref	6	60	5329	2	ref_
refit	8	42	3006	2	refit
refix	15	52	1248	2	refix
refs	7	57	3224	2	refs
reft	7	51	4127	2	reft
rei	3	56	4725	2	re_i
reif	7	69	3765	2	reif
sei	3	60	4893	2	se_i
seif	7	56	3873	2	seif
semi	6	51	2722	2	semi
teff	10	60	2376	2	teff
weft	10	54	3501	2	weft
yeti	7	58	2321	2	yeti

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	29872	0.186	960704.3
2	DLD Change Limit	29872	114	1.690	17675.7
3	Display Results	114	114	0.013	8769.2
	(SQL Overall)	178691	114	1.889	94595.6