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

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

118 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
centenaries	13	4	648	(None)
bicentenaries	17	6	202	2	bicentenaries
catenaries	12	4	866	2	c_atenaries
centenarian	13	6	468	2	centenarian
centenarians	14	5	374	2	centenarians
septenaries	13	7	535	2	septenaries
centares	10	29	1389	3	cent__ar_es
centauries	12	4	553	3	cent_auries
centenary	14	4	432	3	centenar__y
centiares	11	6	765	3	cent_iar_es
centuries	11	3	1133	3	cent__uries
contraries	12	7	1193	3	cont_raries
decenaries	13	4	812	3	de_cenaries
mercenaries	15	5	544	3	mercenaries
septenarius	13	9	273	3	septenarius
tercentenaries	16	8	152	3	~~ter~~centenaries
anticaries	12	4	1247	4	_anticaries
bestiaries	12	4	597	4	best_iaries
bewearies	14	4	701	4	be_we_aries
canaries	10	3	1894	4	c___anaries
canewares	14	4	736	4	can_ewar_es
canneries	11	3	1308	4	can__neries
cannonries	12	4	409	4	cannon_ries
canonries	11	4	841	4	can_on_ries
cantharides	17	5	403	4	cant_harides
cantharis	14	4	718	4	cant_hari_s
carpentries	15	4	479	4	carpentries
cartularies	13	4	537	4	cartularies
categories	13	4	607	4	c_ategories
catenates	11	3	1181	4	c_atena_tes
catteries	11	8	1552	4	catte__ries
cauteries	11	6	1539	4	caute__ries
celeries	10	3	1631	4	ce_le__ries
cemeteries	14	4	738	4	ce_meteries
centare	9	31	1370	4	cent__ar_e_
centennial	12	13	484	4	centen_nial
centennials	13	13	353	4	centennials
centered	11	25	1352	4	cente__r_ed
centering	12	29	1514	4	cente__ring
centerings	13	24	766	4	cente__rings
centerless	12	4	500	4	cente__rless
centerlines	13	4	699	4	centerlines
centers	9	44	2060	4	cente__r__s
centeses	10	7	944	4	cente___ses
centesis	10	5	814	4	cente__si_s
centiare	10	6	720	4	cent_iar_e_
centners	10	5	724	4	cent_ner__s
centones	10	3	1366	4	centon___es
centralise	12	6	960	4	cent_ralise
centralises	13	4	929	4	cent_ralises
centralizes	22	4	942	4	cent_ralizes
centres	9	38	1712	4	cent___r_es
cinerarias	12	4	523	4	cin_erarias
commentaries	18	5	680	4	commentaries
congeries	12	3	1640	4	conge__ries
contumacies	17	5	414	4	contumacies
coronaries	12	4	1023	4	c_oronaries
costmaries	14	4	691	4	cost_maries
cotenancies	15	4	507	4	c_otenancies
coteries	10	4	2270	4	c_ote__ries
countenances	16	5	573	4	countenances
countercries	16	4	899	4	countercries
customaries	15	5	373	4	customaries
decennaries	14	5	426	4	decennaries
dentistries	12	5	342	4	dentistries
eateries	8	3	2431	4	_eate__ries
engineries	11	4	547	4	_engineries
ensnares	8	5	689	4	_en_snar_es
ententes	8	3	1277	4	_enten__tes
enterics	10	3	1285	4	_ente__rics
enterprise	12	5	554	4	_enterprise
enterprises	13	5	554	4	_enterprises
entreaties	10	4	811	4	_entreaties
entries	7	15	2316	4	_ent___ries
estuaries	9	4	621	4	_est_uaries
gentries	9	13	1526	4	gent___ries
heathenries	17	5	455	4	heathen_ries
henneries	12	4	864	4	hen__neries
lectionaries	14	5	477	4	lectionaries
legendaries	13	5	309	4	le_gendaries
legendries	12	4	382	4	le_gendries
legionaries	12	7	456	4	legionaries
leniencies	12	4	619	4	lenien_cies
lienteries	10	4	756	4	liente__ries
millenaries	13	5	552	4	millenaries
nectaries	11	4	981	4	nect__aries
neotenies	9	4	838	4	neoten__ies
nonentries	10	4	828	4	non_entries
octonaries	12	4	600	4	_octonaries
parcenaries	15	5	584	4	parcenaries
pendencies	15	4	702	4	penden_cies
penitentiaries	16	9	149	4	penitentiaries
pensionaries	14	5	406	4	pensionaries
pentameries	15	5	475	4	pentameries
pentenes	10	3	1563	4	penten___es
plenaries	11	4	1038	4	__plenaries
quaternaries	21	5	283	4	quaternaries
quincentenaries	26	8	111	4	~~quin~~centenaries
reentries	9	3	1176	4	re__entries
renitencies	13	4	609	4	reniten_cies
sceneries	11	4	939	4	scen_e__ries
secretaries	13	4	542	4	secretaries
sectaries	11	3	1224	4	sect__aries
seminaries	12	4	1000	4	se_minaries
sentences	11	6	1030	4	senten__ces
sentiencies	13	4	632	4	sentien_cies
sentries	8	13	1805	4	sent___ries
septenarii	12	5	212	4	septenari_i
tenantries	10	4	567	4	ten_antries
tendencies	13	4	634	4	tenden_cies
ternaries	9	3	1164	4	te__rnaries
tertiaries	10	4	700	4	tert_iaries
textuaries	17	4	362	4	text_uaries
tutelaries	10	4	396	4	_tutelaries
venenates	12	4	758	4	ven_ena_tes
veneries	11	28	1503	4	ven_e__ries
vestiaries	13	4	537	4	vest_iaries
veterinaries	15	5	319	4	ve_terinaries

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.436	409841.7
2	DLD Change Limit	148819	118	9.296	16008.9
3	Display Results	118	118	0.063	1873.0
	(SQL Overall)	178691	118	9.795	18243.1