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

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

117 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
idea	5	91	2277	(None)
ideal	6	57	1639	1	ideal
ideas	6	59	1901	1	ideas
idem	7	61	2106	1	idem
ides	5	77	3423	1	ides
ilea	4	59	3146	1	ilea
odea	5	62	2457	1	odea
aide	5	60	4499	2	aide_
aided	7	58	2893	2	aided
aider	6	54	3113	2	aider
aides	6	53	3660	2	aides
area	4	58	4339	2	area
asea	4	63	2718	2	asea
bide	7	60	4147	2	bide_
bided	9	54	2496	2	bided
bider	8	57	2837	2	bider
bides	8	55	3677	2	bides
bidet	8	49	3562	2	bidet
cider	8	47	2331	2	cider
de	3	70	4954	2	_de_
dead	6	54	3424	2	_dead
deaf	8	58	3840	2	_deaf
deal	5	63	4741	2	_deal
dean	5	60	3948	2	_dean
dear	5	53	4360	2	_dear
deb	6	63	4269	2	_deb
dee	4	76	6582	2	_dee
def	7	65	4672	2	_def
del	4	67	5275	2	_del
den	4	75	5434	2	_den
dev	7	60	3377	2	_dev
deva	8	57	2098	2	_deva
dew	7	71	3992	2	_dew
dex	11	69	3688	2	_dex
dey	7	72	4337	2	_dey
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dita	5	60	3252	2	dita
diva	8	59	2088	2	diva
edema	8	6	1055	2	edema
eide	5	58	3223	2	eide_
eider	6	46	2474	2	eider
flea	7	56	2849	2	flea
hide	8	51	3462	2	hide_
hided	10	52	2244	2	hided
hider	9	50	2408	2	hider
hides	9	51	2942	2	hides
ibex	13	38	1347	2	ibex
ice	5	67	3724	2	ice_
iced	7	87	2189	2	iced
ices	6	61	2964	2	ices
id	3	89	4183	2	id__
ideals	7	50	1250	2	ideals
ideate	7	3	1368	2	ideate
idle	5	54	2376	2	idle
idled	7	49	1521	2	idled
idler	6	50	1566	2	idler
idles	6	67	2012	2	idles
idly	8	56	1732	2	idly
idol	5	68	1863	2	idol
ids	4	75	3546	2	id_s
idyl	8	59	1230	2	idyl
ileac	7	58	1417	2	ileac
ileal	5	61	1808	2	ileal
ilex	11	58	2203	2	ilex
ilia	4	60	2681	2	ilia
ilka	8	72	1515	2	ilka
index	13	3	1098	2	index
inia	4	50	2469	2	inia
iota	4	51	2783	2	iota
ire	3	69	4317	2	ire_
ired	5	51	3187	2	ired
ires	4	56	3928	2	ires
isba	6	13	1087	2	isba
item	6	56	2038	2	item
ixia	11	57	1320	2	ixia
kea	7	65	4091	2	_kea
lea	3	76	6018	2	_lea
nide	5	55	3578	2	nide_
nided	7	59	2087	2	nided
nides	6	52	2913	2	nides
oda	4	81	3304	2	od_a
ode	4	74	4658	2	ode_
odes	5	72	4324	2	odes
oidia	6	3	1495	2	oidia
olea	4	65	3272	2	olea
pea	5	66	5724	2	_pea
pilea	7	51	2395	2	pilea
plea	6	68	3060	2	plea
rhea	7	50	1743	2	rhea
ride	5	59	4512	2	ride_
rider	6	52	3130	2	rider
rides	6	61	4081	2	rides
sea	3	61	6129	2	_sea
shea	7	60	3157	2	shea
side	5	54	4448	2	side_
sided	7	48	2595	2	sided
sides	6	58	3836	2	sides
tea	3	73	5332	2	_tea
tide	5	52	3737	2	tide_
tided	7	63	2251	2	tided
tides	6	48	3015	2	tides
tinea	5	49	2315	2	tinea
toea	4	67	3233	2	toea
urea	4	65	2805	2	urea
uvea	7	47	1265	2	uvea
vide	8	54	3275	2	vide_
video	9	60	1495	2	video
wide	8	52	3540	2	wide_
widen	9	47	1797	2	widen
wider	9	48	2635	2	wider
wides	9	48	3282	2	wides
yea	6	64	4575	2	_yea
zoea	13	71	1842	2	zoea

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	29872	0.080	2233637.5
2	DLD Change Limit	29872	117	1.013	29488.6
3	Display Results	117	117	0.033	3545.5
	(SQL Overall)	178691	117	1.126	158695.4