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

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

78 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
flails	9	43	1300	(None)
fails	8	56	3148	1	f_ails
flail	8	53	1618	1	flail_
flairs	9	57	1191	1	flairs
frails	9	37	1647	1	frails
ails	4	56	5471	2	__ails
avails	9	3	969	2	avails
bails	7	59	3352	2	_bails
blains	8	45	1637	2	blains
brails	8	46	2129	2	brails
claims	10	52	1157	2	claims
drails	7	47	1695	2	drails
elains	6	49	1985	2	elains
emails	8	44	1234	2	emails
fail	7	48	4024	2	f_ail_
fairs	8	58	2544	2	f_airs
falls	8	57	2765	2	f_alls
farls	8	57	3111	2	f_arls
fils	7	58	3869	2	f__ils
flabs	10	58	1864	2	fla_bs
flacks	15	41	1453	2	flacks
flags	9	53	2128	2	fla_gs
flailed	11	3	730	2	flailed
flair	8	61	1412	2	flai_r
flakes	13	41	1887	2	flakes
flakily	17	3	629	2	flakily
flames	11	47	2369	2	flames
flams	10	51	2501	2	fla_ms
flanes	9	45	2242	2	flanes
flanks	13	39	1340	2	flanks
flans	8	53	2797	2	fla_ns
flaps	10	56	2138	2	fla_ps
flares	9	45	2170	2	flares
flasks	13	48	867	2	flasks
flatly	12	31	1021	2	flatly
flats	8	64	2974	2	fla_ts
flatus	9	43	1078	2	flatus
flavins	13	3	854	2	flavins
flaws	11	59	2034	2	fla_ws
flaxes	16	50	1535	2	flaxes
flays	11	63	2105	2	fla_ys
flics	10	54	1836	2	fl_ics
flies	8	56	3071	2	fl_ies
flips	10	51	1774	2	fl_ips
flirs	8	55	1893	2	fl_irs
flits	8	56	2522	2	fl_its
fluids	10	34	942	2	fluids
foals	8	57	2169	2	foa_ls
foils	8	50	2581	2	f_oils
frail	8	52	2021	2	frail_
frazils	19	5	612	2	frazils
fulfils	13	4	572	2	fulfils
fusils	9	39	1234	2	fusils
fuzils	18	40	796	2	fuzils
glairs	7	52	1133	2	glairs
grails	7	75	1878	2	grails
hails	8	52	3164	2	_hails
jails	12	54	2294	2	_jails
kails	9	55	2521	2	_kails
laics	7	64	1925	2	_laics
lairs	5	54	2587	2	_lairs
lalls	5	53	2413	2	_lalls
mails	7	60	3778	2	_mails
nails	5	57	3040	2	_nails
pails	7	58	3306	2	_pails
plaids	9	43	1244	2	plaids
plains	8	50	1959	2	plains
plaits	8	38	1647	2	plaits
quails	15	34	1264	2	quails
rails	5	59	3740	2	_rails
sails	5	57	3810	2	_sails
snails	6	48	1665	2	snails
spails	8	48	1782	2	spails
swails	9	49	1312	2	swails
tails	5	56	3419	2	_tails
trails	6	46	2251	2	trails
vails	8	58	2593	2	_vails
wails	8	66	3148	2	_wails

Search took 6 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.220	812231.8
2	DLD Change Limit	82551	78	5.046	16359.7
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	5.282	33830.2