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

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

60 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
miserere	10	4	927	(None)
misereres	11	4	818	1	misereres
miterer	9	25	1133	2	miterer_
miterers	10	21	968	2	miterers
discrete	11	4	1028	3	discrete
merer	7	51	2623	3	m__erer_
mesomere	12	4	719	3	mesomere
misaver	12	4	981	3	misaver_
misavers	13	4	806	3	misavers
miscreate	13	4	889	3	miscreate
misdoer	10	4	863	3	misdoer_
misdoers	11	3	710	3	misdoers
misdrew	13	3	583	3	misdre_w
misdrive	14	4	668	3	misdrive
misdrove	14	4	543	3	misdrove
misease	9	27	1304	3	mise_ase
misenter	10	3	1083	3	misenter_
misentered	13	4	591	3	misentered
misenters	11	3	953	3	misenters
misentry	13	4	577	3	misentry
miser	7	54	3040	3	mis__er_
miserable	13	4	965	3	miserable
miseries	10	3	2040	3	miseries
miserly	12	32	982	3	miser_ly
misers	8	50	2570	3	mis__ers
misery	11	41	1354	3	mis__ery
misevent	13	4	922	3	misevent
misfire	12	22	989	3	mis_fire
misframe	15	4	697	3	misframe
misgrade	12	4	750	3	misgrade
misgrew	13	3	552	3	misgre_w
misorder	11	4	728	3	misorder_
misordered	14	4	379	3	misordered
misorders	12	4	588	3	misorders
misprice	14	4	813	3	misprice
misprize	21	4	754	3	misprize
misrate	9	13	1914	3	mis_rate
misread	10	33	972	3	mis_read
misrefer	13	4	610	3	mis_refer
misrefers	14	4	536	3	misrefers
misrely	12	31	961	3	mis_rely
misrule	9	3	935	3	mis_rule
missteer	10	3	722	3	missteer
mister	8	47	2856	3	mis_ter_
misterm	11	43	1451	3	mis_term
misters	9	39	2751	3	mis_ters
mistier	9	34	1871	3	mistier_
mistrace	12	3	1264	3	mistrace
mistreat	10	3	1311	3	mistreat
mistress	10	3	1070	3	mistress
misuser	9	32	1044	3	misuser_
misusers	10	34	808	3	misusers
miswrite	13	4	892	3	miswrite
miswrote	13	4	618	3	miswrote
mitered	10	32	1323	3	mitere_d
serene	6	35	2235	3	__serene
serer	5	59	3551	3	__serer_
severe	9	40	1608	3	__severe
tigereye	12	4	334	3	tigereye
wiseacre	13	4	300	3	wiseacre

Search took 8 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.420	425454.8
2	DLD Change Limit	146162	60	6.703	21805.5
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	7.156	24970.8