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

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

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
forepaws	16	9	575	(None)
forepaw	15	9	561	1	forepaw_
firepans	13	4	715	2	firepans
forebays	16	3	726	2	forebays
forepart	13	4	970	2	forepart
foreparts	14	4	522	2	foreparts
forepast	13	4	804	2	forepast
forepeaks	18	10	457	2	forepeaks
foreplays	17	4	504	2	foreplays
foresaw	13	7	713	2	foresaw_
arepas	8	55	1570	3	_arepa_s
boreas	8	54	2173	3	bore_a_s
firepan	12	3	698	3	firepa_n
firepots	13	4	689	3	firepots
footpads	14	4	398	3	footpads
forams	11	51	1591	3	for__ams
forays	12	48	1300	3	for__ays
forbears	13	3	707	3	forbears
forceps	14	46	698	3	forcep__s
forearm	12	3	870	3	fore_arm
forearms	13	3	660	3	forearms
forebay	15	3	813	3	foreba_y
forebears	14	4	641	3	forebears
forecast	13	4	976	3	forecast
forecasts	14	4	580	3	forecasts
foredate	12	3	1091	3	foredate
foredates	13	3	1005	3	foredates
foredoes	12	3	1080	3	foredoes
foreface	16	4	711	3	foreface
forefaces	17	4	713	3	forefaces
foregoes	12	3	952	3	foregoes
foreguts	12	4	556	3	foreguts
forehand	15	3	769	3	forehand
forehands	16	5	674	3	forehands
foreheads	16	4	703	3	foreheads
foreknows	19	4	245	3	foreknows
forelady	15	4	507	3	forelady
foreland	12	3	901	3	foreland
forelands	13	4	717	3	forelands
forelegs	12	3	661	3	forelegs
foreman	12	3	1236	3	forema_n
foremast	13	4	861	3	foremast
foremasts	14	4	579	3	foremasts
forename	13	4	785	3	forename
forenames	14	4	754	3	forenames
forepassed	16	4	306	3	forepassed
forepeak	17	13	478	3	forepeak
foreplay	16	4	567	3	foreplay
foreran	10	3	1179	3	forera_n
forerank	15	4	675	3	forerank
foreranks	16	4	529	3	foreranks
foreruns	11	4	662	3	foreruns
fores	8	58	4710	3	fore___s
foresaid	12	4	780	3	foresaid
foresail	11	4	782	3	foresail
foresails	12	4	715	3	foresails
foresees	11	3	1164	3	foresees
foreshows	18	7	597	3	foreshows
forespake	18	10	523	3	forespake
forespeaks	19	4	312	3	forespeaks
forestays	15	4	662	3	forestays
forests	10	41	1495	3	fore_sts
foretops	13	13	748	3	foretops
forevers	14	3	817	3	forevers
forewarn	14	11	717	3	forewarn
forewarns	15	8	563	3	forewarns
foreyard	15	4	642	3	foreyard
foreyards	16	4	550	3	foreyards
formals	12	33	1289	3	for_mals
formats	12	31	1357	3	for_mats
foveas	12	3	862	3	fove_a_s
freaks	13	47	1306	3	f_re_aks
fretsaws	14	4	276	3	f_retsaws
frypans	15	4	405	3	f_rypans
notepads	11	4	334	3	notepads
oreads	7	39	1577	3	_ore_ads
prepays	14	3	748	3	_prepays
repass	8	41	1470	3	__repass
repays	11	38	1397	3	__repays
resaws	9	37	1351	3	__resaws
scorepads	14	7	302	3	scorepads
trepans	9	23	1159	3	_trepans

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	146162	0.440	406115.9
2	DLD Change Limit	146162	82	6.936	21073.0
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.406	24127.9