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

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

73 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
maxillaries	20	5	310	(None)
axillaries	17	4	487	1	_axillaries
capillaries	15	5	445	2	capillaries
vexillaries	21	5	287	2	vexillaries
ancillaries	13	5	457	3	ancillaries
auxiliaries	18	5	273	3	auxiliaries
axillars	15	23	599	3	_axillar__s
maxillae	17	25	672	3	maxilla__e_
maxillary	21	4	344	3	maxillar__y
maxillas	17	22	770	3	maxilla___s
milliaries	12	4	824	3	m__illiaries
premaxillaries	25	7	90	3	~~pre~~maxillaries
railleries	10	4	664	3	ra_illeries
submaxillaries	25	7	79	3	~~sub~~maxillaries
apiaries	10	3	1272	4	_api__aries
artilleries	11	8	454	4	artilleries
aviaries	11	3	978	4	_avi__aries
axialities	17	4	773	4	_axialities
axillae	14	24	823	4	_axilla__e_
axillar	14	24	756	4	_axillar___
axillary	18	23	510	4	_axillar__y
axillas	14	27	896	4	_axilla___s
axiologies	18	3	748	4	_axiologies
balladries	13	4	519	4	ba__lladries
calvaries	14	4	980	4	ca__lvaries
capillarities	17	5	243	4	capillarities
capillarity	18	5	287	4	capillarity
capitularies	16	5	274	4	capitularies
cartularies	13	4	537	4	cartularies
corollaries	13	5	499	4	corollaries
fallacies	14	4	683	4	fa__llacies
familiarise	16	5	340	4	familiarise
familiarises	17	5	312	4	familiarises
familiarizes	26	5	298	4	familiarizes
fritillaries	15	5	200	4	fritillaries
gaillardias	13	5	175	4	ga_illardias
galleries	10	3	1170	4	ga__lleries
grilleries	11	4	559	4	_grilleries
imaginaries	14	5	372	4	imagi_naries
janisaries	17	4	478	4	jani_saries
janissaries	18	5	237	4	janissaries
janizaries	26	4	350	4	jani_zaries
laniaries	9	4	1121	4	lani__aries
lapidaries	13	4	506	4	lapi_daries
maladies	11	3	1193	4	ma___ladies
malarias	10	3	1377	4	ma___larias
malarkies	15	4	511	4	ma___larkies
mallards	11	3	832	4	ma__llar_ds
mandataries	14	5	382	4	mandataries
manillas	10	26	1116	4	manilla___s
manilles	10	23	1260	4	manill___es
maquillages	23	5	140	4	maquilla_ges
maxilla	16	24	819	4	maxilla____
maxilliped	22	5	155	4	maxill_iped
maxillipeds	23	5	83	4	maxillipeds
miladies	11	3	992	4	m__i_ladies
miliarias	11	4	878	4	m__iliarias
militaries	12	4	944	4	m__ilitaries
millages	11	32	1290	4	m__illa_ges
millenaries	13	5	552	4	m__illenaries
millerites	12	4	793	4	m__illerites
milliares	11	4	940	4	m__illiar_es
millraces	13	4	575	4	m__illraces
paillards	12	4	498	4	pa_illar_ds
paillasses	12	4	335	4	pa_illasses
phyllaries	18	4	445	4	_phyllaries
pillories	11	8	957	4	__pillories
ramillies	11	4	613	4	ramill__ies
sagittaries	12	5	299	4	sagittaries
salaries	8	3	1957	4	sa___laries
sanitaries	10	4	991	4	sani_taries
vacillates	15	5	571	4	vacilla_tes
wallabies	14	4	573	4	wa__llabies

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.423	422437.4
2	DLD Change Limit	148819	73	8.436	17640.9
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	8.889	20102.5