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

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

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
chatelaines	16	5	338	(None)
chatelaine	15	4	430	1	chatelaine_
chatelains	15	4	480	1	chatelain_s
chatelain	14	4	500	2	chatelain__
chaplains	16	4	574	3	cha_plain_s
datelines	10	8	885	3	_datel_ines
baselines	11	3	860	4	_basel_ines
cagelings	13	3	541	4	c_agel_ings
calamines	13	3	1222	4	c_a__lamines
calcines	12	3	1475	4	c_a__lcines
capelans	12	3	801	4	c_apela_n_s
capelins	12	3	1113	4	c_apel_in_s
carlines	10	35	2166	4	c_a_rl_ines
cartelises	12	4	768	4	cartel_ises
cartelizes	21	4	763	4	cartel_izes
catalases	11	4	944	4	c_atala_ses
catechins	16	4	664	4	c_atechin_s
catechises	17	4	491	4	c_atechises
catechizes	26	4	434	4	c_atechizes
catenaries	12	4	867	4	c_atenaries
catenates	11	3	1181	4	c_atena_tes
caterans	10	3	1322	4	c_atera_n_s
catlings	11	37	1204	4	c_at_l_ings
catlins	9	38	1884	4	c_at_l_in_s
centerlines	13	4	699	4	centerlines
chaines	12	45	1873	4	ch____aines
chalices	15	3	1081	4	cha__l_ices
challies	13	39	1564	4	cha__lli_es
challises	14	35	878	4	cha__llises
chalones	13	3	1217	4	cha__l_ones
chamberlains	21	5	143	4	chamberlain_s
chameleons	17	9	306	4	chameleon_s
chamfrains	20	4	304	4	chamfrain_s
champagnes	20	4	267	4	cha_mpagnes
changelings	18	4	318	4	changel_ings
channelizes	25	5	299	4	channel_izes
chaperones	17	4	586	4	chape_rones
chaplain	15	4	619	4	cha_plain__
chaplaincies	21	5	131	4	cha_plaincies
chaplaincy	22	5	135	4	cha_plaincy
charladies	16	4	402	4	cha_rladies
charlies	13	34	1423	4	cha_rl_i_es
chartularies	17	5	256	4	chartularies
chateaus	13	4	601	4	chate_a__us
chatoyances	21	5	250	4	chatoyances
chatoyants	18	5	273	4	chatoya_nts
chattiness	15	6	512	4	chat__tiness
chelates	13	27	1385	4	ch__ela_tes
chilblains	17	9	351	4	chilblain_s
chitlings	15	25	590	4	chit_l_ings
chitlins	13	28	939	4	chit_l_in_s
cholines	13	22	1449	4	ch__ol_ines
coastlines	12	12	533	4	coastl_ines
covellines	15	4	530	4	c_ovellines
craterings	13	4	600	4	crate_rings
cutlines	10	24	1327	4	c_ut_l_ines
cysteamines	18	9	340	4	cysteamines
cysteines	14	4	514	4	cyste__ines
dateline	9	8	1035	4	_datel_ine_
datelined	11	9	471	4	_datel_ined
delaines	9	3	1296	4	___delaines
flatlines	12	26	843	4	flat_l_ines
hairlines	12	3	713	4	_hairl_ines
hotlines	11	8	1164	4	_hot_l_ines
madeleines	13	4	361	4	_madeleines
matelasses	12	5	400	4	_matelasses
ratlines	8	38	1529	4	_rat_l_ines
rhatanies	12	4	498	4	rhat__anies
satellites	10	4	542	4	_satellites
shapeliness	16	6	316	4	shapel_iness
shavelings	17	4	350	4	shavel_ings
shorelines	13	4	614	4	shorel_ines
stateliness	11	4	423	4	statel_iness
tapelines	11	3	846	4	_tapel_ines
thebaines	14	5	497	4	th__ebaines
vaselines	12	4	671	4	_vasel_ines
vitellines	13	9	473	4	_vitellines
waterlines	13	4	895	4	_waterlines

Search took 9 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.420	425454.8
2	DLD Change Limit	148819	78	8.486	17537.0
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	8.952	19961.0