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

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

136 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
temptresses	15	4	359	(None)
empresses	13	4	816	2	_emp_resses
sempstresses	15	5	220	2	sempstresses
temptress	13	4	313	2	temptre_s_s
compresses	16	4	777	3	comp_resses
depresses	12	5	988	3	de_p_resses
editresses	11	6	507	3	_editresses
emptinesses	15	4	599	3	_emptinesses
expresses	18	3	786	3	_exp_resses
impresses	13	3	821	3	_imp_resses
represses	11	4	1214	3	re_p_resses
restresses	10	4	931	3	re_stresses
seamstresses	13	5	225	3	seamstresses
temporises	14	4	724	3	tempor_ises
tendresses	11	4	592	3	te_ndresses
traitresses	11	4	460	3	traitresses
actresses	11	3	793	4	__actresses
adeptnesses	14	4	483	4	adeptnesses
adultresses	12	4	293	4	adultresses
aptnesses	11	16	899	4	__aptnesses
arbitresses	13	4	334	4	arbitresses
aviatresses	14	8	300	4	aviatresses
bumpinesses	17	12	637	4	bumpinesses
buttresses	12	4	566	4	_buttresses
campinesses	17	3	711	4	campinesses
compressed	17	4	584	4	comp_ressed
cypresses	16	4	585	4	_cyp_resses
dampnesses	15	3	560	4	damp_nesses
decompresses	19	7	282	4	decomp_resses
deepnesses	13	6	667	4	deep_nesses
deftnesses	14	3	681	4	de_ftnesses
demitasses	13	4	295	4	demit_asses
demonesses	13	4	670	4	dem_onesses
depressed	13	5	762	4	de_p_ressed
derepresses	14	4	477	4	derepresses
distresses	11	4	885	4	_distresses
dumpinesses	16	12	625	4	dumpinesses
egresses	9	4	944	4	_e__gresses
eldresses	10	4	567	4	_e_ldresses
electresses	13	4	596	4	electresses
empress	11	3	816	4	_emp_re_s_s
emprises	12	3	1100	4	_emp_r_ises
espressos	11	4	397	4	_esp_ressos
expressed	19	4	621	4	_exp_ressed
expresser	18	4	573	4	_exp_resser
expressers	19	4	443	4	_exp_ressers
expressos	18	4	455	4	_exp_ressos
fortresses	13	4	566	4	_fortresses
gemminesses	16	3	498	4	gemminesses
headdresses	16	8	369	4	headdresses
heiresses	12	3	696	4	he__iresses
hotpresses	15	4	452	4	hotp_resses
humpinesses	18	10	624	4	humpinesses
huntresses	13	4	528	4	_huntresses
impreses	12	3	809	4	_imp_re_ses
impressed	14	4	628	4	_imp_ressed
inaptnesses	13	8	563	4	inaptnesses
ineptnesses	13	9	638	4	ineptnesses
jointresses	18	4	347	4	jointresses
jumpinesses	22	12	534	4	jumpinesses
leopardesses	15	7	151	4	leopardesses
limpnesses	14	11	665	4	limp_nesses
lumpinesses	15	10	711	4	lumpinesses
matrasses	11	5	729	4	__matrasses
mattresses	12	4	543	4	_mattresses
meetnesses	12	3	745	4	me_etnesses
mistresses	12	4	799	4	_mistresses
neatnesses	10	3	1001	4	ne_atnesses
oppresses	13	4	687	4	__oppresses
oratresses	10	4	549	4	_oratresses
outpresses	12	15	725	4	outp_resses
overstresses	15	5	484	4	overstresses
peartnesses	13	3	874	4	peartnesses
peeresses	11	3	847	4	pe__eresses
peppinesses	14	3	531	4	peppinesses
pertnesses	12	3	1031	4	pe_rtnesses
portresses	12	4	731	4	_portresses
presses	9	35	2315	4	___p_resses
prestresses	13	4	672	4	prestresses
promptnesses	18	4	363	4	promptnesses
raptnesses	12	4	852	4	_raptnesses
readdresses	13	9	451	4	readdresses
redigresses	13	4	394	4	redigresses
redresses	10	4	1029	4	re__dresses
reexpresses	20	4	361	4	reexpresses
regresses	10	3	1046	4	re__gresses
remotenesses	14	4	681	4	remotenesses
repressed	12	6	1010	4	re_p_ressed
represser	11	6	895	4	re_p_resser
repressers	12	5	688	4	re_p_ressers
restressed	11	4	665	4	re_stressed
sculptresses	16	6	140	4	sculptresses
seductresses	15	5	204	4	seductresses
seeresses	9	3	905	4	se__eresses
sempstress	14	5	219	4	sempstre_s_s
slipdresses	14	4	257	4	slipdresses
steepnesses	13	4	592	4	steep_nesses
stresses	8	11	1249	4	___stresses
suppresses	14	4	625	4	_suppresses
tacitnesses	13	3	632	4	tacitnesses
tamenesses	12	5	997	4	tam_enesses
tartnesses	10	11	1071	4	t_artnesses
tautnesses	10	11	828	4	t_autnesses
tearinesses	11	3	1169	4	tearinesses
temperances	17	5	473	4	temperances
temperers	13	24	702	4	tempere__rs
tempested	14	4	403	4	temp__ested
tempests	12	3	444	4	temp__e_sts
temporaries	15	5	424	4	temporaries
temporise	13	4	740	4	tempor_ise_
temporised	15	5	512	4	tempor_ised
temporizes	23	4	693	4	tempor_izes
tempters	12	25	729	4	tempt_e__rs
tendernesses	13	4	507	4	tendernesses
tendresse	10	4	379	4	te_ndresse_
tensenesses	11	4	761	4	tensenesses
tepidnesses	14	4	538	4	tepidnesses
tersenesses	11	4	904	4	tersenesses
testcrosses	13	5	187	4	testcrosses
testinesses	11	12	1032	4	testinesses
tightnesses	15	6	558	4	tightnesses
tigresses	10	4	640	4	t__igresses
timidnesses	14	4	514	4	timidnesses
topcrosses	14	4	227	4	t_opcrosses
traitoresses	12	5	264	4	traitoresses
tresses	7	37	1954	4	____tresses
tumidnesses	14	4	461	4	tumidnesses
tutoresses	10	4	437	4	t_utoresses
unaptnesses	13	9	552	4	unaptnesses
unstresses	10	4	603	4	_unstresses
victresses	15	4	497	4	_victresses
votresses	12	3	650	4	__votresses
waitresses	13	4	506	4	_waitresses
weepinesses	16	4	613	4	weepinesses
wetnesses	12	20	821	4	we__tnesses
wimpinesses	18	3	563	4	wimpinesses

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.470	380193.6
2	DLD Change Limit	148819	136	8.186	18179.7
3	Display Results	136	136	0.063	2158.7
	(SQL Overall)	178691	136	8.719	20494.4