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

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

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
shamisen	13	4	427	(None)
samisen	9	3	767	1	s_amisen
shamisens	14	4	260	1	shamisens
chamise	14	36	1285	2	chamise_
chamises	15	35	1331	2	chamises
samisens	10	3	548	2	s_amisens
shamuses	13	3	615	2	shamuses
arisen	6	53	1679	3	__arisen
camise	10	33	1963	3	_camise_
camises	11	42	1846	3	_camises
chaise	11	49	1641	3	cha_ise_
chaises	12	43	1749	3	cha_ises
chamisa	14	32	885	3	chamis_a
chamisas	15	31	781	3	chamisas
chamiso	14	34	865	3	chamis_o
chamisos	15	30	742	3	chamisos
chamoised	17	33	532	3	chamoised
chamoises	16	32	793	3	chamoises
chemise	14	32	1150	3	chemise_
chemises	15	32	1198	3	chemises
hausen	9	6	1038	3	_ha_usen
khamseen	17	4	181	3	khamseen
khamsin	16	4	398	3	kham_sin
pharisee	13	4	760	3	pharisee
samiel	8	3	1333	3	s_ami_el
samite	8	30	2060	3	s_amite_
samites	9	31	1871	3	s_amites
sarsen	6	3	1423	3	s_a_rsen
seamen	8	45	1856	3	seam__en
seamier	9	31	1463	3	seami_er
seamiest	10	27	1542	3	seamiest
semises	9	39	1655	3	s_emises
shadier	11	31	1115	3	shadi_er
shadiest	12	17	1128	3	shadiest
shagreen	12	4	344	3	shagreen
shairn	9	26	906	3	sha_i_rn
shaitan	10	3	689	3	sha_itan
shaken	13	41	1361	3	sha__ken
shakier	14	34	1115	3	shaki_er
shakiest	15	19	1094	3	shakiest
shalier	10	31	1642	3	shali_er
shaliest	11	14	1506	3	shaliest
shaman	11	33	1428	3	sham__an
shamas	11	37	1794	3	shamas__
shamble	14	14	926	3	shamble_
shambled	16	15	615	3	shambled
shambles	15	15	904	3	shambles
shame	10	57	2670	3	sham__e_
shamed	12	51	2021	3	sham__ed
shames	11	47	2622	3	sham__es
shaming	13	30	1674	3	shami_ng
shammed	15	39	1142	3	sham_med
shammer	14	46	1314	3	sham_mer
shammes	14	43	1283	3	sham_mes
shammied	16	26	554	3	shammied
shammies	15	25	969	3	shammies
shamois	12	32	1042	3	shamois__
shamos	11	42	1698	3	shamos__
shamosim	15	4	475	3	shamosim
shamoyed	17	4	404	3	shamoyed
shams	10	58	2941	3	sham_s__
shamus	11	41	1281	3	shamus__
shapen	11	44	1465	3	sha__pen
sharpen	12	38	972	3	sha_rpen
shaven	12	42	1330	3	sha__ven
shavie	12	43	1242	3	shavi_e_
shavies	13	42	1321	3	shavi_es
shriven	13	37	965	3	sh_riven
siamese	9	3	650	3	siamese_
siameses	10	3	640	3	siameses
stamen	8	41	1594	3	stam__en
surmise	9	3	1108	3	surmise_
surmised	11	3	686	3	surmised
surmiser	10	3	676	3	surmiser
surmises	10	3	1064	3	surmises
swamies	12	37	1206	3	swami_es
swamis	11	42	1229	3	swamis__
tamises	9	27	1597	3	_tamises

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	146162	0.420	425454.8
2	DLD Change Limit	146162	78	7.233	20207.7
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	7.686	23248.9