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

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

46 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
hymnary	18	4	303	(None)
hymnal	14	3	491	2	hymna_l
hymnals	15	4	352	2	hymnals
hymnody	19	4	236	2	hymnody
ambary	13	40	1054	3	_ambary
binary	11	3	1222	3	_binary
canary	11	3	1469	3	_canary
cymar	12	57	1126	3	cym_ar_
cymars	13	59	915	3	cym_ars
denary	10	53	1686	3	_denary
granary	11	5	779	3	granary
gymnast	13	4	415	3	gymnast
hennery	13	3	530	3	hennery
henry	11	40	1447	3	h_en_ry
hoary	11	45	1676	3	h__oary
horary	12	3	1038	3	h_orary
humanly	15	4	568	3	humanly
hungry	13	3	497	3	h_ungry
hyena	11	8	1025	3	hyena__
hyenas	12	8	895	3	hyena_s
hymenal	15	4	518	3	hymena_l
hymn	12	3	1131	3	hymn___
hymnaries	17	5	431	3	hymnaries
hymned	15	3	532	3	hymn_ed
hymning	16	3	518	3	hymning
hymnist	15	4	663	3	hymnist
hymns	13	3	752	3	hymn__s
laminary	13	33	725	3	laminary
luminary	13	33	665	3	luminary
mammary	13	3	599	3	mammary
nary	7	69	3122	3	___nary
nummary	14	31	465	3	nummary
phyllary	19	4	323	3	phyllary
plenary	12	3	754	3	plenary
quinary	19	3	693	3	quinary
seminary	13	9	809	3	seminary
senary	9	37	1607	3	_senary
smeary	11	41	1080	3	_smeary
summary	14	29	735	3	summary
sympatry	18	4	312	3	sympatry
ternary	10	3	834	3	ternary
trinary	10	3	917	3	trinary
tympany	17	25	460	3	tympany
unary	8	3	1599	3	__unary
urinary	10	3	724	3	urinary
zonary	18	3	879	3	_zonary

Search took 7 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	46	6.280	21341.9
3	Display Results	46	46	0.016	2875.0
	(SQL Overall)	178691	46	6.452	27695.4