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

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

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
forsaking	17	4	517	(None)
foraging	13	5	806	2	for_aging
foraying	15	3	743	2	for_aying
forking	15	40	1484	2	for__king
forsaken	15	4	335	2	forsaken_
freaking	16	36	1145	2	f_reaking
beraking	15	36	1297	3	ber_aking
borating	11	34	1450	3	bor_ating
borking	14	47	1617	3	bor__king
braking	14	39	1771	3	_br_aking
breaking	15	39	1425	3	_breaking
comaking	17	3	999	3	co_making
corking	14	30	1882	3	cor__king
corrading	13	3	820	3	corrading
corseting	12	3	1217	3	corseting
creaking	15	34	1412	3	_creaking
croaking	15	37	1216	3	_croaking
faking	14	55	2098	3	f___aking
farseeing	13	4	438	3	farseeing
firstling	13	3	442	3	firstling
flaking	15	41	1449	3	f__laking
foaling	11	35	1584	3	fo__aling
foaming	13	36	1299	3	fo__aming
foisting	12	29	1050	3	fois_ting
foliating	13	3	925	3	foliating
foramina	13	4	616	3	for_amina
forbearing	16	4	480	3	forbearing
forboding	16	4	514	3	forboding
forcing	13	40	1375	3	for__cing
fording	12	37	1704	3	for__ding
fordoing	13	5	730	3	for_doing
forearming	16	4	419	3	forearming
foredating	15	7	712	3	foredating
foredoing	14	5	648	3	foredoing
foregoing	14	5	579	3	foregoing
foreseeing	14	4	455	3	foreseeing
foreskin	15	4	702	3	foreskin_
foreskins	16	4	704	3	foreskins
forespeaking	22	5	215	3	forespeaking
foresting	13	3	1136	3	foresting
forewing	15	3	900	3	for_ewing
forging	12	41	1472	3	for__ging
forgiving	17	4	434	3	forgiving
forgoing	13	6	685	3	for_going
formalin	13	4	731	3	formalin_
formalins	14	4	721	3	formalins
formatting	16	4	416	3	formatting
forming	13	36	1573	3	for__ming
forsake	14	3	653	3	forsak__e
forsaker	15	4	510	3	forsak_er
forsakers	16	4	465	3	forsakers
forsakes	15	3	689	3	forsak_es
forswearing	18	5	232	3	forswearing
fortuning	13	4	549	3	fortuning
forwarding	18	4	349	3	forwarding
fossicking	20	4	245	3	fossicking
foxskin	21	4	313	3	foxs_kin_
foxskins	22	4	288	3	foxs_kins
framing	13	30	1479	3	f_r_aming
franking	16	43	1086	3	f_ranking
fraying	14	34	1343	3	f_r_aying
frisking	16	26	836	3	f_risking
frocking	18	30	957	3	f_rocking
frosting	12	3	1118	3	fros_ting
furcating	15	3	778	3	furcating
furnacing	15	4	371	3	furnacing
hopsacking	22	4	253	3	hopsacking
horsing	11	32	1558	3	hors__ing
morseling	12	3	807	3	morseling
mortaring	12	3	794	3	mortaring
noncaking	16	4	668	3	noncaking
orating	8	35	2032	3	_or_ating
parbaking	18	7	720	3	parbaking
partaking	16	9	867	3	partaking
phreaking	19	3	647	3	phreaking
porking	14	35	1581	3	por__king
portaging	13	4	684	3	portaging
raking	11	47	2842	3	__r_aking
screaking	16	22	823	3	screaking
soaking	12	31	1661	3	so__aking
streaking	14	20	1032	3	streaking
troaking	13	33	1097	3	_troaking
working	15	38	1325	3	wor__king
worsening	13	4	555	3	worsening
worsting	12	6	768	3	wors_ting
wreaking	16	30	1021	3	_wreaking

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.436	409841.7
2	DLD Change Limit	148641	86	6.986	21277.0
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.452	23978.9