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

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

84 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
shrines	10	46	1869	(None)
serines	7	42	2954	1	serines
shines	9	50	2891	1	sh_ines
shrikes	14	44	1239	1	shrikes
shrine	9	49	2005	1	shrine_
shrined	11	41	1241	1	shrined
shrinks	14	39	791	1	shrinks
shrives	13	44	1617	1	shrives
brines	8	50	2885	2	_brines
chaines	12	45	1873	2	chaines
chines	11	50	2917	2	ch_ines
chorines	13	29	1725	2	chorines
enshrines	12	4	658	2	enshrines
eserines	8	4	1374	2	eserines
inshrines	12	4	653	2	inshrines
marines	9	39	2803	2	marines
murines	9	37	1822	2	murines
purines	9	44	2077	2	purines
sabines	9	43	1848	2	sabines
salines	7	40	2941	2	salines
sardines	9	28	1558	2	sardines
sarins	6	39	3262	2	sarin_s
savines	10	44	1763	2	savines
scribes	11	37	1320	2	scribes
scries	8	52	2682	2	scri_es
scrives	12	44	1427	2	scrives
seines	6	50	2990	2	s_eines
serenes	7	32	2290	2	serenes
series	6	45	4097	2	seri_es
serine	6	54	3267	2	serine_
serins	6	40	2967	2	serin_s
shies	8	61	3655	2	sh_i_es
shine	8	55	3309	2	sh_ine_
shined	10	46	2078	2	sh_ined
shiner	9	38	2087	2	sh_iner
shiners	10	40	1594	2	sh_iners
shins	8	51	3104	2	sh_in_s
shires	9	52	2557	2	sh_ires
shives	12	49	2141	2	sh_ives
shorings	12	26	948	2	shorings
shriek	13	42	1110	2	shri_ek
shrieks	14	37	767	2	shrieks
shrieves	14	29	709	2	shrieves
shrifts	13	3	596	2	shrifts
shrike	13	45	1324	2	shrike_
shrills	10	38	993	2	shrills
shrimps	14	51	675	2	shrimps
shrink	13	45	1173	2	shrin_k
shrinker	15	23	636	2	shrinker
shrinkers	16	20	538	2	shrinkers
shris	8	42	2145	2	shri__s
shrive	12	52	1695	2	shrive_
shrived	14	47	1218	2	shrived
shrivel	13	47	940	2	shrivel
shrivels	14	37	644	2	shrivels
shriven	13	37	965	2	shriven
shriver	13	47	1219	2	shriver
shrivers	14	41	910	2	shrivers
sines	5	59	5482	2	s__ines
sordines	9	24	1407	2	sordines
sorings	8	38	1725	2	sorings
sorites	7	38	2524	2	sorites
sozines	16	6	1126	2	sozines
spines	8	51	3203	2	s_pines
splines	9	47	1889	2	splines
springes	11	40	1403	2	springes
springs	10	44	1592	2	springs
sprints	9	41	1377	2	sprints
sprites	9	42	2033	2	sprites
strides	8	45	2039	2	strides
strifes	10	47	1658	2	strifes
strikes	11	47	1909	2	strikes
strings	8	46	1713	2	strings
stripes	9	53	2057	2	stripes
strives	10	41	1937	2	strives
supines	9	42	1638	2	supines
syringes	12	28	1021	2	syringes
syrinxes	18	29	442	2	syrinxes
theines	10	40	1323	2	theines
thrives	13	46	1171	2	thrives
thrones	10	57	1584	2	thrones
trines	6	41	3256	2	_trines
urines	6	47	2412	2	_urines
whines	12	51	2010	2	wh_ines

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.780	229091.0
2	DLD Change Limit	107671	84	6.986	15412.4
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	7.796	22920.9