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

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

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.

69 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
monardas	11	4	571	(None)
monarda	10	4	661	1	monarda_
mojarras	17	4	225	2	mojarras
monadal	10	4	789	2	mona_dal
monades	10	37	1382	2	mona_des
monads	9	45	1530	2	mona_d_s
monarchs	15	4	483	2	monarchs
boards	9	46	1693	3	bo_ard_s
bonanzas	19	4	311	3	bonanzas
boyards	13	39	932	3	boyard_s
canards	10	3	1120	3	canard_s
contras	9	30	1562	3	contr_as
cowards	13	3	961	3	coward_s
czardas	19	3	467	3	_czardas
dotards	9	3	725	3	dotard_s
gonadal	9	5	652	3	gona_dal
gonads	8	45	1173	3	gona_d_s
hoards	10	49	1262	3	ho_ard_s
holards	11	4	843	3	holard_s
hondas	10	3	1335	3	hon__das
innards	8	3	715	3	innard_s
kinaras	11	5	912	3	kinar_as
madras	9	43	1643	3	m__adras
malarias	10	3	1377	3	malarias
mananas	9	34	1473	3	mana_nas
mansards	11	4	801	3	mansard_s
mantras	9	38	1586	3	mantr_as
manwards	14	4	761	3	manward_s
maras	7	54	4330	3	m__ar_as
markas	12	47	1701	3	m__arkas
mazards	19	3	770	3	mazard_s
menads	9	55	1438	3	mena_d_s
minarets	10	4	884	3	minarets
minorcas	12	4	597	3	minorcas
mojarra	16	4	251	3	mojarra_
molars	8	55	1732	3	molar__s
monachal	15	4	571	3	monachal
monacids	13	13	751	3	monacids
monad	8	55	1947	3	mona_d__
monadic	12	6	888	3	mona_dic
monadism	13	4	802	3	mona_dism
monandry	14	4	323	3	monandry
monarch	14	4	595	3	monar_ch
monarchal	16	4	398	3	monarchal
monarchy	18	4	360	3	monarchy
monas	7	47	3215	3	mon___as
monaural	10	4	621	3	monaural
monaxial	17	4	596	3	monaxial
monaxons	17	4	481	3	monaxons
mondes	9	43	2235	3	mon__des
mondos	9	52	1733	3	mon__dos
moneran	9	3	1111	3	moner_an
monerans	10	3	1035	3	monerans
mongrels	11	3	533	3	mongrels
monurons	10	3	709	3	monurons
moonwards	15	7	420	3	moonward_s
moras	7	64	3878	3	mo__r_as
nadas	6	63	2081	3	__na_das
nards	6	59	2846	3	__nard_s
nonarts	7	3	1130	3	nonar_ts
onwards	11	3	717	3	_onward_s
panadas	10	33	1221	3	pana_das
poniards	11	4	582	3	poniard_s
posadas	10	3	719	3	posa_das
sonarman	10	4	556	3	sonarman
sonars	6	48	1897	3	sonar__s
sonatas	7	5	1029	3	sona_tas
towards	11	3	878	3	toward_s
zenaidas	18	51	366	3	zenaidas

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	146162	0.423	422437.4
2	DLD Change Limit	146162	69	7.936	18417.6
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	8.375	21336.2