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

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

275 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
soaks	9	52	2029	(None)
oaks	8	65	2790	1	_oaks
soak	8	72	2766	1	soak_
soaps	7	51	2071	1	soaps
soars	5	47	3251	1	soars
socks	11	49	2608	1	socks
sooks	9	44	2545	1	sooks
souks	9	48	2052	1	souks
araks	9	48	2088	2	araks
beaks	11	53	2662	2	beaks
boars	7	52	2960	2	boars
boas	6	61	5083	2	boa_s
boats	7	56	3515	2	boats
bocks	13	45	2657	2	bocks
bonks	11	63	2646	2	bonks
books	11	57	2971	2	books
borks	11	57	2770	2	borks
bosks	11	52	1885	2	bosks
cloaks	12	44	1126	2	cloaks
coals	7	61	2960	2	coals
coats	7	56	3500	2	coats
cocks	13	52	2716	2	cocks
conks	11	55	2570	2	conks
cooks	11	54	2914	2	cooks
corks	11	60	2827	2	corks
croaks	12	58	1298	2	croaks
daks	9	71	3060	2	_daks
dhaks	13	47	970	2	dhaks
doats	6	52	2488	2	doats
docks	12	60	2231	2	docks
dorks	10	57	2444	2	dorks
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
folks	12	60	1712	2	folks
forks	12	53	2468	2	forks
goads	7	70	2285	2	goads
goals	6	55	2129	2	goals
goas	5	52	3994	2	goa_s
goats	6	55	2730	2	goats
gooks	10	54	2288	2	gooks
gowks	13	60	1195	2	gowks
hoars	8	59	2555	2	hoars
hocks	14	49	2549	2	hocks
holks	12	47	2056	2	holks
honks	12	51	2452	2	honks
hooks	12	50	2712	2	hooks
howks	15	50	1685	2	howks
jocks	18	51	1808	2	jocks
jouks	16	56	1234	2	jouks
koans	9	58	1862	2	koans
koas	8	56	3509	2	koa_s
konks	8	49	1711	2	konks
kooks	8	52	1726	2	kooks
kyaks	11	45	916	2	kyaks
leaks	9	59	2391	2	leaks
loads	6	53	2337	2	loads
loafs	8	56	1699	2	loafs
loams	7	56	1986	2	loams
loans	5	60	2646	2	loans
locks	11	51	2692	2	locks
looks	9	51	2486	2	looks
moans	7	46	2437	2	moans
moas	6	55	4534	2	moa_s
moats	7	58	2764	2	moats
mocks	13	50	2382	2	mocks
monks	11	61	2339	2	monks
mosks	11	61	1700	2	mosks
nocks	11	51	2101	2	nocks
nooks	9	54	2039	2	nooks
oafs	7	64	2526	2	_oafs
oak	7	62	3865	2	_oak_
oaky	11	64	1995	2	_oaky
oars	4	68	4603	2	_oars
oats	4	65	5421	2	_oats
okas	8	52	2539	2	_okas
peaks	11	48	2562	2	peaks
pocks	13	50	2296	2	pocks
porks	11	51	2414	2	porks
psoas	7	50	1298	2	psoa_s
resoaks	11	4	897	2	resoaks
roads	6	65	2362	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2224	2	roars
rocks	11	46	2641	2	rocks
rooks	9	53	2504	2	rooks
sabs	6	66	4374	2	s_abs
sacks	11	42	2887	2	sacks
sacs	6	57	3907	2	s_acs
sags	5	59	4840	2	s_ags
sake	8	52	4496	2	s_ake
sakes	9	55	4075	2	s_akes
saki	8	56	2848	2	s_aki
sakis	9	53	2367	2	s_akis
sals	4	68	5167	2	s_als
sans	4	51	5336	2	s_ans
saps	6	53	4637	2	s_aps
sarks	9	66	3246	2	sarks
sass	4	50	3562	2	s_ass
saws	7	58	3948	2	s_aws
says	7	59	4210	2	s_ays
scabs	9	48	1864	2	scabs
scads	8	54	1996	2	scads
scags	8	55	2097	2	scags
scams	9	44	2397	2	scams
scans	7	46	2510	2	scans
scars	7	54	3353	2	scars
scats	7	59	3060	2	scats
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seeks	9	47	2464	2	seeks
shacks	15	48	1756	2	shacks
shads	9	51	2448	2	shads
shags	9	51	2386	2	shags
shahs	11	59	1951	2	shahs
shake	12	47	2640	2	shake
shakes	13	50	2459	2	shakes
shako	12	55	1609	2	shako
shakos	13	49	1219	2	shakos
shaky	15	46	1684	2	shaky
shams	10	58	2941	2	shams
shanks	13	53	1558	2	shanks
sharks	13	50	1972	2	sharks
shaws	11	62	2626	2	shaws
shays	11	60	2143	2	shays
shoals	9	42	1579	2	shoals
shoats	9	41	1708	2	shoats
shocks	15	44	1458	2	shocks
shooks	13	45	1563	2	shooks
sials	5	42	2724	2	sials
sicks	11	51	2762	2	sicks
sikas	9	46	1702	2	sikas
silks	9	46	2068	2	silks
sinks	9	55	2918	2	sinks
skags	10	43	1607	2	skags
skanks	9	47	1083	2	skanks
skas	8	53	2571	2	ska_s
skats	9	46	2154	2	skats
skoals	10	43	824	2	skoals
slabs	7	53	2264	2	slabs
slacks	12	44	1653	2	slacks
slags	6	65	2590	2	slags
slake	9	37	2405	2	slake
slakes	10	40	2188	2	slakes
slams	7	49	2790	2	slams
slaps	7	60	2571	2	slaps
slats	5	54	3690	2	slats
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
smacks	14	41	1232	2	smacks
smocks	14	57	1001	2	smocks
snacks	12	45	1455	2	snacks
snags	6	44	2131	2	snags
snake	9	48	2111	2	snake
snakes	10	39	1960	2	snakes
snaky	12	51	1391	2	snaky
snaps	7	47	1956	2	snaps
snarks	10	48	1573	2	snarks
snaws	8	61	1636	2	snaws
sneaks	10	43	1249	2	sneaks
snooks	10	44	1283	2	snooks
soaked	11	47	1759	2	soaked
soaker	10	57	1753	2	soaker
soakers	11	41	1495	2	soakers
soap	6	58	3113	2	soa_p
soapy	10	61	1478	2	soapy
soar	4	68	3867	2	soa_r
soave	8	42	1905	2	soave
soaves	9	42	1867	2	soaves
sobas	7	44	2425	2	sobas
sobs	6	49	4175	2	so_bs
socas	7	40	2618	2	socas
sock	10	52	3321	2	sock_
socko	11	52	1511	2	socko
sodas	6	41	2354	2	sodas
sods	5	49	4021	2	so_ds
sofars	9	47	1278	2	sofars
sofas	8	53	2071	2	sofas
softs	8	50	1923	2	softs
soils	5	53	2798	2	soils
sojas	12	47	1639	2	sojas
soke	8	54	3626	2	so_ke
sokes	9	50	3142	2	sokes
solans	6	41	2249	2	solans
soles	5	55	4792	2	soles
solos	5	48	3079	2	solos
sols	4	54	4816	2	so_ls
solus	5	47	2698	2	solus
somans	8	46	1930	2	somans
somas	7	60	3037	2	somas
soms	6	62	3937	2	so_ms
sonars	6	48	1897	2	sonars
sones	5	54	4414	2	sones
songs	6	77	2555	2	songs
sons	4	60	4955	2	so_ns
sook	8	49	3339	2	sook_
soots	5	55	3621	2	soots
sophs	10	49	1602	2	sophs
sops	6	52	4456	2	so_ps
soras	5	50	4101	2	soras
sorbs	7	50	2210	2	sorbs
sords	6	45	2780	2	sords
sores	5	54	5428	2	sores
sorns	5	50	2842	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
sos	3	77	6160	2	so__s
soths	8	62	1863	2	soths
sots	4	55	5245	2	so_ts
souk	8	61	2717	2	souk_
souls	5	51	2736	2	souls
soups	7	53	2294	2	soups
sours	5	52	3050	2	sours
sous	4	69	4721	2	so_us
sowans	9	42	1589	2	sowans
sowars	9	43	1801	2	sowars
sows	7	53	4249	2	so_ws
soyas	8	45	2091	2	soyas
soys	7	52	3393	2	so_ys
spaes	7	60	2997	2	spaes
spake	11	43	2274	2	spake
spams	9	49	2219	2	spams
spanks	12	45	1412	2	spanks
spans	7	45	2873	2	spans
sparks	12	46	1636	2	sparks
spars	7	54	3154	2	spars
spas	6	70	3672	2	spa_s
spats	7	50	3138	2	spats
spays	10	55	2051	2	spays
speaks	12	51	1458	2	speaks
spiks	11	41	1747	2	spiks
spooks	12	43	1293	2	spooks
stabs	7	62	2138	2	stabs
stacks	12	43	1726	2	stacks
stags	6	62	2674	2	stags
stake	9	59	2753	2	stake
stakes	10	39	2729	2	stakes
stalks	10	46	1455	2	stalks
stanks	10	49	1770	2	stanks
stars	5	58	3657	2	stars
stats	5	59	3336	2	stats
stays	8	60	2202	2	stays
steaks	10	44	1585	2	steaks
stoas	5	51	2602	2	stoa_s
stoats	6	51	1748	2	stoats
stocks	12	47	1563	2	stocks
stooks	10	51	1537	2	stooks
storks	10	61	1595	2	storks
sucks	11	45	2307	2	sucks
suks	8	59	2712	2	s_uks
sulks	9	48	1846	2	sulks
swabs	10	58	1727	2	swabs
swags	9	49	2125	2	swags
swanks	13	48	1156	2	swanks
swans	8	46	2501	2	swans
swaps	10	48	1920	2	swaps
swats	8	57	2686	2	swats
sways	11	55	1846	2	sways
teaks	9	42	2290	2	teaks
toads	6	56	2107	2	toads
troaks	10	44	1060	2	troaks
woads	9	48	1844	2	woads
woks	11	62	2490	2	wo_ks
wonks	12	48	1834	2	wonks
works	12	56	2190	2	works
yaks	11	60	2520	2	_yaks
yocks	14	44	1837	2	yocks
yoks	11	62	2374	2	yo_ks
yolks	12	54	1277	2	yolks
zonks	18	48	1517	2	zonks
zooks	18	47	1694	2	zooks
zouks	18	44	1050	2	zouks

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	53800	0.923	193598.0
2	DLD Change Limit	53800	275	5.796	9282.3
3	Display Results	275	275	0.140	1964.3
	(SQL Overall)	178691	275	6.859	26052.0