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

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

78 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
materiels	11	4	783	(None)
materials	11	5	1080	1	materials
materiel	10	3	1125	1	materiel_
eateries	8	3	2431	2	eaterie_s
masteries	11	10	1849	2	masterie_s
material	10	3	1410	2	material_
aerials	7	40	1755	3	_a_erials
aeries	6	47	3778	3	_a_erie_s
amberies	12	25	1468	3	amberie_s
aperies	9	4	2320	3	_aperie_s
ariels	6	51	1937	3	_a__riels
arterials	9	4	969	3	arterials
arteries	8	3	2148	3	arterie_s
ateliers	8	3	788	3	_ateliers
bacterials	14	4	633	3	bacterials
bakeries	14	3	1219	3	bakerie_s
batteries	11	6	1511	3	batterie_s
catbriers	13	4	414	3	catbriers
caterers	10	28	1440	3	cater_ers
cateress	10	23	1161	3	cater_ess
catteries	11	8	1552	3	catterie_s
cauteries	11	6	1539	3	cauterie_s
coteries	10	4	2270	3	coterie_s
dataries	9	3	1403	3	datarie_s
faeries	10	41	1899	3	fa_erie_s
fakeries	15	5	983	3	fakerie_s
haverels	14	32	575	3	haver_els
imageries	12	4	678	3	imagerie_s
japeries	17	3	1146	3	japerie_s
laetriles	9	4	467	3	laetriles
laterals	8	3	1275	3	later_als
laterites	9	7	1506	3	laterites
laterizes	18	5	1302	3	laterizes
mackerels	17	4	308	3	macker_els
maderizes	21	4	895	3	maderizes
mandrels	11	3	731	3	mandr_els
mandrills	12	4	545	3	mandrills
mandrils	11	3	849	3	mandri_ls
marcels	11	32	1237	3	ma__rcels
marrieds	11	28	807	3	ma_rrieds
marriers	10	33	1247	3	ma_rriers
marries	9	38	2528	3	ma_rrie_s
martyries	14	4	656	3	martyrie_s
marvels	12	38	1009	3	ma__rvels
mateless	10	27	1129	3	mate_less
materialise	13	4	783	3	materialise
materialism	15	4	826	3	materialism
materialist	13	4	951	3	materialist
materially	15	4	800	3	materially
maternal	10	4	780	3	maternal_
maters	8	50	3239	3	mater___s
mateyness	14	4	447	3	mateyness
matres	8	45	2223	3	mat_r_e_s
matrices	12	3	1208	3	mat_rices
matrixes	17	3	806	3	mat_rixes
mattress	10	3	653	3	mattr_ess
maturely	13	4	490	3	matur_ely
maturers	10	3	738	3	matur_ers
matures	9	3	1431	3	matur_e_s
mavericks	20	4	318	3	mavericks
miseries	10	3	2040	3	miserie_s
miterers	10	21	968	3	miter_ers
moperies	12	3	1387	3	moperie_s
mysteries	14	12	1119	3	mysterie_s
naperies	10	3	1390	3	naperie_s
niteries	8	3	1838	3	niterie_s
tercels	9	41	1036	3	__tercels
wasteries	12	11	1534	3	wasterie_s
waterbeds	15	4	488	3	waterbeds
waterers	11	23	1278	3	water_ers
waterhens	15	7	496	3	waterhens
waterier	11	3	1208	3	waterie_r
wateriest	12	3	1223	3	wateriest
waterily	14	3	878	3	wateri_ly
wateriness	13	4	807	3	wateriness
waterings	13	22	925	3	waterings
waterjets	19	4	446	3	waterjets
waterless	12	3	801	3	waterless

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	148641	0.440	406115.9
2	DLD Change Limit	148641	78	6.530	22762.8
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	7.003	25516.4