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

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

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

105 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
cabinetries	15	4	408	(None)
cabinetry	16	4	293	3	cabinetr__y
cabinets	12	3	828	3	cabinet___s
caninities	12	4	1049	3	caninit_ies
canneries	11	3	1308	3	ca_nne_ries
carpentries	15	4	479	3	carpentries
salimetries	13	4	569	3	salimetries
abhenries	14	4	450	4	_ab_henries
abilities	11	7	1414	4	_abilit_ies
acidimetries	17	5	275	4	acidimetries
actinometries	17	5	410	4	actinometries
agentries	10	4	823	4	_agen_tries
altimetries	13	5	592	4	altimetries
aminities	11	3	1291	4	_aminit_ies
ancientries	13	5	451	4	ancientries
babbitries	13	4	319	4	bab_bitries
babbittries	14	5	164	4	babbittries
babooneries	15	5	243	4	baboone_ries
barometries	15	4	769	4	barometries
baronetcies	15	5	324	4	baronetcies
barretries	12	4	624	4	ba_rretries
basketries	16	4	504	4	ba_sketries
bigotries	12	8	644	4	__bigotries
binaries	10	3	1418	4	__bin_aries
binderies	12	3	1168	4	__binderies
biometries	14	4	893	4	__biometries
cabinet	11	3	1890	4	cabinet____
cabinetmaker	22	6	80	4	cabinetmaker
cabinetmakers	23	6	83	4	cabinetmakers
cabinetwork	22	6	106	4	cabinetwork
cabinetworks	23	6	93	4	cabinetworks
cabinmates	16	4	389	4	cabin_mates
caginesses	13	3	1094	4	cagine_sses
cajoleries	19	4	476	4	cajole_ries
cakinesses	16	3	1061	4	cakine_sses
calorimetries	17	5	254	4	calorimetries
canaries	10	3	1894	4	ca__n_aries
canities	10	15	1926	4	ca__nit_ies
cannonries	12	4	409	4	ca_nnonries
canonries	11	4	841	4	ca__nonries
cantrips	12	31	893	4	ca__n_trips
capillaries	15	5	445	4	capillaries
carbineers	14	4	423	4	carbineer__s
carnivories	16	5	340	4	carnivories
casimeres	13	5	519	4	casime_r_es
casuistries	13	5	274	4	casuistries
catenaries	12	4	866	4	caten_aries
catteries	11	8	1552	4	ca_tte_ries
causeries	11	5	1064	4	ca_use_ries
cauteries	11	6	1539	4	ca_ute_ries
cavities	13	14	1261	4	cavi__t_ies
chantries	14	3	1029	4	c_han_tries
cinerins	10	4	1410	4	c__ine_rins
citizenries	22	5	165	4	citizenries
clowneries	15	4	474	4	clowne_ries
coquetries	21	4	602	4	c_oquetries
cornetcies	14	4	584	4	c_ornetcies
corsetries	12	4	965	4	c_orsetries
countries	11	3	1361	4	c_oun_tries
craniometries	17	5	341	4	craniometries
cubicities	16	4	682	4	cubicit_ies
dainties	9	3	1240	4	da_in_t_ies
dosimetries	14	5	475	4	dosimetries
dubieties	12	4	528	4	dubi_et_ies
engineries	11	4	547	4	engine_ries
fineries	11	24	1674	4	__fine_ries
gadgetries	13	4	401	4	ga_dgetries
gaieties	9	3	1018	4	ga_i_et_ies
gantries	9	14	1378	4	ga__n_tries
gauntries	10	4	603	4	ga_un_tries
gravimetries	18	5	248	4	gravimetries
joineries	16	4	810	4	_joine_ries
labilities	12	7	1223	4	labilit_ies
latinities	10	4	1016	4	latinit_ies
machineries	18	5	379	4	machine_ries
manometries	15	4	725	4	manometries
marquetries	22	5	370	4	marquetries
maumetries	14	4	602	4	ma_umetries
naboberies	14	4	326	4	nabobe_ries
naiveties	12	4	543	4	na_ivet_ies
nineties	8	3	1291	4	__ninet_ies
oximetries	19	4	456	4	_oximetries
pantries	10	18	1739	4	pa__n_tries
papistries	14	4	519	4	papi_stries
parquetries	22	5	412	4	parquetries
perimetries	15	4	778	4	perimetries
pineries	10	24	1908	4	__pine_ries
printeries	12	4	1063	4	_printeries
rabbitries	14	4	333	4	rab_bitries
rabidities	13	4	770	4	rabidit_ies
radiometries	15	7	588	4	radiometries
refineries	13	4	706	4	refine_ries
salinities	10	4	1095	4	salinit_ies
satieties	9	3	938	4	sati_et_ies
satinettes	10	4	392	4	satinet_tes
subentries	12	4	642	4	suben_tries
tanistries	10	4	706	4	tani_stries
tanneries	9	3	1042	4	ta_nne_ries
toiletries	10	4	661	4	_toiletries
trinketries	15	35	431	4	_trinketries
ubieties	10	4	691	4	_ubi_et_ies
varieties	12	5	920	4	vari_et_ies
varletries	13	4	603	4	va_rletries
vineries	11	27	1604	4	__vine_ries
wineries	11	23	1653	4	__wine_ries

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.420	425454.8
2	DLD Change Limit	148819	105	8.690	17125.3
3	Display Results	105	105	0.046	2282.6
	(SQL Overall)	178691	105	9.156	19516.3