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

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

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.

86 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
sidebars	11	4	663	(None)
sidebar	10	4	556	1	sidebar_
sidecars	11	4	590	1	sidecars
debars	9	42	1804	2	__debars
sidearm	10	3	596	2	side_arm
sidearms	11	4	409	2	side_arms
sideband	12	4	502	2	sideband
sidebands	13	4	444	2	sidebands
sideboard	13	4	517	2	sideboard
sideboards	14	4	463	2	sideboards
sideburns	12	4	209	2	sideburns
sidecar	10	4	523	2	sidecar_
sideward	13	4	594	2	sideward
sidewards	14	4	505	2	sidewards
sideways	15	4	523	2	sideways
aiders	7	45	2463	3	aide__rs
biders	9	48	2280	3	bide__rs
ciders	9	46	2008	3	cide__rs
cudbears	13	4	347	3	cudbears
dears	6	57	3688	3	__de_ars
debags	10	42	1106	3	__debags
debar	8	55	1786	3	__debar_
debark	13	42	1094	3	__debark
debarks	14	38	849	3	__debarks
denars	7	46	2143	3	__denars
dewars	10	51	1707	3	__dewars
disbars	10	3	1032	3	di_sbars
eiders	7	43	2136	3	eide__rs
endears	8	37	1005	3	ende_ars
eyebars	12	4	533	3	_eyebars
hiders	10	49	1965	3	hide__rs
ideals	7	50	1250	3	_ide_als
ideas	6	59	1901	3	_ide_a_s
isobars	9	3	657	3	_isobars
kebars	12	41	1249	3	__kebars
kilobars	14	4	492	3	kilobars
lidars	7	3	1078	3	lid__ars
midyears	14	4	340	3	midyears
mimbars	13	9	737	3	mi_mbars
minibars	12	9	654	3	minibars
ninebark	14	4	425	3	ninebark
ninebarks	15	4	368	3	ninebarks
rebars	8	40	1982	3	__rebars
redears	8	28	1445	3	rede_ars
riders	7	41	2390	3	ride__rs
sambars	11	51	1384	3	s_ambars
sandbars	11	10	878	3	sandbars
scimetars	13	4	401	3	scimetars
sears	5	47	4491	3	s__e_ars
seders	7	44	2028	3	sede__rs
sewars	9	40	1862	3	s__ewars
shears	9	38	2090	3	s_he_ars
shmears	12	7	707	3	shme_ars
sickbays	19	4	316	3	sickbays
siddurs	9	3	417	3	sid_durs
sideman	10	3	797	3	sidema_n
sides	6	58	3836	3	side___s
sidewalk	16	4	409	3	sidewalk
sidewalks	17	4	353	3	sidewalks
sidewall	12	4	480	3	sidewall
sidewalls	13	4	428	3	sidewalls
sideway	14	4	567	3	sidewa_y
sidlers	8	34	1422	3	sid_lers
sierras	7	3	786	3	si_erras
sieurs	6	5	904	3	si_e_urs
simars	8	49	1693	3	si__mars
simitars	10	4	648	3	simitars
simulars	10	4	707	3	simulars
sirdars	8	22	821	3	si_rdars
sitars	6	54	1759	3	si__tars
sivers	9	53	2415	3	sive__rs
sizars	15	48	1262	3	si__zars
sizers	15	52	1581	3	size__rs
sliders	8	35	1522	3	slide__rs
slideways	16	4	285	3	slideways
smears	8	47	1443	3	s_me_ars
spears	8	40	1947	3	s_pe_ars
spiders	10	39	1441	3	spide__rs
swears	9	41	1407	3	s_we_ars
tidemark	15	4	339	3	tidemark
tidemarks	16	4	306	3	tidemarks
tideways	15	4	456	3	tideways
typebars	15	4	248	3	typebars
vinegars	12	4	506	3	vinegars
wideband	15	4	445	3	wideband
wideners	12	25	799	3	wideners

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	86	7.813	18707.5
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.999	22339.2