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

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

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

188 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
spake	11	43	2274	(None)
sake	8	52	4496	1	s_ake
shake	12	47	2640	1	shake
slake	9	37	2405	1	slake
snake	9	48	2111	1	snake
space	9	53	2567	1	space
spade	8	44	2332	1	spade
spae	6	50	3432	1	spa_e
spale	7	49	2921	1	spale
spare	7	51	3556	1	spare
spate	7	47	3158	1	spate
spike	11	49	2284	1	spike
splake	12	5	978	1	splake
spoke	11	48	1866	1	spoke
stake	9	59	2753	1	stake
apace	9	47	1838	2	apace
awake	12	50	1478	2	awake
bake	10	56	3751	2	_bake
bespake	15	43	696	2	bespake
brake	11	60	2534	2	brake
cake	10	54	3996	2	_cake
crake	11	48	2352	2	crake
drake	10	49	1830	2	drake
fake	11	55	3494	2	_fake
flake	12	51	1997	2	flake
hake	11	56	3784	2	_hake
jake	15	59	2577	2	_jake
lake	8	57	4160	2	_lake
make	10	55	3789	2	_make
pace	8	63	4577	2	_pace
page	7	60	3610	2	_page
pale	6	60	5501	2	_pale
pane	6	49	5029	2	_pane
pare	6	67	6084	2	_pare
pase	6	53	4686	2	_pase
pate	6	53	5046	2	_pate
pave	9	61	3389	2	_pave
peke	10	59	2620	2	_peke
pike	10	63	3521	2	_pike
poke	10	53	3536	2	_poke
puke	10	50	2546	2	_puke
quake	18	41	1464	2	quake
rake	8	48	4157	2	_rake
sabe	6	61	4057	2	s_abe
sade	5	55	4447	2	s_ade
sae	3	83	6518	2	s_a_e
safe	7	59	3095	2	s_afe
sage	5	50	4459	2	s_age
saker	9	51	3202	2	s_aker
sakes	9	55	4075	2	s_akes
saki	8	56	2848	2	s_aki
sale	4	49	5970	2	s_ale
same	6	52	4564	2	s_ame
sane	4	59	5434	2	s_ane
sate	4	55	5610	2	s_ate
save	7	57	4136	2	s_ave
scale	7	46	2914	2	scale
scape	9	69	2184	2	scape
scare	7	53	3446	2	scare
shade	9	51	2558	2	shade
shaken	13	41	1361	2	shaken
shaker	13	43	1946	2	shaker
shakes	13	50	2459	2	shakes
shako	12	55	1609	2	shako
shaky	15	46	1684	2	shaky
shale	8	53	3283	2	shale
shame	10	57	2670	2	shame
shape	10	51	2511	2	shape
share	8	64	3708	2	share
shave	11	44	2589	2	shave
sike	8	71	3878	2	s_ike
skate	9	47	2155	2	skate
slaked	11	43	1827	2	slaked
slaker	10	42	1927	2	slaker
slakes	10	40	2188	2	slakes
slate	5	54	3828	2	slate
slave	8	42	2403	2	slave
smaze	16	50	1293	2	smaze
smoke	11	50	1582	2	smoke
snaked	11	50	1759	2	snaked
snakes	10	39	1960	2	snakes
snakey	13	50	1127	2	snakey
snaky	12	51	1391	2	snaky
snare	5	44	2998	2	snare
soak	8	72	2766	2	soak_
soaked	11	47	1759	2	soaked
soaker	10	57	1753	2	soaker
soaks	9	52	2029	2	soaks
soave	8	42	1905	2	soave
soke	8	54	3626	2	s_oke
spa	5	57	3081	2	spa__
spaced	11	45	1725	2	spaced
spacer	10	49	1779	2	spacer
spaces	10	47	2263	2	spaces
spacey	13	62	1253	2	spacey
spackle	15	36	957	2	spackle
spacy	12	54	1562	2	spacy
spaded	10	38	1675	2	spaded
spader	9	43	1713	2	spader
spades	9	42	2258	2	spades
spado	8	37	1370	2	spado
spaed	8	55	2227	2	spaed
spaes	7	60	2997	2	spaes
spahee	11	3	1344	2	spahee
spahi	10	3	1114	2	spahi
spail	7	49	2155	2	spail
spait	7	56	3160	2	spait
spales	8	47	2810	2	spales
spall	7	49	1930	2	spall
spam	8	59	3004	2	spa_m
spams	9	49	2219	2	spams
span	6	52	3466	2	spa_n
spang	8	49	1973	2	spang
spank	11	59	1957	2	spank
spanked	14	31	1173	2	spanked
spanker	13	36	1235	2	spanker
spanks	12	45	1412	2	spanks
spans	7	45	2873	2	spans
spar	6	54	3330	2	spa_r
spared	9	54	2749	2	spared
sparer	8	45	2496	2	sparer
spares	8	48	3455	2	spares
sparge	9	42	1605	2	sparge
spark	11	49	2089	2	spark
sparked	14	35	1314	2	sparked
sparker	13	39	1436	2	sparker
sparkle	13	37	1021	2	sparkle
sparks	12	46	1636	2	sparks
sparky	15	45	1152	2	sparky
spars	7	54	3154	2	spars
sparse	8	45	1634	2	sparse
spas	6	70	3672	2	spa_s
spasm	9	45	1417	2	spasm
spat	6	65	4852	2	spa_t
spates	8	50	2817	2	spates
spathe	11	51	1569	2	spathe
spats	7	50	3138	2	spats
spavie	11	36	1138	2	spavie
spawn	10	78	1171	2	spawn
spay	9	66	3166	2	spa_y
spayed	12	42	1361	2	spayed
spays	10	55	2051	2	spays
spaz	15	56	2616	2	spa_z
spazz	15	58	1113	2	spazz
speak	11	46	1867	2	speak_
speaker	13	33	1121	2	speaker
speaks	12	51	1458	2	speaks
spice	9	55	2881	2	spice
spik	10	54	1971	2	spik_
spiked	13	49	1555	2	spiked
spiker	12	43	1566	2	spiker
spikes	12	45	2071	2	spikes
spikey	15	54	1133	2	spikey
spiks	11	41	1747	2	spiks
spiky	14	60	1411	2	spiky
spile	7	52	3008	2	spile
spine	7	65	3442	2	spine
spire	7	58	2869	2	spire
spite	7	54	3066	2	spite
splakes	13	4	967	2	splakes
spode	8	46	1770	2	spode
spoked	13	44	1389	2	spoked
spoken	12	46	1000	2	spoken
spokes	12	44	1721	2	spokes
spore	7	54	2859	2	spore
spree	7	48	3086	2	spree
sprue	7	47	1763	2	sprue
spue	6	60	2552	2	sp_ue
spume	9	58	1731	2	spume
stade	6	48	2530	2	stade
stage	6	53	3019	2	stage
staked	11	46	2194	2	staked
stakes	10	39	2729	2	stakes
stale	5	56	3710	2	stale
stane	5	59	3300	2	stane
stare	5	44	4026	2	stare
state	5	62	3733	2	state
stave	8	53	2499	2	stave
stoke	9	49	2251	2	stoke
strake	10	40	1739	2	strake
suave	8	35	1987	2	suave
swage	9	49	1956	2	swage
swale	8	52	2159	2	swale
sware	8	58	2821	2	sware
syke	11	54	2056	2	s_yke
take	8	47	3926	2	_take
uptake	12	3	696	2	uptake
wake	11	49	3570	2	_wake

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	188	1.576	34137.1
3	Display Results	188	188	0.046	4087.0
	(SQL Overall)	178691	188	1.935	92346.8