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

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

60 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
bifocal	14	4	537	(None)
bifocals	15	4	370	1	bifocals
bifacial	15	10	527	2	bifacial
bifocaled	17	4	246	2	bifocaled
bimodal	12	4	566	2	bimodal
bizonal	18	4	556	2	bizonal
epifocal	15	4	379	2	epifocal
focal	10	49	1767	2	__focal
trifocal	13	4	503	2	trifocal
befool	11	3	771	3	befo_ol
befoul	11	3	725	3	befo_ul
biaxal	15	3	609	3	bi_axal
biaxial	16	4	536	3	biaxial
biblical	14	4	592	3	biblical
biface	13	5	810	3	bifac_e
bifaces	14	4	806	3	bifaces
bifilar	12	4	404	3	bifilar
bifold	12	3	722	3	bifo_ld
biforate	13	4	690	3	biforate
biform	13	6	812	3	bifo_rm
bimetal	11	3	843	3	bimetal
binal	7	53	2382	3	bi__nal
binocle	11	3	649	3	binocle
binocs	10	3	992	3	binoc_s
binomial	12	4	622	3	binomial
biocidal	13	4	494	3	bi_ocidal
biofuel	12	4	329	3	biofuel
biogas	9	43	1091	3	bi_ogas
biosocial	13	4	404	3	biosocial
biota	7	45	1682	3	bi_ota_
biotas	8	43	1392	3	bi_otas
biotical	12	4	886	3	biotical
bipedal	12	4	568	3	bipedal
bipolar	11	4	545	3	bipolar
biracial	12	10	797	3	biracial
birdcall	13	4	369	3	birdcall
bivouac	14	4	257	3	bivouac
boral	7	58	3170	3	b__oral
bromal	10	3	1365	3	b_romal
buccal	12	4	824	3	b_uccal
confocal	15	4	630	3	confocal
deifical	14	4	554	3	deifical
fecal	10	51	1921	3	__fecal
finical	12	3	970	3	finical
fiscal	11	3	933	3	fi_scal
foal	7	66	3092	3	__fo_al
litoral	7	6	1076	3	litoral
local	7	48	2027	3	__local
mimical	13	3	923	3	mimical
nonfocal	13	4	644	3	nonfocal
parfocal	15	6	539	3	parfocal
pedocal	12	3	789	3	pedocal
pical	9	55	2437	3	pi__cal
pivotal	12	4	543	3	pivotal
tical	7	60	2149	3	ti__cal
tincal	8	39	1337	3	ti_ncal
trifocals	14	4	404	3	trifocals
univocal	13	4	366	3	univocal
unvocal	12	4	523	3	unvocal
vocal	10	47	1564	3	__vocal

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	134027	1.046	170832.7
2	DLD Change Limit	134027	60	7.640	17542.8
3	Display Results	60	60	0.016	3750.0
	(SQL Overall)	178691	60	8.702	20534.5