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

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

78 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
missis	8	44	1750	(None)
miosis	8	36	1516	1	miosis
misses	8	51	3087	1	misses
missies	9	34	2398	1	missies
missus	8	53	1229	1	missus
cassis	8	48	1885	2	cassis
cissies	9	41	1615	2	cissies
diesis	7	40	1349	2	diesis
disses	7	52	2596	2	disses
hisses	9	47	1935	2	hisses
hissies	10	39	1582	2	hissies
isseis	6	3	856	2	_isseis
kisses	10	42	1733	2	kisses
lassis	6	52	1670	2	lassis
massas	8	51	1646	2	massas
masses	8	50	2871	2	masses
massif	11	4	1253	2	massif
massifs	12	3	774	2	massifs
meiosis	9	3	902	2	meiosis
messes	8	49	2434	2	messes
miasms	10	9	738	2	miasms
midis	8	59	2340	2	mi_dis
midsts	9	55	1005	2	midsts
mimesis	11	3	732	2	mimesis
minis	7	54	3298	2	mi_nis
mioses	8	43	1885	2	mioses
misaim	10	3	1185	2	misaim
misaims	11	3	1011	2	misaims
misbias	11	3	907	2	misbias
misdid	10	5	1056	2	misdid
misers	8	50	2570	2	misers
mises	7	47	4056	2	mi_ses
misfit	11	28	1383	2	misfit
misfits	12	27	966	2	misfits
mishit	11	26	1819	2	mishit
mishits	12	25	1308	2	mishits
mislie	8	32	1915	2	mislie
mislies	9	29	2228	2	mislies
mislit	8	30	1969	2	mislit
misos	7	65	2329	2	mi_sos
miss	6	53	3941	2	mi_s_s
missaid	10	3	1029	2	missaid
missal	8	43	1490	2	missal
missals	9	39	1442	2	missals
missay	11	41	1214	2	missay
missays	12	40	1025	2	missays
missed	9	44	2360	2	missed
missel	8	52	1652	2	missel
missels	9	46	1481	2	missels
misset	8	50	2815	2	misset
missets	9	45	1657	2	missets
missile	9	28	1540	2	missile
missiles	10	30	1508	2	missiles
missing	10	36	1907	2	missing
mission	9	3	1274	2	mission
missions	10	3	1190	2	missions
missises	10	35	1369	2	missises
missive	12	24	1314	2	missive
missives	13	32	1284	2	missives
missuit	9	9	1130	2	missuit
missuits	10	7	802	2	missuits
missy	10	56	1756	2	miss_y
mists	7	66	3390	2	mi_sts
misuses	9	32	1602	2	misuses
mitis	7	54	2598	2	mi_tis
mitosis	9	3	963	2	mitosis
mosses	8	55	2768	2	mosses
musses	8	46	2478	2	musses
myasis	11	40	1046	2	myasis
myiasis	12	4	548	2	myiasis
myosis	11	40	1255	2	myosis
niseis	6	35	1202	2	niseis
pisses	8	45	2508	2	pisses
rishis	9	3	1245	2	rishis
sisses	6	45	2060	2	sisses
sissies	7	37	1660	2	sissies
tussis	6	37	995	2	tussis
wisses	9	46	1960	2	wisses

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	78	2.966	27832.4
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	3.125	57181.1