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

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

75 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
testatrices	13	5	280	(None)
testatrixes	18	5	209	1	testatrixes
cantatrices	15	5	344	3	cantatrices
fellatrices	16	5	251	3	fellatrices
mediatrices	16	5	338	3	mediatrices
statices	10	27	1234	3	__stat_ices
tectrices	13	4	625	3	te__ctrices
tentatives	13	4	548	3	tentat_ives
testacies	11	4	837	3	testa_ci_es
testates	8	36	1545	3	testat___es
testatrix	16	5	203	3	testatri__x
astatines	9	3	1034	4	_astat_ines
aviatrices	15	4	316	4	_aviatrices
bestiaries	12	4	597	4	bestiari_es
bestrides	12	3	791	4	bes__trides
bisectrices	17	5	231	4	bisectrices
cantatrice	14	6	346	4	cantatrice_
centauries	12	4	553	4	centauri_es
cicatrices	13	4	349	4	_cicatrices
cockatrices	18	5	233	4	cockatrices
dentifrices	17	5	186	4	dentifrices
ecstatics	13	4	437	4	ecstat_ic_s
editrices	12	4	532	4	_e_ditrices
enstatites	10	4	452	4	enstat_ites
estates	7	45	2018	4	_estat___es
estuaries	9	4	621	4	_estuari_es
fellatrixes	21	5	201	4	fellatrixes
generatrices	15	5	225	4	generatrices
gentrices	12	5	892	4	ge__ntrices
geriatrics	13	4	342	4	geriatric_s
gestates	9	32	1373	4	gestat___es
gestations	11	3	977	4	gestat_ions
gestative	13	4	730	4	gestat_ive_
heretrices	15	4	630	4	he_retrices
heritrices	15	5	530	4	he_ritrices
jesuitries	17	4	320	4	jesuitri_es
matrices	12	3	1208	4	___matrices
mediatrixes	21	5	259	4	mediatrixes
nectaries	11	4	982	4	necta_ri_es
nectarines	12	4	689	4	necta_rines
obstetrics	14	5	260	4	obstetric_s
oratrices	11	4	583	4	__oratrices
pediatrics	15	4	419	4	pediatric_s
pessaries	11	10	866	4	pessa_ri_es
rectrices	13	3	887	4	re__ctrices
restates	8	34	2343	4	restat___es
restations	10	3	1584	4	restat_ions
restricts	11	3	882	4	res__tricts
restrikes	13	3	941	4	res__trikes
restrives	12	3	1066	4	res__trives
sectaries	11	3	1224	4	secta_ri_es
sesterces	11	4	787	4	sest_er_ces
statice	9	26	1403	4	__stat_ice_
statics	9	33	1453	4	__stat_ic_s
statives	11	27	1079	4	__stat_ives
teatimes	10	3	944	4	te__at_imes
tenantries	10	4	567	4	tenantri_es
tentative	12	4	781	4	tentat_ive_
ternaries	9	3	1164	4	terna_ri_es
tertiaries	10	4	700	4	tertiari_es
testate	7	39	1623	4	testat___e_
testators	9	4	733	4	testat__ors
testicles	11	4	677	4	tes__t_icles
testifies	12	13	926	4	test_ifi_es
testudines	11	4	309	4	test_udines
tetanics	10	12	737	4	te_ta_nic_s
tetanies	8	5	1355	4	te_ta_ni_es
tetanises	9	7	987	4	te_ta_nises
tetanizes	18	8	984	4	te_ta_nizes
textuaries	17	4	362	4	textuari_es
texturizes	26	4	396	4	text_urizes
theatrics	14	4	477	4	t_heatric_s
veratrines	13	4	726	4	ve_ratrines
vestiaries	13	4	537	4	vestiari_es
vestries	11	3	1405	4	ves__tri_es

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	75	8.940	16646.4
3	Display Results	75	75	0.046	1630.4
	(SQL Overall)	178691	75	9.406	18997.6