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

Here are the results of your fuzzy-string dictionary search for “foresails” with Change Limit: [1] [2] [3] [4]

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.

73 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
foresails	12	4	715	(None)
foresail	11	4	782	1	foresail_
foresaid	12	4	780	2	foresai_d
foreskins	16	4	704	2	foreskins
forestalls	13	4	580	2	forestalls
resails	7	46	1674	2	__resails
aforesaid	13	4	326	3	aforesai_d
corsairs	10	4	687	3	cor_sairs
dorsals	8	41	1084	3	dor_sa_ls
dovetails	13	4	381	3	dovetails
fireballs	14	12	649	3	fireballs
firehalls	15	10	517	3	firehalls
fireships	17	4	602	3	fireships
firewalls	15	12	535	3	firewalls
forearms	13	3	660	3	fore_arms
forebays	16	3	726	3	foreba_ys
forebrains	15	4	462	3	forebrains
forecasts	14	4	580	3	forecasts
foredates	13	3	1005	3	foredates
forefaces	17	4	713	3	forefaces
forefeels	15	9	384	3	forefeels
forehands	16	5	674	3	forehands
foreladies	14	4	498	3	foreladies
forelands	13	4	717	3	forelands
foremasts	14	4	579	3	foremasts
foremilk	17	4	437	3	fore_milk
foremilks	18	4	278	3	fore_milks
forenames	14	4	754	3	forenames
forensics	14	4	383	3	forensics
foreparts	14	4	522	3	foreparts
forepaws	16	9	575	3	forepa_ws
foreranks	16	4	529	3	foreranks
foresaw	13	7	713	3	foresa__w
foreseers	12	3	740	3	foreseers
foresees	11	3	1164	3	fores_ees
foreshanks	20	4	383	3	foreshanks
foreshows	18	7	597	3	foreshows
foreside	12	3	1030	3	fores_ide
foresides	13	3	970	3	foresides
foreskin	15	4	702	3	foreski_n
forestages	14	4	673	3	forestages
forestal	11	4	1028	3	forestal_
forestall	12	4	691	3	forestall
forestays	15	4	662	3	forestays
foresters	12	3	1253	3	foresters
forestial	12	4	723	3	forestial
foresting	13	3	1136	3	foresting
forestries	13	4	855	3	forestries
forests	10	41	1495	3	fores__ts
foretells	12	4	563	3	foretells
forewarns	15	8	563	3	forewarns
foreyards	16	4	550	3	foreyards
forkballs	18	4	425	3	forkballs
formals	12	33	1289	3	for_ma_ls
forsakes	15	3	689	3	for_sakes
fossils	10	37	901	3	fo__ssils
foxtails	18	4	458	3	fo_xtails
frails	9	37	1647	3	f_r__ails
fresnels	11	3	523	3	f_resnels
horntails	12	12	482	3	horntails
horsetails	13	4	473	3	horsetails
moonsails	11	4	449	3	moonsails
outsails	8	13	986	3	_outsails
parasails	11	4	758	3	parasails
prevails	13	3	766	3	_prevails
remails	9	47	1456	3	__remails
renails	7	49	1726	3	__renails
resail	6	44	1873	3	__resail_
retails	7	47	1897	3	__retails
toenails	8	4	721	3	to_enails
topsails	10	7	509	3	to_psails
trenails	8	6	984	3	_trenails
trysails	11	4	416	3	_trysails

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	73	7.393	20105.6
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.843	22783.5