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

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

112 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
idem	7	61	2107	(None)
idea	5	91	2278	1	idea
ides	5	77	3424	1	ides
item	6	56	2038	1	item
adeem	8	3	1180	2	adeem
ahem	9	72	2536	2	ahem
aide	5	60	4501	2	aide_
aided	7	58	2894	2	aided
aider	6	54	3114	2	aider
aides	6	53	3661	2	aides
bide	7	60	4151	2	bide_
bided	9	54	2497	2	bided
bider	8	57	2838	2	bider
bides	8	55	3678	2	bides
bidet	8	49	3563	2	bidet
cider	8	47	2332	2	cider
dam	6	74	5704	2	_dam
de	3	70	4955	2	_de_
deb	6	63	4269	2	_deb
dee	4	76	6582	2	_dee
deem	7	54	3289	2	deem
def	7	65	4672	2	_def
del	4	67	5275	2	_del
deme	7	65	3628	2	_deme
demo	7	74	2755	2	_demo
demy	10	54	2285	2	_demy
den	4	75	5434	2	_den
derm	7	60	3189	2	_derm
dev	7	60	3377	2	_dev
dew	7	71	3992	2	_dew
dex	11	69	3688	2	_dex
dey	7	72	4337	2	_dey
diadem	10	3	758	2	diadem
die	4	67	5966	2	die_
died	6	61	3786	2	died
diel	5	90	3461	2	diel
dies	5	56	5353	2	dies
diet	5	73	5754	2	diet
dim	6	81	4650	2	_dim
dime	7	62	3765	2	dime
dom	6	97	5244	2	_dom
edema	8	6	1055	2	edema
eide	5	58	3225	2	eide_
eider	6	46	2475	2	eider
em	4	94	4515	2	__em
fem	8	60	4073	2	_fem
gem	6	68	4022	2	_gem
haem	9	57	3098	2	haem
hem	8	61	4873	2	_hem
hide	8	51	3465	2	hide_
hided	10	52	2245	2	hided
hider	9	50	2409	2	hider
hides	9	51	2943	2	hides
ibex	13	38	1348	2	ibex
ibidem	11	3	479	2	ibidem
ice	5	67	3725	2	ice_
iced	7	87	2189	2	iced
ices	6	61	2964	2	ices
id	3	89	4185	2	id__
ideal	6	57	1639	2	ideal
ideas	6	59	1901	2	ideas
idiom	8	9	996	2	idiom
idle	5	54	2377	2	idle
idled	7	49	1521	2	idled
idler	6	50	1566	2	idler
idles	6	67	2012	2	idles
idly	8	56	1733	2	idly
idol	5	68	1864	2	idol
ids	4	75	3548	2	id_s
idyl	8	59	1231	2	idyl
ilea	4	59	3146	2	ilea
ileum	7	45	1282	2	ileum
ilex	11	58	2203	2	ilex
imam	8	17	1833	2	imam
index	13	3	1098	2	index
ire	3	69	4318	2	ire_
ired	5	51	3187	2	ired
ires	4	56	3928	2	ires
ism	5	63	2239	2	i_sm
items	7	49	961	2	items
mem	7	79	4347	2	_mem
modem	10	37	1714	2	modem
neem	6	73	2808	2	neem
nide	5	55	3580	2	nide_
nided	7	59	2088	2	nided
nides	6	52	2914	2	nides
ode	4	74	4659	2	ode_
odea	5	62	2457	2	odea
odes	5	72	4324	2	odes
odeum	8	46	1054	2	odeum
poem	8	62	2577	2	poem
rem	5	61	5004	2	_rem
ride	5	59	4514	2	ride_
rider	6	52	3131	2	rider
rides	6	61	4082	2	rides
seem	6	54	3856	2	seem
side	5	54	4450	2	side_
sided	7	48	2596	2	sided
sides	6	58	3837	2	sides
stem	6	106	2825	2	stem
teem	6	61	3260	2	teem
them	9	74	2704	2	them
tide	5	52	3739	2	tide_
tided	7	63	2252	2	tided
tides	6	48	3016	2	tides
vide	8	54	3277	2	vide_
video	9	60	1496	2	video
wide	8	52	3542	2	wide_
widen	9	47	1798	2	widen
wider	9	48	2636	2	wider
wides	9	48	3283	2	wides
ylem	9	2	1789	2	ylem

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.423	422437.4
2	DLD Change Limit	29872	112	0.856	34897.2
3	Display Results	112	112	0.033	3393.9
	(SQL Overall)	178691	112	1.312	136197.4