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

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

203 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
soaked	11	47	1759	(None)
slaked	11	43	1827	1	slaked
snaked	11	50	1759	1	snaked
soaker	10	57	1753	1	soaker
soaped	9	58	1797	1	soaped
soared	7	43	2429	1	soared
socked	13	47	2150	1	socked
staked	11	46	2194	1	staked
awaked	14	57	920	2	awaked
baked	12	61	3077	2	_baked
beaked	13	59	1949	2	beaked
boated	9	42	2197	2	boated
bonked	13	55	1731	2	bonked
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
braked	13	53	1869	2	braked
caked	12	61	2862	2	_caked
cloaked	14	36	854	2	cloaked
coaled	9	50	2270	2	coaled
coated	9	49	2703	2	coated
coaxed	16	56	1251	2	coaxed
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	co_ked
conked	13	50	1911	2	conked
cooked	13	59	2136	2	cooked
corked	13	50	2078	2	corked
croaked	14	37	1053	2	croaked
doated	8	41	1818	2	doated
docked	14	50	1833	2	docked
faked	13	52	2548	2	_faked
flaked	14	47	1565	2	flaked
foaled	10	45	1596	2	foaled
foamed	12	60	1440	2	foamed
forked	14	52	1714	2	forked
goaded	9	49	1371	2	goaded
goaled	8	50	1435	2	goaled
hoaxed	17	37	887	2	hoaxed
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	ho_ked
holked	14	49	1366	2	holked
honked	14	45	1791	2	honked
hooked	14	53	2055	2	hooked
howked	17	73	1234	2	howked
joked	17	52	1791	2	jo_ked
jouked	18	56	815	2	jouked
konked	10	40	1058	2	konked
laked	10	57	3112	2	_laked
leaked	11	42	1770	2	leaked
loaded	8	46	1687	2	loaded
loafed	10	40	1115	2	loafed
loamed	9	44	1461	2	loamed
loaned	7	38	1629	2	loaned
locked	13	49	2166	2	locked
looked	11	47	1707	2	looked
moaned	9	45	1417	2	moaned
moated	9	48	1900	2	moated
mocked	15	47	1661	2	mocked
naked	10	53	2085	2	_naked
nocked	13	46	1738	2	nocked
oaken	9	58	1438	2	_oaken
oared	6	50	3065	2	_oared
peaked	13	61	1740	2	peaked
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	po_ked
porked	13	47	1762	2	porked
quaked	20	39	1003	2	quaked
raked	10	58	3142	2	_raked
resoaked	13	3	794	2	resoaked
roamed	9	52	1509	2	roamed
roared	7	50	1539	2	roared
rocked	13	50	2232	2	rocked
rooked	11	49	1814	2	rooked
sabed	8	65	2681	2	s_abed
sacked	13	55	2521	2	sacked
sake	8	52	4496	2	s_ake_
saker	9	51	3202	2	s_aker
sakes	9	55	4075	2	s_akes
saned	6	56	3627	2	s_aned
sated	6	62	3853	2	s_ated
saved	9	51	2711	2	s_aved
sawed	9	56	2840	2	s_awed
sayed	9	61	2714	2	s_ayed
scaled	9	48	2244	2	scaled
scaped	11	55	1955	2	scaped
scared	9	52	2729	2	scared
seabed	9	50	1769	2	seabed
sealed	7	43	2836	2	sealed
seamed	9	48	2388	2	seamed
seared	7	52	3284	2	seared
seated	7	51	3105	2	seated
shacked	17	40	1539	2	shacked
shaded	11	45	1887	2	shaded
shake	12	47	2640	2	shake_
shaken	13	41	1361	2	shaken
shaker	13	43	1946	2	shaker
shakes	13	50	2459	2	shakes
shaled	10	50	2395	2	shaled
shamed	12	51	2021	2	shamed
shanked	15	32	1212	2	shanked
shaped	12	50	2010	2	shaped
shared	10	58	2906	2	shared
sharked	15	36	1390	2	sharked
shaved	13	51	1838	2	shaved
shawed	13	48	1723	2	shawed
shoaled	11	38	1096	2	shoaled
shocked	17	46	1180	2	shocked
sicked	13	45	2440	2	sicked
silked	11	43	1481	2	silked
skanked	11	33	810	2	skanked
skated	11	44	1487	2	skated
skoaled	12	22	604	2	skoaled
slacked	14	38	1545	2	slacked
slake	9	37	2405	2	slake_
slaker	10	42	1927	2	slaker
slakes	10	40	2188	2	slakes
slated	7	50	2831	2	slated
slaved	10	40	1704	2	slaved
slayed	10	47	1622	2	slayed
smacked	16	37	1099	2	smacked
smocked	16	39	822	2	smocked
smoked	13	43	1172	2	smoked
snacked	14	40	1311	2	snacked
snake	9	48	2111	2	snake_
snakes	10	39	1960	2	snakes
snakey	13	50	1127	2	snakey
snared	7	48	2455	2	snared
snawed	10	48	1373	2	snawed
sneaked	12	32	969	2	sneaked
snooked	12	37	1149	2	snooked
soak	8	72	2766	2	soak__
soakers	11	41	1495	2	soakers
soaks	9	52	2029	2	soak_s
soaper	8	45	1787	2	soaper
soarer	6	45	2224	2	soarer
soave	8	42	1905	2	soave_
soaves	9	42	1867	2	soaves
sobbed	11	35	1626	2	sobbed
socket	12	39	2352	2	socket
sodded	9	41	1330	2	sodded
sofabed	13	3	433	2	sofabed
sogged	9	55	1852	2	sogged
soiled	7	38	2247	2	soiled
soke	8	54	3626	2	so_ke_
sokes	9	50	3142	2	so_kes
solaced	10	29	1106	2	solaced
solated	8	36	1802	2	solated
soled	6	58	3517	2	so_led
soloed	7	45	1574	2	soloed
solved	10	53	1293	2	solved
sooted	7	39	2258	2	sooted
sopped	11	48	1990	2	sopped
sorbed	9	49	1651	2	sorbed
sored	6	61	4178	2	so_red
sorned	7	48	2004	2	sorned
sorted	7	45	2371	2	sorted
sotted	7	41	2139	2	sotted
souled	7	54	1982	2	souled
souped	9	50	1767	2	souped
soured	7	49	2186	2	soured
soused	7	48	2298	2	soused
sowed	9	49	3386	2	so_wed
spaced	11	45	1725	2	spaced
spaded	10	38	1675	2	spaded
spaed	8	55	2227	2	spa_ed
spake	11	43	2274	2	spake_
spanked	14	31	1172	2	spanked
spared	9	54	2748	2	spared
sparked	14	35	1313	2	sparked
spayed	12	42	1361	2	spayed
spiked	13	49	1555	2	spiked
spoked	13	44	1389	2	spoked
spooked	14	45	1047	2	spooked
stacked	14	34	1612	2	stacked
staged	8	45	2156	2	staged
stake	9	59	2753	2	stake_
stakes	10	39	2729	2	stakes
staled	7	47	2810	2	staled
stalked	12	38	1117	2	stalked
staned	7	48	2464	2	staned
stared	7	54	2987	2	stared
stated	7	54	2783	2	stated
staved	10	39	1805	2	staved
stayed	10	48	1727	2	stayed
stocked	14	43	1287	2	stocked
stoked	11	47	1829	2	stoked
stooked	12	43	1230	2	stooked
straked	12	54	1534	2	straked
sucked	13	41	2049	2	sucked
sulked	11	43	1470	2	sulked
swacked	17	31	1052	2	swacked
swaged	11	42	1225	2	swaged
swanked	15	35	954	2	swanked
swayed	13	35	1026	2	swayed
toked	10	56	2649	2	to_ked
troaked	12	43	825	2	troaked
unsoaked	13	3	885	2	unsoaked
waked	13	56	2675	2	_waked
woaded	11	52	1160	2	woaded
worked	14	53	1470	2	worked
yocked	16	41	1442	2	yocked
yoked	13	48	2162	2	yo_ked
yolked	14	36	715	2	yolked
zonked	20	42	947	2	zonked

Search took 5 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	203	3.826	21576.3
3	Display Results	203	203	0.126	1611.1
	(SQL Overall)	178691	203	4.078	43818.3