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

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

173 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
soaker	10	57	1753	(None)
saker	9	51	3202	1	s_aker
shaker	13	43	1946	1	shaker
slaker	10	42	1927	1	slaker
soaked	11	47	1759	1	soaked
soakers	11	41	1495	1	soakers
soaper	8	45	1787	1	soaper
soarer	6	45	2224	1	soarer
baker	11	56	2954	2	_baker
beaker	12	55	2069	2	beaker
boater	8	46	2209	2	boater
booker	12	47	1919	2	booker
bosker	12	38	1365	2	bosker
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
cocker	14	43	2039	2	cocker
comaker	15	34	1060	2	comaker
conker	12	47	2155	2	conker
cooker	12	47	2245	2	cooker
corker	12	47	2085	2	corker
croaker	13	30	1068	2	croaker
docker	13	44	1765	2	docker
faker	12	48	2459	2	_faker
flaker	13	49	1617	2	flaker
foamer	11	47	1431	2	foamer
forker	13	47	1790	2	forker
hoaxer	16	34	856	2	hoaxer
hocker	15	51	1856	2	hocker
honker	13	41	1746	2	honker
hooker	13	48	2017	2	hooker
joker	16	57	1589	2	jo_ker
laker	9	54	3287	2	_laker
leaker	10	46	2007	2	leaker
loader	7	43	1631	2	loader
loafer	9	36	1094	2	loafer
loaner	6	44	1650	2	loaner
locker	12	40	1942	2	locker
looker	10	48	1695	2	looker
maker	11	41	2781	2	_maker
moaner	8	44	1511	2	moaner
mocker	14	33	1544	2	mocker
oaken	9	58	1438	2	_oaken
oakier	10	40	1139	2	_oakier
oater	5	54	3373	2	_oater
ocker	11	39	1575	2	_ocker
poker	11	51	2288	2	po_ker
porker	12	49	1754	2	porker
quaker	19	38	1162	2	quaker
raker	9	45	2979	2	_raker
roamer	8	47	1516	2	roamer
roarer	6	39	1433	2	roarer
rocker	12	43	1957	2	rocker
saber	7	53	3024	2	s_aber
sacker	12	51	2484	2	sacker
safer	8	47	2181	2	s_afer
sager	6	54	3205	2	s_ager
sake	8	52	4496	2	s_ake_
sakers	10	41	2543	2	s_akers
sakes	9	55	4075	2	s_akes
saner	5	43	3432	2	s_aner
saver	8	48	3125	2	s_aver
sawer	8	50	2621	2	s_awer
sayer	8	49	2655	2	s_ayer
scaler	8	43	2160	2	scaler
scarer	8	45	2461	2	scarer
sealer	6	39	2896	2	sealer
seamer	8	42	2361	2	seamer
searer	6	54	3202	2	searer
seater	6	45	3416	2	seater
seeker	10	36	1536	2	seeker
shader	10	42	1876	2	shader
shake	12	47	2640	2	shake_
shaken	13	41	1361	2	shaken
shakers	14	40	1556	2	shakers
shakes	13	50	2459	2	shakes
shakier	14	34	1115	2	shakier
shaper	11	41	1993	2	shaper
sharer	9	50	2548	2	sharer
sharker	14	43	1381	2	sharker
shaver	12	37	1891	2	shaver
shoaler	10	26	1008	2	shoaler
shocker	16	34	1143	2	shocker
sicker	12	40	2390	2	sicker
siker	9	53	2603	2	s_iker
sinker	10	36	2090	2	sinker
skanker	10	26	848	2	skanker
skater	10	50	1549	2	skater
slacker	13	39	1529	2	slacker
slake	9	37	2405	2	slake_
slaked	11	43	1827	2	slaked
slakers	11	41	1575	2	slakers
slakes	10	40	2188	2	slakes
slater	6	44	2918	2	slater
slaver	9	44	1961	2	slaver
slayer	9	39	1633	2	slayer
smacker	15	34	1058	2	smacker
smoker	12	43	1169	2	smoker
snacker	13	31	1260	2	snacker
snake	9	48	2111	2	snake_
snaked	11	50	1759	2	snaked
snakes	10	39	1960	2	snakes
snakey	13	50	1127	2	snakey
snakier	11	28	1000	2	snakier
snarer	6	46	2084	2	snarer
sneaker	11	29	1045	2	sneaker
snooker	11	39	1030	2	snooker
soak	8	72	2766	2	soak__
soaks	9	52	2029	2	soak_s
soaped	9	58	1797	2	soaped
soapers	9	37	1592	2	soapers
soapier	9	34	1171	2	soapier
soar	4	68	3867	2	soa__r
soared	7	43	2429	2	soared
soarers	7	41	1809	2	soarers
soave	8	42	1905	2	soave_
soaves	9	42	1867	2	soaves
sobber	10	40	1659	2	sobber
sober	7	48	2241	2	so_ber
socager	10	10	770	2	socager
soccer	10	3	854	2	soccer
socked	13	47	2150	2	socked
socket	12	39	2352	2	socket
soever	9	44	1209	2	soever
softer	9	40	1531	2	softer
soke	8	54	3626	2	so_ke_
sokes	9	50	3142	2	so_kes
solacer	9	30	1110	2	solacer
solder	7	39	2134	2	solder
solver	9	40	1670	2	solver
somber	10	37	1400	2	somber
sonder	7	36	2352	2	sonder
sooner	6	42	2046	2	sooner
sorer	5	62	3659	2	so_rer
sorner	6	47	2039	2	sorner
sorter	6	44	2509	2	sorter
sourer	6	36	2021	2	sourer
souter	6	42	2592	2	souter
sower	8	52	2931	2	so_wer
spacer	10	49	1779	2	spacer
spader	9	43	1713	2	spader
spake	11	43	2274	2	spake_
spanker	13	36	1235	2	spanker
sparer	8	45	2496	2	sparer
sparker	13	39	1436	2	sparker
speaker	13	33	1121	2	speaker
spiker	12	43	1566	2	spiker
stacker	13	44	1626	2	stacker
stager	7	48	2134	2	stager
stake	9	59	2753	2	stake_
staked	11	46	2194	2	staked
stakes	10	39	2729	2	stakes
staler	6	40	2582	2	staler
stalker	11	39	1225	2	stalker
starer	6	40	2736	2	starer
starker	11	41	1469	2	starker
stater	6	44	2756	2	stater
stayer	9	45	1648	2	stayer
stocker	13	37	1308	2	stocker
stoker	10	44	1762	2	stoker
stooker	11	38	1173	2	stooker
suaver	9	30	1423	2	suaver
sucker	12	41	2066	2	sucker
sulker	10	40	1592	2	sulker
swager	10	40	1361	2	swager
swanker	14	36	948	2	swanker
swayer	12	52	1097	2	swayer
taker	9	52	2900	2	_taker
toker	9	59	2491	2	to_ker
waker	12	55	2659	2	_waker
weaker	13	40	1544	2	weaker
worker	13	47	1511	2	worker
yonker	13	41	1085	2	yonker

Search took 3 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.360	496363.9
2	DLD Change Limit	82551	173	2.560	32246.5
3	Display Results	173	173	0.063	2746.0
	(SQL Overall)	178691	173	2.983	59903.1