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

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

82 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
skiey	12	50	1289	(None)
skied	10	44	1775	1	skied
skier	9	51	1959	1	skier
skies	9	50	2683	1	skies
skyey	15	53	722	1	skyey
dikey	13	51	1642	2	dikey
key	10	58	3333	2	_k_ey
kief	11	71	2840	2	_kief
kier	8	65	2680	2	_kier
shied	9	61	2549	2	shied
shiel	8	110	2377	2	shiel
shier	8	54	2894	2	shier
shies	8	61	3655	2	shies
shily	11	52	2201	2	shily
shiny	11	51	2214	2	shiny
sike	8	71	3878	2	sike_
siker	9	53	2603	2	siker
sikes	9	62	3608	2	sikes
sizy	16	48	1639	2	s_izy
skee	8	54	3147	2	sk_ee
skeed	10	50	1898	2	skeed
skeen	9	48	1740	2	skeen
skees	9	50	2312	2	skees
skeet	9	54	2918	2	skeet
skeg	9	53	1616	2	sk_eg
skein	9	48	1441	2	skein
skep	10	52	1935	2	sk_ep
skew	11	62	1876	2	sk_ew
ski	7	49	2569	2	ski__
skid	9	57	2092	2	ski_d
skiddy	15	3	363	2	skiddy
skids	10	46	1532	2	skids
skiers	10	47	1370	2	skiers
skiff	15	36	1280	2	skiff
skill	9	43	1672	2	skill
skim	10	53	2251	2	ski_m
skimo	11	63	1254	2	skimo
skimp	13	54	1132	2	skimp
skimpy	17	47	572	2	skimpy
skims	11	45	1719	2	skims
skin	8	59	2753	2	ski_n
skink	8	59	1685	2	skink
skinny	13	45	661	2	skinny
skins	9	47	2346	2	skins
skint	9	56	2922	2	skint
skip	10	54	2175	2	ski_p
skips	11	56	1660	2	skips
skirl	9	60	1291	2	skirl
skirr	9	48	1054	2	skirr
skirt	9	56	2466	2	skirt
skis	8	48	2529	2	ski_s
skit	8	54	3753	2	ski_t
skite	9	51	2005	2	skite
skited	11	43	1348	2	skited
skites	10	44	1804	2	skites
skits	9	47	2186	2	skits
skive	12	46	1411	2	skive
skived	14	42	989	2	skived
skiver	13	46	1210	2	skiver
skives	13	41	1394	2	skives
skivvy	19	3	278	2	skivvy
sky	10	64	2099	2	sk__y
skyed	13	52	992	2	skyed
slier	5	48	2724	2	slier
slily	8	58	2003	2	slily
slimy	10	54	1742	2	slimy
smiley	11	40	1230	2	smiley
sooey	8	45	2243	2	sooey
spicey	13	44	1423	2	spicey
spicy	12	54	1771	2	spicy
spied	8	54	2771	2	spied
spiel	7	46	2391	2	spiel
spier	7	57	2803	2	spier
spies	7	60	3762	2	spies
spikey	15	54	1133	2	spikey
spiky	14	60	1411	2	spiky
spiny	10	49	2130	2	spiny
spiry	10	50	1735	2	spiry
stey	7	62	2441	2	s_tey
stied	6	57	2303	2	stied
sties	5	51	3298	2	sties
stimy	10	51	1474	2	stimy

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	82	1.626	33087.3
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	1.749	102167.5