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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 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
shakeup	16	3	276	(None)
shakeups	17	4	237	1	shakeups
shapeup	14	4	329	1	shapeup
makeup	14	3	486	2	_makeup
scaleup	11	3	448	2	scaleup
shake	12	47	2640	2	shake__
shaken	13	41	1361	2	shake_n
shakeout	15	4	661	2	shakeout
shaker	13	43	1946	2	shake_r
shakers	14	40	1556	2	shakers
shakes	13	50	2459	2	shake_s
shapeups	15	4	272	2	shapeups
takeup	12	3	458	2	_takeup
changeup	16	4	268	3	changeup
faceup	13	3	489	3	_faceup
flareup	12	4	317	3	flareup
hake	11	56	3784	3	_hake__
hakeem	15	40	738	3	_hakeem
hakes	12	60	3430	3	_hake_s
haku	11	69	2389	3	_hak_u_
hakus	12	51	1411	3	_hak_us
hangup	12	7	729	3	_hangup
makeups	15	3	360	3	_makeups
sake	8	52	4496	3	s_ake__
saker	9	51	3202	3	s_ake_r
sakers	10	41	2543	3	s_akers
sakes	9	55	4075	3	s_ake_s
salep	7	70	2295	3	s_ale_p
sannup	8	3	656	3	s_annup
scaleups	12	4	339	3	scaleups
scaup	9	55	1599	3	sca__up
shacked	17	40	1539	3	shacke_d
shade	9	51	2558	3	shade__
shaded	11	45	1887	3	shade_d
shader	10	42	1876	3	shade_r
shaders	11	59	1555	3	shaders
shades	10	59	2453	3	shade_s
shaduf	13	3	706	3	sha_duf
shakeouts	16	4	363	3	shakeouts
shakier	14	34	1115	3	shakier
shakiest	15	19	1094	3	shakiest
shakily	17	3	690	3	shakily
shaking	15	33	1725	3	shaking
shako	12	55	1609	3	shak__o
shakoes	14	45	1002	3	shakoes
shakos	13	49	1219	3	shak_os
shaky	15	46	1684	3	shak__y
shale	8	53	3283	3	shale__
shaled	10	50	2395	3	shale_d
shales	9	47	3125	3	shale_s
shaley	12	37	1499	3	shale_y
shallop	12	34	845	3	shallop
shame	10	57	2670	3	shame__
shamed	12	51	2021	3	shame_d
shameful	16	4	428	3	shameful
shames	11	47	2622	3	shame_s
shamus	11	41	1281	3	sha_mus
shanked	15	32	1212	3	shanke_d
shape	10	51	2511	3	shape__
shaped	12	50	2010	3	shape_d
shapely	15	3	689	3	shapely
shapen	11	44	1465	3	shape_n
shaper	11	41	1993	3	shape_r
shapers	12	40	1689	3	shapers
shapes	11	51	2495	3	shape_s
share	8	64	3708	3	share__
shared	10	58	2906	3	share_d
sharer	9	50	2548	3	share_r
sharers	10	47	2062	3	sharers
shares	9	52	3641	3	share_s
sharked	15	36	1391	3	sharke_d
sharker	14	43	1381	3	sharke_r
sharkers	15	40	1105	3	sharkers
sharp	10	49	2253	3	sha__rp
shaul	8	54	1810	3	sha__ul
shave	11	44	2589	3	shave__
shaved	13	51	1838	3	shave_d
shaven	12	42	1330	3	shave_n
shaver	12	37	1891	3	shave_r
shavers	13	41	1509	3	shavers
shaves	12	52	2493	3	shave_s
shawed	13	48	1723	3	shawe_d
sheep	10	53	2152	3	sh__eep
shekel	13	3	838	3	sheke_l
shekels	14	3	604	3	shekels
shlep	10	49	1483	3	sh_le_p
shlepp	13	36	619	3	sh_lepp
skelp	11	42	1142	3	s__kelp
skep	10	52	1935	3	s__ke_p
slake	9	37	2405	3	slake__
slaked	11	43	1827	3	slake_d
slaker	10	42	1927	3	slake_r
slakers	11	41	1575	3	slakers
slakes	10	40	2188	3	slake_s
smashup	14	4	345	3	smashup
snake	9	48	2111	3	snake__
snaked	11	50	1759	3	snake_d
snakes	10	39	1960	3	snake_s
snakey	13	50	1127	3	snake_y
soaked	11	47	1759	3	soake_d
soaker	10	57	1753	3	soake_r
soakers	11	41	1495	3	soakers
spake	11	43	2274	3	spake__
stackup	15	3	374	3	stackup
stake	9	59	2753	3	stake__
staked	11	46	2194	3	stake_d
stakeout	12	4	714	3	stakeout
stakes	10	39	2729	3	stake_s
standup	10	3	435	3	standup
startup	9	3	496	3	startup
takeups	13	3	340	3	_takeups
whaup	13	45	888	3	wha__up

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	134027	0.406	440125.6
2	DLD Change Limit	134027	112	6.893	19443.9
3	Display Results	112	112	0.030	3733.3
	(SQL Overall)	178691	112	7.329	24381.4