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

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

90 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
missies	9	34	2398	(None)
cissies	9	41	1615	1	cissies
hissies	10	39	1582	1	hissies
mislies	9	29	2228	1	mislies
misses	8	51	3087	1	miss_es
missiles	10	30	1508	1	missiles
missis	8	44	1750	1	missi_s
missises	10	35	1369	1	missises
missives	13	32	1284	1	missives
sissies	7	37	1660	1	sissies
bossies	9	41	1683	2	bossies
dassies	8	44	1866	2	dassies
disses	7	52	2596	2	diss_es
gipsies	10	3	990	2	gipsies
gussies	8	28	1330	2	gussies
hisses	9	47	1935	2	hiss_es
hissier	10	34	1050	2	hissier
hissiest	11	29	1109	2	hissiest
hussies	10	32	1329	2	hussies
isseis	6	3	856	2	_isseis
issues	6	4	880	2	_issues
kisses	10	42	1733	2	kiss_es
lassies	7	44	2010	2	lassies
mashies	12	3	1825	2	mashies
masses	8	50	2871	2	mass_es
massier	9	36	1522	2	massier
massiest	10	33	1442	2	massiest
massifs	12	3	774	2	massifs
messes	8	49	2434	2	mess_es
messier	9	34	1292	2	messier
messiest	10	31	1242	2	messiest
middies	11	31	1615	2	middies
minnies	9	36	1736	2	minnies
mioses	8	43	1885	2	mios_es
miosis	8	36	1516	2	miosi_s
misaims	11	3	1011	2	misaims
misbias	11	3	908	2	misbias
miscites	12	3	1378	2	miscites
miscues	11	3	1239	2	miscues
misdoes	10	3	1249	2	misdoes
miseries	10	3	2040	2	miseries
mises	7	47	4056	2	mi_s_es
misfiles	13	31	1098	2	misfiles
misfires	13	22	1058	2	misfires
misfits	12	27	966	2	misfits
misgives	14	32	929	2	misgives
mishits	12	25	1308	2	mishits
mislie	8	32	1915	2	mislie_
mislikes	14	33	1183	2	mislikes
mislives	13	29	1215	2	mislives
missals	9	39	1442	2	missals
missays	12	40	1025	2	missays
missed	9	44	2360	2	miss_ed
missel	8	52	1652	2	miss_el
missels	9	46	1481	2	missels
misset	8	50	2815	2	miss_et
missets	9	45	1657	2	missets
missile	9	28	1540	2	missile
missing	10	36	1907	2	missing
mission	9	3	1274	2	mission
missions	10	3	1190	2	missions
missive	12	24	1314	2	missive
misstep	11	15	846	2	misstep
missteps	12	15	614	2	missteps
missuits	10	7	802	2	missuits
missus	8	53	1229	2	miss_us
missuses	10	30	968	2	missuses
mistier	9	34	1871	2	mistier
mistiest	10	30	1831	2	mistiest
mistimes	12	6	1261	2	mistimes
misuses	9	32	1602	2	misuses
mitises	9	3	1554	2	mitises
mosses	8	55	2768	2	moss_es
mossier	9	44	1381	2	mossier
mossiest	10	31	1244	2	mossiest
muskies	13	36	1467	2	muskies
musses	8	46	2478	2	muss_es
mussier	9	33	1436	2	mussier
mussiest	10	31	1293	2	mussiest
pisses	8	45	2508	2	piss_es
prissies	10	17	1200	2	prissies
pussies	9	36	1569	2	pussies
sassies	7	47	1926	2	sassies
sisses	6	45	2060	2	siss_es
sissier	7	37	1136	2	sissier
sissiest	8	34	1235	2	sissiest
tassies	7	49	1893	2	tassies
tissues	7	3	746	2	tissues
wisses	9	46	1960	2	wiss_es
wussies	10	34	1108	2	wussies

Search took 4 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.486	367677.0
2	DLD Change Limit	107671	90	3.220	33438.2
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	3.736	47829.5