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

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

93 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
sidecars	11	4	590	(None)
sidebars	11	4	664	1	sidebars
sidecar	10	4	523	1	sidecar_
sidearm	10	3	597	2	side_arm
sidearms	11	4	409	2	side_arms
sidebar	10	4	556	2	sidebar_
sideward	13	4	595	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	2009	3	cide__rs
dears	6	57	3688	3	__de_ars
debars	9	42	1804	3	__debars
decafs	12	40	1088	3	__decafs
decals	9	37	1771	3	__decals
decare	9	39	1915	3	__decare
decares	10	28	1853	3	__decares
decays	12	46	1291	3	__decays
decors	9	40	1777	3	__decors
denars	7	46	2143	3	__denars
dewars	10	51	1707	3	__dewars
eiders	7	43	2136	3	eide__rs
endears	8	37	1005	3	ende_ars
hiders	10	49	1965	3	hide__rs
icecaps	13	4	386	3	_icecaps
ideals	7	50	1250	3	_ide_als
ideas	6	59	1901	3	_ide_a_s
ipecacs	13	5	450	3	_ipecacs
lidars	7	3	1078	3	lid__ars
lifecare	13	6	411	3	lifecare
lifecares	14	6	381	3	lifecares
midyears	14	4	340	3	midyears
minicars	12	11	852	3	minicars
piecers	11	41	1225	3	pi_ecers
redears	8	28	1445	3	rede_ars
ricercars	13	5	355	3	ricercars
riders	7	41	2390	3	ride__rs
scars	7	54	3353	3	s___cars
scimetars	13	4	401	3	scimetars
sears	5	47	4491	3	s__e_ars
secpars	11	3	841	3	s__ecpars
seders	7	44	2028	3	sede__rs
seducers	11	4	538	3	seducers
senecas	9	3	901	3	seneca_s
sewars	9	40	1863	3	s__ewars
shears	9	38	2090	3	s_he_ars
shmears	12	7	707	3	shme_ars
siddurs	9	3	417	3	sid_durs
sideband	12	4	502	3	sideband
sidebands	13	4	444	3	sidebands
sideboard	13	4	517	3	sideboard
sideboards	14	4	464	3	sideboards
sideburns	12	4	210	3	sideburns
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	1423	3	sid_lers
sierras	7	3	786	3	si_erras
sieurs	6	5	904	3	si_e_urs
silencers	11	4	528	3	silencers
silicas	9	3	1060	3	silica_s
simars	8	49	1693	3	si__mars
simitars	10	4	648	3	simitars
simulars	10	4	707	3	simulars
sinecure	10	4	432	3	sinecure
sinecures	11	4	454	3	sinecures
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
soucars	9	3	842	3	s_oucars
sowcars	12	3	601	3	s_owcars
spears	8	40	1947	3	s_pe_ars
spiders	10	39	1441	3	spide__rs
supercars	13	4	1014	3	supercars
swears	9	41	1407	3	s_we_ars
tidemark	15	4	340	3	tidemark
tidemarks	16	4	307	3	tidemarks
tideways	15	4	456	3	tideways
timecard	13	4	399	3	timecard
timecards	14	4	328	3	timecards
vicars	11	7	1226	3	vi__cars
vinegars	12	4	506	3	vinegars
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.406	440125.6
2	DLD Change Limit	146162	93	7.593	19249.6
3	Display Results	93	93	0.033	2818.2
	(SQL Overall)	178691	93	8.032	22247.4