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

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

97 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
skell	9	49	1583	(None)
sell	4	58	4061	1	s_ell
shell	8	44	2412	1	shell
skells	10	50	1378	1	skells
skelm	11	42	1129	1	skelm
skelp	11	42	1142	1	skelp
skill	9	43	1672	1	skill
skull	9	48	1203	1	skull
smell	7	49	1623	1	smell
snell	5	45	1730	1	snell
spell	7	50	2030	1	spell
swell	8	48	1598	1	swell
akela	9	3	1134	2	akela
bell	6	62	3718	2	_bell
cell	6	50	3172	2	_cell
dell	5	69	3820	2	_dell
dwell	9	51	985	2	dwell
ell	3	67	3568	2	__ell
fell	7	68	3307	2	_fell
hell	7	56	3789	2	_hell
jell	11	71	2587	2	_jell
keel	8	57	2947	2	_keel
kelly	12	46	1702	2	_kelly
kelp	10	53	2280	2	_kelp
kelt	8	53	4319	2	_kelt
kill	8	55	3317	2	_kill
knell	9	42	1092	2	knell
kvell	12	43	669	2	kvell
mell	6	49	3561	2	_mell
quell	14	43	1143	2	quell
sall	4	45	4468	2	s_all
scall	7	44	2037	2	scall
scull	7	53	1576	2	scull
seal	4	56	5437	2	s_eal
seel	4	50	4298	2	s_eel
seels	5	56	3282	2	seels
seely	8	45	2263	2	seely
sel	3	82	5332	2	s_e_l
self	7	51	3829	2	s_elf
selle	5	44	2831	2	s_elle
sells	5	51	3443	2	s_ells
sels	4	63	4598	2	s_els
shall	8	50	2405	2	shall
sheal	8	49	2770	2	sheal
shelf	11	52	2111	2	shelf
shells	9	43	1952	2	shells
shelly	12	44	1447	2	shelly
sheol	8	43	1837	2	sheol
shill	8	53	2533	2	shill
sill	4	55	4515	2	s_ill
skald	10	42	1017	2	skald
skean	9	44	1562	2	skean
skee	8	54	3147	2	ske_e
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	ske_g
skegs	10	50	1123	2	skegs
skein	9	48	1441	2	skein
skellum	13	4	385	2	skellum
skelms	12	36	802	2	skelms
skelps	12	40	792	2	skelps
skene	9	61	1812	2	skene
skep	10	52	1935	2	ske_p
skeps	11	56	1425	2	skeps
skew	11	62	1876	2	ske_w
skews	12	54	1380	2	skews
skills	10	43	1392	2	skills
skirl	9	60	1291	2	skirl
skoal	9	38	1146	2	skoal
skulk	8	47	962	2	skulk
skulls	10	42	964	2	skulls
small	7	40	1626	2	small
smells	8	39	1474	2	smells
smelly	11	41	1036	2	smelly
smelt	7	47	2678	2	smelt
snells	6	46	1420	2	snells
spall	7	49	1930	2	spall
speel	7	44	2076	2	speel
speil	7	56	1864	2	speil
spells	8	46	1768	2	spells
spelt	7	54	3019	2	spelt
spill	7	48	2116	2	spill
stall	5	47	2235	2	stall
steal	5	61	2547	2	steal
steel	5	57	2199	2	steel
stela	5	40	1904	2	stela
stele	5	50	2684	2	stele
stella	6	36	1297	2	stella
still	5	49	2208	2	still
stull	5	49	1627	2	stull
swells	9	39	1398	2	swells
swill	8	34	1737	2	swill
tell	4	49	3470	2	_tell
well	7	58	3204	2	_well
yell	7	60	2832	2	_yell

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.296	603685.8
2	DLD Change Limit	53800	97	1.390	38705.0
3	Display Results	97	97	0.016	6062.5
	(SQL Overall)	178691	97	1.702	104988.8