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

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

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.

63 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
missels	9	46	1481	(None)
missals	9	39	1442	1	missals
missel	8	52	1652	1	missel_
misses	8	51	3087	1	misse_s
missets	9	45	1657	1	missets
mussels	9	41	984	1	mussels
diesels	8	42	914	2	diesels
dispels	10	3	1050	2	dispels
disses	7	52	2596	2	disse_s
dossels	8	55	1160	2	dossels
hassels	10	43	1101	2	hassels
hirsels	10	12	834	2	hirsels
hisself	13	3	591	2	hisself
hissers	10	41	1231	2	hissers
hisses	9	47	1935	2	hisse_s
isseis	6	3	856	2	_isseis
kissers	11	42	1129	2	kissers
kisses	10	42	1733	2	kisse_s
listels	7	42	1243	2	listels
masses	8	50	2871	2	masse_s
messes	8	49	2434	2	messe_s
mioses	8	43	1885	2	miose_s
misdeals	11	4	722	2	misdeals
misers	8	50	2570	2	mi_sers
mises	7	47	4056	2	mi_se_s
miskals	13	36	976	2	miskals
mispens	11	3	1107	2	mispens
misrely	12	31	960	2	misrely
missal	8	43	1490	2	missal_
missays	12	40	1025	2	missays
misseat	9	36	1723	2	misseat
misseats	10	40	1168	2	misseats
missed	9	44	2360	2	misse_d
missend	10	44	1137	2	missend
missends	11	36	823	2	missends
missense	10	3	796	2	missense
missent	9	43	1871	2	missent
misset	8	50	2815	2	misse_t
missies	9	34	2398	2	missies
missile	9	28	1540	2	missile
missiles	10	30	1508	2	missiles
missis	8	44	1750	2	miss_is
misspell	12	4	430	2	misspell
misspells	13	4	376	2	misspells
misspelt	12	4	727	2	misspelt
missteps	12	15	614	2	missteps
missus	8	53	1229	2	miss_us
misters	9	39	2750	2	misters
misusers	10	34	807	2	misusers
misuses	9	32	1602	2	misuse_s
morsels	9	41	1265	2	morsels
mossers	9	41	1619	2	mossers
mosses	8	55	2768	2	mosse_s
mussel	8	34	1290	2	mussel_
musses	8	46	2478	2	musse_s
passels	9	39	1302	2	passels
pissers	9	50	1475	2	pissers
pisses	8	45	2508	2	pisse_s
sisses	6	45	2060	2	sisse_s
tassels	7	45	1085	2	tassels
tinsels	7	3	837	2	tinsels
vessels	10	3	593	2	vessels
wisses	9	46	1960	2	wisse_s

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	107671	0.250	714764.0
2	DLD Change Limit	107671	63	6.766	15913.5
3	Display Results	63	63	0.046	1369.6
	(SQL Overall)	178691	63	7.062	25303.2