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

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

66 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
locals	8	37	1450	(None)
local	7	48	2027	1	local_
locale	8	39	1565	1	locale
locales	9	37	1509	1	locales
vocals	11	38	1158	1	vocals
borals	8	67	2191	2	borals
coals	7	61	2960	2	co_als
cocas	9	59	2657	2	coca_s
copals	10	50	1894	2	copals
corals	8	53	2514	2	corals
decals	9	37	1771	2	decals
florals	10	42	1006	2	florals
foals	8	57	2169	2	fo_als
focal	10	49	1767	2	focal_
goals	6	55	2129	2	go_als
gorals	7	69	1765	2	gorals
jacals	15	3	987	2	jacals
jouals	13	3	892	2	jouals
legals	7	34	1273	2	legals
loads	6	53	2337	2	lo_ads
loafs	8	56	1699	2	lo_afs
loams	7	56	1986	2	lo_ams
loans	5	60	2646	2	lo_ans
loca	6	55	2768	2	loca__
localise	10	15	1185	2	localise
localism	12	13	1001	2	localism
localist	10	16	1396	2	localist
locally	12	17	972	2	locally
locate	8	39	1984	2	locate
locates	9	32	1881	2	locates
lochans	12	4	883	2	lochans
lochs	10	67	1551	2	loc_hs
locks	11	51	2692	2	loc_ks
locoes	8	55	1658	2	locoes
locos	7	58	2260	2	loc_os
locule	8	34	1203	2	locule
locules	9	28	1260	2	locules
loculi	8	28	825	2	loculi
loculus	9	29	697	2	loculus
locums	10	47	830	2	locums
locus	7	48	1999	2	loc_us
logans	7	63	1906	2	logans
lolls	5	121	2173	2	lo_lls
loral	5	59	2782	2	loral_
lorans	6	51	1760	2	lorans
losels	6	47	1458	2	losels
lotahs	9	47	987	2	lotahs
lotas	5	59	2630	2	lota_s
lovats	9	3	907	2	lovats
loyal	8	45	1348	2	loyal_
modals	9	39	1444	2	modals
morals	8	53	2463	2	morals
nopals	8	49	1402	2	nopals
ocas	6	67	2963	2	_oca_s
opals	7	57	1835	2	_opals
orals	5	58	2648	2	_orals
ovals	8	54	1339	2	_ovals
royals	9	37	1126	2	royals
socas	7	40	2618	2	soca_s
socials	9	9	963	2	socials
ticals	8	32	1471	2	ticals
totals	6	31	1516	2	totals
vocabs	13	33	631	2	vocabs
vocal	10	47	1564	2	vocal_
zocalo	17	3	580	2	zocalo
zocalos	18	3	539	2	zocalos

Search took 4 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.106	1685764.2
2	DLD Change Limit	82551	66	2.940	28078.6
3	Display Results	66	66	0.013	5076.9
	(SQL Overall)	178691	66	3.059	58414.8