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

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

52 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
hectoliters	16	5	213	(None)
hectoliter	15	6	325	1	hectoliter_
hectometers	18	4	606	2	hectometers
centiliters	13	4	391	3	centiliters
decaliters	13	4	521	3	dec_aliters
deciliters	13	4	517	3	dec_iliters
hectometer	17	4	641	3	hectometer_
microliters	15	4	580	3	microliters
aerolites	9	3	1258	4	ae_rolite_s
bentonites	12	4	530	4	bentonite_s
centiliter	12	4	565	4	centiliter_
colters	9	35	2244	4	__c_ol_ters
decaliter	12	4	798	4	dec_aliter_
deciliter	12	4	703	4	dec_iliter_
decilitres	13	4	499	4	dec_ilitres
decliners	12	35	861	4	dec__liners
dekaliters	15	4	341	4	de_kaliters
desolaters	11	4	604	4	de_solaters
eclogites	12	4	526	4	_eclogite_s
exploiters	19	4	383	4	_exploiters
extollers	16	6	385	4	_extol_lers
extorters	16	4	576	4	_exto_rters
fertilizers	23	4	344	4	fertilizers
headliners	14	14	433	4	he_adliners
headwaiters	18	5	262	4	headwaiters
hecklers	17	35	712	4	hec_kl__ers
hectors	12	35	1326	4	hecto____rs
heliometers	16	4	602	4	heliometers
heptameters	18	5	327	4	heptameters
hessonites	13	4	369	4	hessonite_s
holsters	11	32	1194	4	h___olsters
hoteliers	12	4	580	4	h_oteli_ers
jetliners	16	4	418	4	je_t_liners
kiloliters	14	4	293	4	_kiloliters
microliter	14	4	742	4	microliter_
niccolites	14	4	413	4	niccolite_s
pistoliers	12	4	458	4	pistoli_ers
reciters	10	26	1311	4	rec___iters
recliners	11	27	911	4	rec__liners
recoilers	11	31	815	4	rec_o_ilers
recounters	12	4	621	4	rec_ounters
recruiters	12	4	371	4	rec_ruiters
rectifiers	15	4	517	4	rectifi_ers
rectorates	12	4	1037	4	rectorate_s
rectories	11	3	1465	4	rectori_e_s
retorters	9	3	877	4	re_to_rters
revolters	12	29	748	4	re_vol_ters
sectilities	13	4	869	4	sectilities
sepiolites	12	4	601	4	sepiolite_s
tectites	10	3	999	4	tect__ite_s
theodolites	15	5	314	4	theodolite_s
zeolites	17	3	838	4	ze__olite_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.453	394461.4
2	DLD Change Limit	148819	52	9.126	16307.1
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	9.595	18623.3