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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

82 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
smock	13	53	1167	(None)
mock	12	64	2944	1	_mock
shock	14	49	1703	1	shock
smack	13	46	1545	1	smack
smocks	14	57	1001	1	smocks
sock	10	52	3321	1	s_ock
stock	11	44	1756	1	stock
acock	13	21	1021	2	acock
amok	10	2	1740	2	amo_k
amuck	13	8	956	2	amuck
bemock	16	3	617	2	bemock
block	13	49	1784	2	block
bock	12	60	3251	2	_bock
brock	13	60	1707	2	brock
chock	16	43	1661	2	chock
clock	13	49	1798	2	clock
cock	12	63	3290	2	_cock
crock	13	59	2199	2	crock
dock	11	62	2874	2	_dock
flock	14	47	1742	2	flock
frock	14	53	1465	2	frock
hock	13	60	3130	2	_hock
jock	17	65	2264	2	_jock
knock	10	48	796	2	knock
lock	10	61	3436	2	_lock
mack	12	57	3365	2	_mack
mick	12	63	3343	2	_mick
moc	7	78	4508	2	_moc_
mocks	13	50	2382	2	_mocks
mocs	8	58	3490	2	_mocs
monk	10	59	2852	2	_monk
mosk	10	56	2244	2	_mosk
muck	12	57	2785	2	_muck
nock	10	61	2718	2	_nock
pock	12	61	2929	2	_pock
rock	10	57	3518	2	_rock
sack	10	53	3731	2	s_ack
shack	14	53	2175	2	shack
shlock	15	37	819	2	shlock
shmuck	17	3	424	2	shmuck
shocks	15	44	1458	2	shocks
shook	12	49	2016	2	shook
shuck	14	43	1453	2	shuck
sick	10	64	3557	2	s_ick
slack	11	50	2176	2	slack
slick	11	55	2052	2	slick
smacks	14	41	1232	2	smacks
smeek	11	49	1235	2	smeek
smerk	11	54	1272	2	smerk
smirk	11	66	1275	2	smirk
smocked	16	39	822	2	smocked
smog	7	63	1741	2	smo_g
smogs	8	51	1216	2	smogs
smoke	11	50	1582	2	smoke
smoky	14	38	868	2	smoky
smolt	7	48	2416	2	smolt
smooch	13	26	680	2	smooch
smote	7	58	2028	2	smote
snack	11	47	1806	2	snack
sneck	11	47	1366	2	sneck
snick	11	44	1601	2	snick
snook	9	51	1557	2	snook
snuck	11	44	1191	2	snuck
soak	8	72	2766	2	s_oak
soca	6	63	3005	2	s_oca
socko	11	52	1511	2	s_ocko
socks	11	49	2608	2	s_ocks
sook	8	49	3339	2	s_ook
souk	8	61	2717	2	s_ouk
speck	13	51	1565	2	speck
spick	13	45	1907	2	spick
spook	11	54	1604	2	spook
stack	11	44	2169	2	stack
stick	11	51	2156	2	stick
stocks	12	47	1563	2	stocks
stocky	15	36	915	2	stocky
stook	9	52	1821	2	stook
stork	9	68	1969	2	stork
stuck	11	45	1577	2	stuck
suck	10	61	3173	2	s_uck
trock	11	48	1760	2	trock
yock	13	59	2461	2	_yock

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.093	1921408.6
2	DLD Change Limit	53800	82	1.610	33416.1
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	1.736	102932.6