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

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

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
beefing	13	39	1147	(None)
beeping	12	40	1391	1	beeping
reefing	11	40	1686	1	reefing
baffing	16	40	1160	2	baffing
barfing	13	46	1509	2	barfing
beading	11	32	2186	2	beading
beaming	12	36	1880	2	beaming
beaning	10	38	2068	2	beaning
bearing	10	36	2477	2	bearing
beating	10	43	2687	2	beating
becking	16	44	1607	2	becking
bedding	12	41	1448	2	bedding
bedewing	15	3	714	2	bedewing
beefier	12	32	909	2	beefier
beefily	15	3	561	2	beefily
beeline	9	33	1472	2	beeline
beeswing	14	25	576	2	beeswing
beetling	11	3	928	2	beetling
begging	12	30	1265	2	begging
being	8	49	2050	2	b_e_ing
belling	10	38	2507	2	belling
belting	10	41	1913	2	belting
belying	13	36	1244	2	belying
bending	11	44	2089	2	bending
berming	12	36	1483	2	berming
besting	10	49	2392	2	besting
betting	10	39	2140	2	betting
beveling	14	30	1103	2	beveling
biffing	16	35	1001	2	biffing
bleeding	12	35	905	2	bleeding
bleeping	13	37	793	2	bleeping
boffing	16	33	998	2	boffing
breeding	12	34	1184	2	breeding
breezing	20	36	813	2	breezing
brewing	13	34	1115	2	brewing
briefing	14	3	694	2	briefing
buffing	16	34	1139	2	buffing
chefing	16	35	903	2	chefing
deeding	10	33	1512	2	deeding
deeming	11	39	1312	2	deeming
feeding	12	35	1507	2	feeding
feeing	10	44	1650	2	fee_ing
feeling	11	36	1707	2	feeling
feezing	20	46	1016	2	feezing
geeing	8	43	1377	2	gee_ing
heeding	12	35	1506	2	heeding
heeling	11	36	1851	2	heeling
heezing	20	34	987	2	heezing
jeeing	14	45	1214	2	jee_ing
jeeping	17	40	1033	2	jeeping
jeering	15	35	1304	2	jeering
keeking	11	42	1089	2	keeking
keeling	12	35	1512	2	keeling
keening	12	37	1315	2	keening
keeping	14	40	1254	2	keeping
kerfing	15	30	753	2	kerfing
leafing	11	33	1358	2	leafing
leering	8	34	1764	2	leering
meeting	10	33	1496	2	meeting
needing	9	32	1442	2	needing
peeing	9	46	1808	2	pee_ing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peeping	12	36	1521	2	peeping
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
reeding	9	41	2413	2	reeding
reeking	12	33	1864	2	reeking
reeling	8	31	2686	2	reeling
reeving	11	37	1766	2	reeving
reffing	14	37	1217	2	reffing
seeding	9	37	1948	2	seeding
seeing	7	42	2214	2	see_ing
seeking	12	40	1606	2	seeking
seeling	8	35	2200	2	seeling
seeming	10	32	1626	2	seeming
seeping	10	38	1791	2	seeping
selfing	11	29	1162	2	selfing
teeing	7	39	1697	2	tee_ing
teeming	10	35	1309	2	teeming
veering	11	32	1368	2	veering
weeding	12	38	1521	2	weeding
weening	11	41	1397	2	weening
weeping	13	36	1367	2	weeping
weeting	11	38	1605	2	weeting

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	107671	0.376	475242.0
2	DLD Change Limit	107671	86	3.000	35890.3
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	3.409	52417.4