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

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

83 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
tokens	10	47	1156	(None)
token	9	54	1931	1	token_
tokers	10	48	1889	1	tokers
tokes	9	52	3497	1	toke_s
betokens	14	32	457	2	betokens
codens	9	48	2101	2	codens
cokes	11	55	3719	2	coke_s
copens	10	61	1996	2	copens
covens	11	49	1926	2	covens
cozens	17	63	1492	2	cozens
dovens	10	44	1390	2	dovens
doyens	10	48	1022	2	doyens
dozens	16	46	1246	2	dozens
hokes	12	62	3164	2	hoke_s
jokers	17	55	1119	2	jokers
jokes	16	54	2333	2	joke_s
kens	8	54	3523	2	__kens
likens	10	56	1370	2	likens
lodens	7	43	1506	2	lodens
mokes	11	46	3103	2	moke_s
okehs	12	47	746	2	_okehs
okes	8	49	3634	2	_oke_s
omens	7	56	1896	2	_omens
opens	7	61	1855	2	_opens
ovens	8	62	1745	2	_ovens
pokers	12	46	1792	2	pokers
pokes	11	61	3301	2	poke_s
pokeys	15	52	951	2	pokeys
rouens	6	48	1444	2	rouens
rowens	9	45	1530	2	rowens
sokes	9	50	3142	2	soke_s
sowens	9	36	1315	2	sowens
stokers	11	45	1518	2	stokers
stokes	10	48	2179	2	stoke_s
taken	9	48	1914	2	taken_
takers	10	39	2374	2	takers
takes	9	44	3779	2	take_s
takins	10	51	1740	2	takins
teens	5	62	2748	2	t_eens
tens	4	56	4741	2	t__ens
thens	8	59	2183	2	t_hens
tikes	9	56	2890	2	tike_s
toeas	5	57	2642	2	to_eas
toes	4	69	5644	2	to_e_s
tokays	13	39	777	2	tokays
toke	8	67	3849	2	toke__
toked	10	56	2649	2	toke_d
tokened	12	3	639	2	tokened
tokenism	14	4	540	2	tokenism
toker	9	59	2491	2	toke_r
toking	11	44	2072	2	toking
tolans	6	43	1927	2	tolans
toles	5	51	4713	2	tole_s
tomans	8	54	1913	2	tomans
tomes	7	60	3738	2	tome_s
toners	6	41	2800	2	toners
tones	5	60	4866	2	tone_s
tonnes	6	53	2085	2	tonnes
tons	4	65	5305	2	to__ns
toons	5	50	2753	2	to_ons
topees	8	55	1970	2	topees
topers	8	50	2532	2	topers
topes	7	69	4176	2	tope_s
tores	5	53	5267	2	tore_s
totems	8	68	1076	2	totems
toters	6	50	2636	2	toters
totes	5	51	3968	2	tote_s
towels	9	43	1464	2	towels
towers	9	44	2367	2	towers
towns	8	60	1888	2	to_wns
toxins	13	33	1428	2	toxins
toyers	9	55	1633	2	toyers
toyons	9	55	1213	2	toyons
treens	6	53	1787	2	treens
triens	6	54	1754	2	triens
trokes	10	40	1926	2	troke_s
tweens	9	48	984	2	tweens
tykes	12	58	1706	2	tyke_s
wakens	13	50	1204	2	wakens
woken	12	46	1497	2	woken_
wovens	12	44	983	2	wovens
yokels	13	48	806	2	yokels
yokes	12	52	2302	2	yoke_s

Search took 9 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.453	394461.4
2	DLD Change Limit	82551	83	7.143	11556.9
3	Display Results	83	83	0.076	1092.1
	(SQL Overall)	178691	83	7.672	23291.3