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

Here are the results of your fuzzy-string dictionary search for “dioxane” with Change Limit: [1] [2] [3] [4]

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.

82 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
dioxane	15	6	542	(None)
dioxan	14	6	577	1	dioxan_
dioxanes	16	4	537	1	dioxanes
dioxans	15	5	531	1	dioxans
dioxide	16	5	630	2	dioxide
dioxin	14	11	878	2	dioxin_
dioxins	15	6	800	2	dioxins
siloxane	15	4	374	2	siloxane
biplane	11	3	903	3	biplane
borane	8	46	2021	3	_borane
coxae	14	61	1518	3	_coxa_e
decane	9	38	1887	3	d_ecane
deodand	10	3	571	3	deodand
deplane	10	3	1141	3	deplane
diabase	10	3	711	3	diabase
diamante	11	8	642	3	diamante
diamine	10	3	1198	3	diamine
diazine	17	3	893	3	diazine
dictate	10	3	1166	3	dictate
diene	6	57	2013	3	di__ene
digoxin	16	4	494	3	digoxin_
digoxins	17	4	429	3	digoxins
dilate	7	32	2069	3	di_late
dine	5	55	5533	3	di___ne
diocese	10	3	685	3	diocese
diode	7	47	1611	3	dio__de
dioptase	11	4	551	3	dioptase
dioptre	10	5	576	3	dioptre
diorama	10	4	653	3	diorama
diorite	8	3	1491	3	diorite
dioxid	15	6	839	3	diox_id
dioxides	17	5	620	3	dioxides
dioxids	16	5	568	3	dioxids
diphase	13	8	727	3	diphase
disband	11	3	824	3	disband
discant	10	30	1725	3	discant
discase	10	29	1286	3	discase
disease	8	32	1384	3	disease
disrate	8	14	1852	3	disrate
dissave	11	3	941	3	dissave
distance	11	3	1185	3	distance
distant	8	35	1995	3	distant
dittany	11	3	565	3	dittany
divan	9	61	1484	3	di_van_
divans	10	46	1239	3	di_vans
divine	10	35	1446	3	di_vine
diwan	9	57	1255	3	di_wan_
diwans	10	51	1037	3	di_wans
dogbane	11	3	565	3	dogbane
dogvane	12	4	385	3	dogvane
domaine	10	6	1050	3	d_omaine
domine	9	29	1825	3	d_omine
donate	7	36	1950	3	d_onate
done	5	57	4791	3	d_o__ne
donne	6	55	2046	3	d_o_nne
dopant	9	3	1613	3	d_opant
dosage	8	28	1000	3	d_osage
dotage	8	27	1161	3	d_otage
doxie	13	60	1715	3	d_ox_ie
drone	6	53	2498	3	dro__ne
duotone	8	3	689	3	duotone
fixate	16	3	873	3	fi_xate
hexane	16	37	953	3	_hexane
immane	10	3	888	3	_immane
inane	5	28	2034	3	_i_nane
insane	6	3	1488	3	_insane
iodate	7	3	1350	3	_iodate
iodine	7	46	1865	3	_iodine
ionone	6	3	1344	3	_ionone
liane	5	47	2066	3	li__ane
lindane	8	3	903	3	lindane
miocene	11	4	792	3	miocene
niobate	9	3	770	3	niobate
profane	12	21	1186	3	profane
propane	11	27	1615	3	propane
silane	6	27	1805	3	si_lane
siloxanes	16	4	361	3	siloxanes
tisane	6	3	1157	3	ti_sane
tolane	6	43	1658	3	_tolane
toxine	13	31	1412	3	_toxine
violate	10	3	1155	3	violate
violone	10	3	715	3	violone

Search took 8 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	134027	0.140	1276364.3
2	DLD Change Limit	134027	82	6.830	19623.3
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.000	25527.3