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

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

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.

74 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
milliliters	13	5	304	(None)
milliliter	12	4	362	1	milliliter_
millimeters	15	4	415	2	millimeters
fillisters	13	4	387	3	filli_sters
kiloliters	14	4	293	3	ki_loliters
melilites	11	4	919	3	m_elilite_s
microliters	15	4	580	3	microliters
millerites	12	4	793	3	millerite_s
milliers	10	26	1190	3	mi_l_li_ers
milliluces	14	10	297	3	milliluce_s
milliluxes	19	11	272	3	milliluxe_s
millimeter	14	4	454	3	millimeter_
milliners	11	28	995	3	mi_l_liners
mollifiers	15	4	399	3	mollifi_ers
bibliolaters	16	7	210	4	bibliolaters
billeters	11	3	687	4	bi_l_leters
cellulites	12	9	443	4	cellulite_s
centiliters	13	4	391	4	centiliters
civilizers	24	10	312	4	ci_vilizers
deciliters	13	4	517	4	_deciliters
delimiters	13	4	510	4	_delimiters
filisters	12	3	700	4	fi_li_sters
fillister	12	4	442	4	filli_ster_
gillnetters	12	6	145	4	gillnetters
illites	7	24	1501	4	_i_l_lite_s
inhibiters	15	4	369	4	_inhibiters
kiloliter	13	4	401	4	ki_loliter_
kilolitres	14	4	272	4	ki_lolitres
limiters	10	24	933	4	___limiters
melilite	10	4	1057	4	m_elilite__
melinites	11	3	1041	4	m_elinite_s
microliter	14	4	742	4	microliter_
midlifers	15	25	493	4	mi__dlifers
midwinters	16	4	248	4	midwi_nters
militates	11	3	1088	4	mi_litate_s
millerite	11	4	840	4	millerite__
millers	9	36	2134	4	mi_l_l__ers
milliampere	17	5	157	4	milliampere
milliamperes	18	6	134	4	milliamperes
milliares	11	4	940	4	milli_are_s
milliaries	12	4	824	4	milliarie_s
millibars	13	6	556	4	mi_l_libars
milliemes	13	25	584	4	milli_eme_s
millier	9	37	1670	4	mi_l_li_er_
millilambert	18	6	161	4	millilambert
millilamberts	19	6	85	4	millilamberts
millimes	12	24	1137	4	mi_l_lime_s
millimoles	14	4	426	4	millimole_s
milliner	10	28	1186	4	mi_l_liner_
millinery	14	33	610	4	mi_l_linery
millines	10	27	1806	4	mi_l_line_s
millionths	15	4	324	4	milliont_hs
millipedes	15	4	371	4	millipede_s
millipeds	14	4	470	4	mi_l_lipeds
millirems	13	4	432	4	mi_l_lirems
milliwatts	15	5	274	4	milliwat_ts
milters	9	36	1909	4	m___il_ters
minibikers	18	4	239	4	mi_nibikers
minimizers	23	4	378	4	mi_nimizers
ministers	11	3	962	4	mi_ni_sters
misalters	11	3	691	4	mi_sal_ters
misinters	11	3	818	4	mi_si_nters
mislikers	15	31	706	4	mi__slikers
missileers	12	4	419	4	missil_eers
mobilizers	23	4	425	4	m_obilizers
mollifier	14	4	516	4	mollifi_er_
mollifies	14	4	755	4	mollifi_e_s
mullites	10	4	1164	4	m_ul_lite_s
multipliers	15	5	436	4	multipli_ers
nullifiers	13	4	315	4	nullifi_ers
pollinizers	22	5	297	4	pollinizers
tillites	8	3	1283	4	ti_l_lite_s
vilifiers	15	4	456	4	vi_lifi_ers
willemites	15	4	367	4	willemite_s

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	74	9.406	15821.7
3	Display Results	74	74	0.046	1608.7
	(SQL Overall)	178691	74	9.875	18095.3