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

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

77 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
calamints	13	4	805	(None)
calamines	13	3	1222	1	calamines
calamint	12	3	1513	1	calamint_
calamine	12	3	1403	2	calamin_e
calamined	14	4	743	2	calamined
calamite	12	3	1253	2	calami_te
calamites	13	4	1071	2	calamites
calamity	15	4	775	2	calami_ty
catmints	12	3	666	2	ca_tmints
adamants	11	8	634	3	_adamants
alanines	8	3	1480	3	_alanines
alanins	7	3	1580	3	_alanin_s
alants	6	77	2202	3	_ala__nts
alarmists	11	4	594	3	_alarmists
aliments	10	3	1109	3	_aliments
aluminas	10	4	835	3	_aluminas
alumines	10	4	1168	3	_alumines
alumins	9	5	1298	3	_alumin_s
cabalists	13	3	915	3	cabalists
caladiums	14	4	463	3	caladiums
calamanco	15	4	311	3	calamanco
calamancos	16	5	227	3	calamancos
calamaris	13	4	608	3	calamaris
calamars	12	3	813	3	calam_ars
calamata	12	4	755	3	calam_ata
calamatas	13	4	578	3	calamatas
calami	10	3	1342	3	calami___
calamining	15	4	593	3	calamining
calamities	14	4	847	3	calamities
calamitous	14	4	338	3	calamitous
calamus	11	3	924	3	calam__us
calcimines	16	7	468	3	calcimines
calcines	12	3	1475	3	cal_cines
calkings	15	28	922	3	cal_kings
calkins	13	38	1487	3	cal_kin_s
callants	10	41	1214	3	cal_lants
callings	11	36	1383	3	cal_lings
calming	12	39	1597	3	cal_min_g
calpains	12	3	976	3	calpain_s
calumets	12	3	628	3	calum_ets
calumnies	13	4	604	3	calumnies
canakins	14	20	1046	3	canakin_s
carabines	13	3	1147	3	carabines
carabins	12	3	1236	3	carabin_s
carmines	12	36	1786	3	ca_rmines
casements	13	4	858	3	casements
catamite	12	5	1059	3	catami_te
catamites	13	4	936	3	catamites
catamounts	14	5	229	3	catamounts
catmint	11	3	1446	3	ca_tmint_
cavatinas	14	4	478	3	cavatinas
ceramists	13	4	672	3	ceramists
cladists	11	3	672	3	c_ladists
claimants	13	4	428	3	claimants
clamant	11	3	1243	3	c_lamant_
clarinets	11	3	768	3	c_larinets
coamings	13	34	929	3	c_oamings
cobalamins	16	5	322	3	cobalamin_s
filaments	14	4	665	3	filaments
flamines	13	3	1164	3	_flamines
galavants	13	4	394	3	galavants
gallamines	13	4	549	3	gallamines
halakists	16	12	535	3	halakists
jalapins	17	4	562	3	jalapin_s
laments	9	43	1485	3	__laments
laminas	9	36	1587	3	__laminas
malemiuts	13	4	338	3	malemiuts
melamines	13	3	976	3	melamines
paladins	11	9	1100	3	paladin_s
palatines	11	3	1303	3	palatines
palmists	12	26	881	3	pal_mists
palominos	13	4	406	3	palominos
paraments	13	5	1155	3	paraments
plaints	9	40	1205	3	_pla_ints
salamis	9	3	1351	3	salami__s
salariats	9	4	782	3	salariats
varmints	13	3	564	3	va_rmints

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	148641	0.420	425454.8
2	DLD Change Limit	148641	77	7.703	19296.5
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	8.156	21909.1