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

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

90 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
swails	9	49	1312	(None)
sails	5	57	3810	1	s_ails
snails	6	48	1665	1	snails
spails	8	48	1782	1	spails
swail	8	62	1716	1	swail_
swains	9	45	1395	1	swains
wails	8	66	3148	1	_wails
ails	4	56	5472	2	__ails
assails	7	6	909	2	assails
avails	9	3	969	2	avails
awaits	9	64	1195	2	awaits
bails	7	59	3352	2	_bails
bewails	12	7	755	2	bewails
brails	8	46	2129	2	brails
drails	7	47	1695	2	drails
emails	8	44	1234	2	emails
fails	8	56	3148	2	_fails
flails	9	43	1300	2	flails
frails	9	37	1647	2	frails
grails	7	75	1878	2	grails
hails	8	52	3164	2	_hails
jails	12	54	2294	2	_jails
kails	9	55	2522	2	_kails
mails	7	60	3778	2	_mails
nails	5	57	3040	2	_nails
pails	7	58	3306	2	_pails
quails	15	34	1264	2	quails
rails	5	59	3740	2	_rails
saids	6	53	2886	2	s_aids
sail	4	54	4716	2	s_ail_
sains	5	56	3997	2	s_ains
sals	4	68	5167	2	s_a_ls
sauls	5	51	2812	2	s_auls
scalls	8	42	1820	2	scalls
seals	5	48	3970	2	sea_ls
serails	7	33	1836	2	serails
shauls	9	49	1311	2	shauls
shawls	12	54	1197	2	shawls
sials	5	42	2724	2	sia_ls
sigils	7	39	1236	2	sigils
smalls	8	45	1412	2	smalls
snail	5	70	2020	2	snail_
snarls	6	40	1687	2	snarls
soils	5	53	2798	2	s_oils
spail	7	49	2155	2	spail_
spaits	8	50	1747	2	spaits
spalls	8	42	1734	2	spalls
speils	8	41	1622	2	speils
spoils	8	46	1453	2	spoils
staigs	7	54	1481	2	staigs
stains	6	49	2365	2	stains
stairs	6	54	1633	2	stairs
stalls	6	40	1993	2	stalls
swabs	10	58	1727	2	swa_bs
swages	10	44	1707	2	swages
swags	9	49	2125	2	swa_gs
swain	8	49	1905	2	swai_n
swale	8	52	2159	2	swa_le
swales	9	39	2076	2	swales
swamies	12	37	1206	2	swamies
swamis	11	42	1229	2	swamis
swamps	13	59	1026	2	swamps
swanks	13	48	1156	2	swanks
swans	8	46	2501	2	swa_ns
swaps	10	48	1920	2	swa_ps
swards	10	54	1513	2	swards
swarfs	12	56	1206	2	swarfs
swarms	11	61	1217	2	swarms
swaths	12	53	1264	2	swaths
swats	8	57	2686	2	swa_ts
sways	11	55	1846	2	swa_ys
swells	9	39	1398	2	swells
swigs	9	62	1366	2	sw_igs
swill	8	34	1737	2	sw_ill
swills	9	42	1336	2	swills
swims	10	55	1414	2	sw_ims
swirls	9	40	1013	2	swirls
swiss	8	67	1290	2	sw_iss
tails	5	56	3419	2	_tails
trails	6	46	2251	2	trails
twains	9	58	1118	2	twains
vails	8	58	2593	2	_vails
waifs	11	57	1987	2	_waifs
wail	7	52	3882	2	_wail_
wains	8	69	3087	2	_wains
wairs	8	64	2406	2	_wairs
waits	8	83	3352	2	_waits
walls	8	55	2938	2	_walls
wauls	8	61	2055	2	_wauls
wawls	11	54	1647	2	_wawls

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.360	496363.9
2	DLD Change Limit	82551	90	2.563	32208.7
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	2.953	60511.7