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

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

38 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
odyls	9	42	865	(None)
idyls	9	49	880	1	idyls
odyl	8	41	1146	1	odyl_
odyle	9	34	959	1	odyle
odyles	10	34	856	1	odyles
acyls	10	42	1152	2	acyls
amyls	10	45	1269	2	amyls
aryls	8	70	1581	2	aryls
dals	5	71	4512	2	_dals
dels	5	67	4547	2	_dels
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	_dols
doyly	12	45	1401	2	doyly
dyes	8	53	3189	2	_dyes
idols	6	55	1413	2	idols
idyl	8	59	1230	2	idyl_
idyll	9	43	671	2	idyll
idylls	10	42	525	2	idylls
modals	9	39	1445	2	modals
models	9	42	1635	2	models
nonyls	9	5	785	2	nonyls
obols	7	37	1586	2	obols
octyls	11	13	532	2	octyls
odahs	9	56	1008	2	odahs
odas	5	72	3026	2	od_as
oddly	10	3	716	2	oddly
odds	6	89	1992	2	od_ds
odes	5	72	4324	2	od_es
odors	6	45	1428	2	odors
ods	4	75	4621	2	od__s
oils	4	63	3797	2	o_ils
opals	7	57	1835	2	opals
orals	5	58	2648	2	orals
ovals	8	54	1339	2	ovals
owls	7	60	2293	2	o_wls
oyes	7	49	4013	2	o_yes
tolyls	9	43	696	2	tolyls
yodels	10	46	1007	2	yodels

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.313	570897.8
2	DLD Change Limit	53800	38	1.530	35163.4
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	1.859	96122.1