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

Here are the results of your fuzzy-string dictionary search for “snells” 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
snells	6	46	1420	(None)
knells	10	43	925	1	knells
sells	5	51	3443	1	s_ells
shells	9	43	1952	1	shells
skells	10	50	1378	1	skells
smells	8	39	1474	1	smells
snell	5	45	1730	1	snell_
spells	8	46	1768	1	spells
swells	9	39	1398	1	swells
aneles	6	46	2629	2	aneles
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
kneels	10	40	893	2	kneels
knell	9	42	1092	2	knell_
knolls	10	36	741	2	knolls
kvells	13	34	661	2	kvells
mells	7	50	3133	2	_mells
nelly	8	46	1881	2	_nelly
nills	5	49	2667	2	_nills
nulls	5	50	1998	2	_nulls
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
skell	9	49	1583	2	skell_
skelms	12	36	802	2	skelms
skelps	12	40	792	2	skelps
skills	10	43	1392	2	skills
skulls	10	42	964	2	skulls
smalls	8	45	1412	2	smalls
smell	7	49	1623	2	smell_
smelly	11	41	1036	2	smelly
smelts	8	54	1277	2	smelts
snails	6	48	1665	2	snails
snarls	6	40	1687	2	snarls
sneaks	10	43	1249	2	sneaks
sneaps	8	45	1086	2	sneaps
snecks	12	44	1003	2	snecks
sneds	6	57	1535	2	sne_ds
sneers	6	40	1617	2	sneers
snelled	8	33	1304	2	snelled
sneller	7	35	1284	2	sneller
snellest	8	3	949	2	snellest
snools	6	57	1588	2	snools
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
unsells	7	32	1077	2	unsells
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.390	458182.1
2	DLD Change Limit	82551	82	2.376	34743.7
3	Display Results	82	82	0.013	6307.7
	(SQL Overall)	178691	82	2.779	64300.5