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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

106 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
casement	12	3	1195	(None)
basement	12	3	1149	1	basement
casements	13	4	858	1	casements
easement	10	4	1416	1	easement
abasement	13	4	833	2	abasement
basemen	11	3	908	2	basemen_
basements	13	4	826	2	basements
cavemen	14	3	714	2	cavemen_
cement	10	33	2166	2	c__ement
cerement	12	3	1513	2	cerement
clement	11	3	1377	2	c_lement
easements	11	4	1033	2	easements
encasement	14	4	870	2	encasement
pavement	15	4	944	2	pavement
abasements	14	4	653	3	abasements
abashment	16	4	602	3	abashment
abatement	13	4	818	3	abatement
abetment	12	4	823	3	_abetment
acescent	12	4	801	3	acescent
ailment	9	3	1423	3	_ailment
aliment	9	3	1670	3	_aliment
amassment	13	4	641	3	amassment
amazement	22	4	647	3	amazement
ament	7	60	3654	3	_a__ment
amusement	13	4	775	3	amusement
ascent	8	45	1965	3	_as_cent
ashmen	11	6	817	3	_ashmen_
assent	6	51	1995	3	_as_sent
augment	10	9	1020	3	_augment
averment	13	3	1160	3	_averment
axemen	15	4	749	3	_axemen_
bailment	12	4	918	3	bailment
bakemeat	16	5	527	3	bakemeat
baseman	11	3	855	3	baseman_
battement	13	5	777	3	battement
besetment	13	4	695	3	besetment
blastment	13	4	716	3	blastment
bodement	13	4	1012	3	bodement
cabernet	12	4	1076	3	cabernet
cabmen	12	36	1065	3	ca_bmen_
cadent	9	41	2036	3	ca__dent
cajolement	21	5	523	3	cajolement
calamint	12	3	1513	3	calamint
calescent	13	11	822	3	calescent
calmest	11	3	1234	3	ca_lmest
calumet	11	3	1329	3	calume_t
candent	10	4	1736	3	ca_ndent
canescent	13	11	876	3	canescent
capelet	11	5	1707	3	capele_t
careen	8	41	1949	3	care_en_
careens	9	45	1470	3	care_ens
carmen	10	40	1934	3	ca_rmen_
casein	8	32	1645	3	case_in_
caseins	9	31	1505	3	case_ins
casemate	12	3	984	3	casemate
casern	8	47	1331	3	case_rn_
caserne	9	37	1006	3	case_rne
casernes	10	38	1075	3	casernes
caserns	9	47	1122	3	case_rns
cashmere	15	6	432	3	cashmere
casimere	12	5	479	3	casimere
casket	12	48	2099	3	cas_ke_t
cassena	9	28	784	3	cas_sena
cassene	9	31	1154	3	cas_sene
castanet	10	4	1619	3	castanet
catchment	18	4	629	3	catchment
catmint	11	3	1446	3	ca_tmint
caveman	14	3	707	3	caveman_
cementa	11	28	1053	3	c__ementa
cements	11	27	1422	3	c__ements
cerements	13	4	1145	3	cerements
coherent	13	4	1247	3	coherent
comment	13	103	1770	3	c_omment
cosecant	12	4	1068	3	cosecant
credent	10	3	1397	3	c_redent
crescent	12	7	1105	3	crescent
debasement	15	4	729	3	debasement
dement	9	38	2514	3	__dement
element	9	3	1780	3	_element
encasements	15	4	745	3	encasements
encashment	17	4	611	3	encashment
escapement	16	4	586	3	escapement
garment	10	3	1523	3	ga_rment
gasmen	9	31	1156	3	gas_men_
gatemen	10	4	760	3	gatemen_
lament	8	50	2494	3	la__ment
misevent	13	4	922	3	misevent
movement	15	4	943	3	movement
nascent	9	6	1052	3	nas_cent
parament	12	4	1539	3	parament
pavements	16	4	700	3	pavements
payment	14	3	1070	3	pa_yment
placement	15	4	818	3	placement
raiment	9	3	1541	3	ra_iment
ravelment	14	4	720	3	ravelment
recement	12	3	1565	3	recement
rousement	11	4	903	3	rousement
sarment	9	3	1876	3	sa_rment
segment	10	3	1256	3	__segment
semen	7	57	2410	3	__semen_
semens	8	46	1696	3	__semens
statement	11	4	879	3	statement
tenement	10	4	1259	3	tenement
varment	12	3	1324	3	va_rment
vehement	16	4	776	3	vehement
vestment	13	10	920	3	vestment

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	146162	0.436	409841.7
2	DLD Change Limit	146162	106	8.406	17387.8
3	Display Results	106	106	0.030	3533.3
	(SQL Overall)	178691	106	8.872	20141.0