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

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

88 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
benefic	14	4	604	(None)
benefice	15	4	500	1	benefice
benefit	12	4	807	1	benefit
benedick	17	4	309	2	benedick
benedict	13	4	642	2	benedict
beneficed	17	4	353	2	beneficed
benefices	16	4	506	2	benefices
benefits	13	4	571	2	benefits
benthic	14	3	747	2	benthic
benzoic	20	4	503	2	benzoic
generic	10	13	1075	2	generic
genetic	10	12	1178	2	genetic
agenetic	11	3	820	3	agenetic
amnesic	11	3	718	3	amnesic
anemic	10	27	1369	3	_anemic
apneic	10	7	862	3	apne_ic
baneful	12	3	789	3	baneful
barefit	12	4	972	3	barefit
beatific	15	4	422	3	beatific
bedevil	13	4	451	3	bedevil
beedi	8	7	1166	3	be_edi_
beef	9	62	3367	3	be_ef__
beefed	12	35	1087	3	be_efed
beefier	12	32	909	3	be_efier
beefily	15	3	561	3	be_efily
beefing	13	39	1147	3	be_efing
beefs	10	56	1856	3	be_ef_s
beefy	13	53	1383	3	be_ef_y
befit	10	52	2266	3	b__efit
bene	6	64	3949	3	bene___
beneath	12	3	697	3	beneath
benedicks	18	4	256	3	benedicks
benedicts	14	4	357	3	benedicts
beneficent	17	5	412	3	benefic~~ent~~
beneficial	17	5	323	3	benefic~~ial~~
beneficing	18	4	382	3	benefic~~ing~~
benefited	15	4	417	3	benefited
benefiter	14	4	373	3	benefiter
benempt	13	4	626	3	benempt
benes	7	55	3623	3	bene__s
benni	7	47	1536	3	ben_ni_
bennis	8	43	1480	3	ben_nis
benzin	17	3	893	3	ben_zin
benzoin	18	4	626	3	benzoin
benzylic	24	4	228	3	benzylic
bereft	11	43	1730	3	beref_t
beylic	13	3	782	3	be_ylic
bigeneric	14	4	358	3	bigeneric
bluefin	12	4	512	3	bluefin
bonefish	16	4	628	3	bonefish
centric	11	3	1239	3	centric
deific	12	3	731	3	de_ific
dineric	10	3	1097	3	dineric
ecesic	10	36	922	3	_ecesic
edenic	9	3	1022	3	_edenic
emetic	10	6	1445	3	_emetic
enatic	8	3	1756	3	_enatic
endemic	12	3	789	3	_endemic
enolic	8	4	1335	3	_enolic
enteric	9	3	1421	3	_enteric
fanfic	14	3	631	3	fan_fic
frenetic	13	4	629	3	frenetic
generics	11	11	879	3	generics
genesis	8	25	1082	3	genesis
genetics	11	12	861	3	genetics
genic	8	51	1939	3	gen__ic
genomic	12	3	792	3	genomic
gynecic	15	8	435	3	gynecic
hebetic	14	3	863	3	hebetic
heretic	12	3	1483	3	heretic
kenotic	13	5	970	3	kenotic
kinesic	13	25	702	3	kinesic
kinetic	13	20	917	3	kinetic
lentic	8	35	1574	3	len_tic
lexemic	18	4	428	3	lexemic
malefic	14	8	632	3	malefic
omnific	14	4	381	3	omnific
phenetic	15	4	920	3	phenetic
selenic	9	4	1066	3	selenic
sememic	13	3	650	3	sememic
senecio	9	4	720	3	senecio
tenesmic	12	4	429	3	tenesmic
terebic	11	3	798	3	terebic
tonemic	11	3	1016	3	tonemic
tonetic	9	3	1343	3	tonetic
unific	11	3	746	3	_unific
venatic	12	3	1152	3	venatic
xenic	14	41	1464	3	xen__ic

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	0.186	960704.3
2	DLD Change Limit	134027	88	8.283	16181.0
3	Display Results	88	88	0.060	1466.7
	(SQL Overall)	178691	88	8.529	20951.0