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

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

86 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
swells	9	39	1398	(None)
dwells	10	41	771	1	dwells
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
snells	6	46	1420	1	snells
spells	8	46	1768	1	spells
swell	8	48	1598	1	swell_
swills	9	42	1336	1	swills
wells	8	54	2619	1	_wells
bells	7	64	3216	2	_bells
cells	7	54	2806	2	_cells
dells	6	66	3094	2	_dells
dwell	9	51	985	2	dwell_
ells	4	64	3135	2	__ells
fells	8	53	2738	2	_fells
hells	8	50	3204	2	_hells
jells	12	55	2216	2	_jells
knells	10	43	925	2	knells
kvells	13	34	661	2	kvells
mells	7	50	3133	2	_mells
quells	15	35	969	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	1446	2	shelly
sheols	9	46	1415	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	1035	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
swails	9	49	1312	2	swails
swales	9	39	2076	2	swales
swears	9	41	1407	2	swears
sweats	9	48	1461	2	sweats
swedes	10	27	1189	2	swedes
sweeps	11	41	1051	2	sweeps
sweets	9	42	1443	2	sweets
swelled	11	32	1169	2	swelled
sweller	10	30	1246	2	sweller
swellest	11	3	766	2	swellest
swill	8	34	1737	2	swill_
swirls	9	40	1013	2	swirls
tells	5	58	2894	2	_tells
twills	9	48	979	2	twills
upswells	13	4	262	2	upswells
upwells	12	24	429	2	upwells
walls	8	55	2938	2	_walls
weals	8	54	2874	2	_weals
welds	9	47	1916	2	_welds
well	7	58	3204	2	_well_
welly	11	46	2001	2	_welly
welts	8	52	2519	2	_welts
wills	8	45	2896	2	_wills
yells	8	58	2194	2	_yells

Search took 5 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.123	1452772.4
2	DLD Change Limit	82551	86	4.533	18211.1
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	4.702	38003.2