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

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

77 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
misjoined	19	4	545	(None)
disjoined	18	4	583	1	disjoined
miscoined	14	4	844	1	miscoined
disjointed	19	4	483	2	disjointed
misjoin	16	3	769	2	misjoin__
misjoinder	20	5	270	2	misjoinder
misjoins	17	3	691	2	misjoin_s
mispointed	15	4	557	2	mispointed
mispoised	14	4	680	2	mispoised
missioned	12	4	860	2	missioned
adjoined	17	4	351	3	_adjoined
cojoined	18	5	629	3	_cojoined
conjoined	19	6	546	3	conjoined
disdained	12	4	602	3	disdained
disjoin	15	4	764	3	disjoin__
disjoins	16	4	762	3	disjoin_s
disjoint	16	4	923	3	disjoin_t
disjoints	17	4	547	3	disjoints
disowned	13	3	643	3	dis_owned
distained	11	3	960	3	distained
enjoined	16	21	572	3	_enjoined
fissioned	13	4	552	3	fissioned
joined	14	46	1307	3	___joined
masoned	10	3	980	3	mas_o_ned
misaimed	13	3	809	3	mis_aimed
misaligned	14	4	358	3	misaligned
misatoned	12	4	669	3	misatoned
misbind	12	5	827	3	mis_bin_d
misbound	13	4	493	3	misboun_d
miscited	13	3	1042	3	mis_cited
miscoded	14	3	798	3	misco_ded
miscoin	11	3	1143	3	miscoin__
miscoins	12	3	1108	3	miscoin_s
miscooked	18	4	469	3	miscooked
miscopied	16	4	717	3	miscopied
miscounted	15	4	606	3	miscounted
misdefined	17	4	342	3	misdefined
misdoing	12	3	880	3	misdoin_g
misdoings	13	4	442	3	misdoings
misdone	10	3	1086	3	misdo_ne_
misedited	13	4	678	3	misedited
misfiled	14	27	865	3	mis_filed
misfired	14	23	854	3	mis_fired
misformed	17	4	524	3	misformed
misguided	14	14	465	3	misguided
misjoinders	21	5	234	3	misjoinders
misjoining	20	8	529	3	misjoining
misjudged	21	4	256	3	misjudged
misliked	15	31	951	3	mis_liked
mislived	14	32	878	3	mis_lived
mislodged	14	4	384	3	mislodged
mismoved	16	3	565	3	mismo_ved
mispainted	15	4	501	3	mispainted
mispenned	14	4	541	3	mispenned
mispoint	12	10	1236	3	mispoin_t
mispoints	13	10	663	3	mispoints
mispoise	12	4	826	3	mispoise_
mispoises	13	4	835	3	mispoises
mispriced	16	4	642	3	mispriced
misprinted	15	4	598	3	misprinted
misprized	23	4	660	3	misprized
misraised	12	6	831	3	misraised
misrouted	12	4	730	3	misrouted
missioner	11	4	788	3	missioner
missorted	12	4	703	3	missorted
missound	11	4	511	3	missoun_d
missounded	14	4	302	3	missounded
missuited	12	5	702	3	missuited
mistimed	13	3	912	3	mis_timed
mistrained	13	4	758	3	mistrained
mistuned	11	5	772	3	mis_tuned
misworded	16	4	423	3	misworded
misyoked	18	3	462	3	misyo_ked
rejoined	16	31	859	3	_rejoined
subjoined	19	4	423	3	subjoined
unjoined	16	24	844	3	_unjoined
visioned	12	4	701	3	visio_ned

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	148641	0.420	425454.8
2	DLD Change Limit	148641	77	6.516	22811.7
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	6.982	25593.1