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

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

67 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
mispenned	14	4	541	(None)
dispended	14	14	782	2	dispended
dispensed	13	15	877	2	dispensed
misplanned	15	8	387	2	misplanned
mistended	13	13	733	2	mistended
crispened	14	4	361	3	crispe_ned
discerned	13	4	786	3	discerned
dispelled	13	11	757	3	dispelled
dispend	11	28	941	3	dispe_n_d
dispense	11	12	978	3	dispense_
dispenser	12	12	832	3	dispenser
dispenses	12	12	1076	3	dispenses
dispersed	13	11	978	3	dispersed
dissented	11	9	972	3	dissented
distended	12	15	792	3	distended
impended	14	3	595	3	_impended
inspanned	12	4	285	3	inspanned
lippened	13	25	522	3	lippe_ned
listened	9	16	881	3	liste_ned
mildened	12	3	577	3	milde_ned
misatoned	12	4	669	3	misatoned
miscoined	14	4	844	3	miscoined
misdeed	11	32	1105	3	misde__ed
misdeemed	15	4	460	3	misdeemed
misdefined	17	4	342	3	misdefined
misenter	10	3	1083	3	mis_enter
misfeed	13	38	968	3	misfe__ed
misjoined	19	4	545	3	misjoined
misleared	12	7	745	3	misleared
mislearned	13	8	348	3	mislearned
mispaged	14	3	824	3	misp_aged
mispainted	15	4	501	3	mispainted
misparsed	14	4	625	3	misparsed
misparted	14	3	726	3	misparted
mispen	10	3	1217	3	mispe_n__
mispenning	15	4	577	3	mispenning
mispens	11	3	1107	3	mispe_n_s
misplaced	16	4	625	3	misplaced
misplanted	15	6	544	3	misplanted
misplayed	17	4	530	3	misplayed
mispleaded	16	4	413	3	mispleaded
mispled	12	3	1046	3	misp__led
mispointed	15	4	557	3	mispointed
mispoised	14	4	680	3	mispoised
mispriced	16	4	642	3	mispriced
misprinted	15	4	598	3	misprinted
misprized	23	4	660	3	misprized
misrelied	12	4	724	3	misrelied
misrender	12	8	629	3	misrender
misseated	12	6	1011	3	misseated
missend	10	44	1137	3	misse_n_d
missense	10	3	796	3	missense_
missenses	11	4	803	3	missenses
missioned	12	4	860	3	missioned
misspelled	15	4	350	3	misspelled
misspend	13	4	524	3	misspe_n_d
mistend	10	38	1252	3	miste_n_d
mistermed	14	3	836	3	mistermed
mistuned	11	5	772	3	mis_tuned
mittened	11	3	636	3	mitte_ned
moistened	12	4	600	3	moiste_ned
penned	9	42	1761	3	___penned
ripened	10	3	820	3	ri_pe_ned
spanned	10	41	1122	3	__spanned
speaned	10	34	1152	3	__speaned
suspended	13	10	451	3	suspended
unpenned	11	3	754	3	_unpenned

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	148641	0.420	425454.8
2	DLD Change Limit	148641	67	6.643	22375.6
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	7.093	25192.6