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

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

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.

57 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
antiphonaries	18	6	269	(None)
antiphonies	16	5	626	2	antiphon__ies
antiphonals	16	5	369	3	antiphona__ls
antiphonary	19	5	261	3	antiphonar__y
anticaries	12	4	1247	4	anti___caries
antimonies	12	4	1058	4	anti_mon__ies
antiparties	13	4	756	4	antip___arties
antiphonal	15	5	458	4	antiphona___l
antiphonally	20	5	283	4	antiphona_lly
antiphons	14	4	710	4	antiphon____s
antiphrases	16	5	474	4	antiph_ra_ses
antiphrasis	16	5	538	4	antiph_rasi_s
antiquaries	20	5	632	4	anti__quaries
antistories	11	4	937	4	antisto__ries
ancientries	13	5	451	5	anci__entries
ancillaries	13	5	457	5	anci__llaries
anisogamies	14	5	279	5	an_i_sogamies
anniversaries	16	6	172	5	anniversaries
anthologies	15	10	1201	5	ant__hologies
antiarins	9	4	1389	5	anti____arins
antibodies	13	4	698	5	anti_bo__dies
antiheroes	13	4	717	5	anti_h__eroes
antiherpes	15	4	540	5	anti_h__erpes
antilogies	11	4	1031	5	anti_lo__gies
antimonides	14	5	566	5	anti_mon_ides
antinomies	12	4	936	5	anti___nomies
antiozonants	21	8	243	5	antiozona_nts
antipathies	16	5	537	5	antip__athies
antiphon	13	4	677	5	antiphon_____
antiphony	17	4	485	5	antiphon____y
antipodals	13	5	533	5	antip_oda__ls
antipodes	12	7	892	5	antip_o___des
antipolar	11	10	694	5	antip_olar___
antipoles	11	8	1047	5	antip_o___les
antipolitics	16	5	579	5	antip_olitics
antipopes	13	6	861	5	antip_o___pes
antipyrines	16	5	474	5	antip___yrines
antirabies	12	4	841	5	anti___rabies
antonymies	15	5	502	5	ant___onymies
apophonies	17	5	652	5	a_pophon__ies
athanasies	13	5	348	5	a_t__hanasies
audiphones	16	5	321	5	audiphon___es
autophagies	17	5	413	5	autoph__agies
ciphonies	16	4	654	5	__ciphon__ies
dictionaries	15	5	478	5	dicti__onaries
functionaries	18	6	301	5	functi__onaries
lectionaries	14	5	477	5	lecti__onaries
legionaries	12	7	456	5	legi__onaries
nationalise	11	19	1048	5	nati__onalise
nationalises	12	29	1036	5	nati__onalises
nationalizes	21	17	861	5	nati__onalizes
octonaries	12	4	600	5	oct___onaries
pensionaries	14	5	406	5	pensi__onaries
reactionaries	15	5	354	5	reacti__onaries
siphonages	16	4	299	5	__siphona_ges
taphonomies	18	5	342	5	__taphonomies
visionaries	14	5	425	5	__visionaries

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	124790	0.390	458182.1
2	DLD Change Limit	124790	57	8.953	13938.3
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	9.373	19064.4