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

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

88 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
skells	10	50	1378	(None)
sells	5	51	3443	1	s_ells
shells	9	43	1952	1	shells
skell	9	49	1583	1	skell_
skelms	12	36	802	1	skelms
skelps	12	40	792	1	skelps
skills	10	43	1392	1	skills
skulls	10	42	964	1	skulls
smells	8	39	1474	1	smells
snells	6	46	1420	1	snells
spells	8	46	1768	1	spells
swells	9	39	1398	1	swells
akelas	10	3	1119	2	akelas
bells	7	64	3216	2	_bells
cells	7	54	2806	2	_cells
dells	6	66	3094	2	_dells
dwells	10	41	771	2	dwells
ells	4	64	3135	2	__ells
fells	8	53	2738	2	_fells
hells	8	50	3204	2	_hells
jells	12	55	2216	2	_jells
keels	9	46	2241	2	_keels
kelly	12	46	1702	2	_kelly
kelps	11	51	1642	2	_kelps
kelts	9	52	2263	2	_kelts
kills	9	45	2617	2	_kills
knells	10	43	925	2	knells
kvells	13	34	661	2	kvells
mells	7	50	3133	2	_mells
quells	15	35	970	2	quells
scalls	8	42	1820	2	scalls
sculls	8	46	1388	2	sculls
seals	5	48	3969	2	s_eals
seels	5	56	3282	2	s_eels
selfs	8	52	2024	2	s_elfs
sell	4	58	4061	2	s_ell_
selle	5	44	2831	2	s_elle
selles	6	44	2698	2	s_elles
sels	4	63	4598	2	s_e_ls
sheals	9	44	2064	2	sheals
shell	8	44	2412	2	shell_
shelly	12	44	1447	2	shelly
sheols	9	46	1416	2	sheols
shills	9	45	1961	2	shills
sills	5	51	3599	2	s_ills
skalds	11	43	783	2	skalds
skeans	10	45	1291	2	skeans
skeens	10	39	1291	2	skeens
skees	9	50	2312	2	ske_es
skeets	10	45	1325	2	skeets
skegs	10	50	1123	2	ske_gs
skeins	10	39	1190	2	skeins
skellum	13	4	385	2	skellum
skellums	14	4	300	2	skellums
skelm	11	42	1129	2	ske_lm
skelp	11	42	1142	2	ske_lp
skenes	10	46	1663	2	skenes
skeps	11	56	1425	2	ske_ps
skews	12	54	1380	2	ske_ws
skill	9	43	1672	2	skill_
skirls	10	44	982	2	skirls
skoals	10	43	824	2	skoals
skulks	9	42	724	2	skulks
skull	9	48	1203	2	skull_
smalls	8	45	1412	2	smalls
smell	7	49	1623	2	smell_
smelly	11	41	1036	2	smelly
smelts	8	54	1277	2	smelts
snell	5	45	1730	2	snell_
spalls	8	42	1734	2	spalls
speels	8	51	1639	2	speels
speils	8	41	1622	2	speils
spell	7	50	2030	2	spell_
spelts	8	46	1464	2	spelts
spills	8	47	1746	2	spills
stalls	6	40	1993	2	stalls
steals	6	40	2006	2	steals
steels	6	41	1798	2	steels
steles	6	37	2566	2	steles
stella	6	36	1297	2	stella
stellas	7	28	1304	2	stellas
stills	6	41	1857	2	stills
stulls	6	39	1298	2	stulls
swell	8	48	1598	2	swell_
swills	9	42	1336	2	swills
tells	5	58	2894	2	_tells
wells	8	54	2619	2	_wells
yells	8	58	2194	2	_yells

Search took 3 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	88	2.483	33246.5
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	2.642	67634.7