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

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

90 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
serging	9	34	1667	(None)
merging	11	27	1176	1	merging
sergings	10	29	921	1	sergings
sering	7	47	3181	1	ser_ing
serving	11	30	1498	1	serving
surging	9	31	1543	1	surging
verging	12	38	1230	1	verging
barging	11	40	1848	2	barging
begging	12	30	1265	2	begging
berming	12	36	1483	2	berming
cering	9	45	2253	2	cer_ing
edging	9	35	1071	2	_edging
egging	9	32	1098	2	_egging
emerging	12	3	789	2	emerging
erring	7	38	1648	2	_erring
forging	12	41	1472	2	forging
gorging	10	26	1136	2	gorging
gurging	10	29	1011	2	gurging
hedging	13	34	895	2	hedging
herding	12	29	1512	2	herding
herring	11	36	1588	2	herring
jerking	19	30	892	2	jerking
kedging	14	35	756	2	kedging
kegging	14	32	829	2	kegging
kerbing	14	30	848	2	kerbing
kerfing	15	30	753	2	kerfing
kerning	12	40	1089	2	kerning
legging	10	39	1264	2	legging
nerving	11	29	1083	2	nerving
parging	11	33	1860	2	parging
pegging	12	28	1113	2	pegging
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
purging	11	33	1418	2	purging
sagging	10	31	1610	2	sagging
scrying	13	3	866	2	scrying
seagoing	10	3	819	2	seagoing
sealing	8	35	2856	2	sealing
seaming	10	32	2211	2	seaming
searing	8	33	3092	2	searing
seating	8	41	3068	2	seating
seeding	9	37	1948	2	seeding
seeing	7	42	2214	2	se_eing
seeking	12	40	1606	2	seeking
seeling	8	35	2200	2	seeling
seeming	10	32	1626	2	seeming
seeping	10	38	1791	2	seeping
seining	8	40	2077	2	seining
seising	8	40	1886	2	seising
seizing	17	41	1483	2	seizing
selfing	11	29	1162	2	selfing
selling	8	32	2583	2	selling
sending	9	42	2137	2	sending
sensing	8	41	1695	2	sensing
serein	6	33	1846	2	serein_
sereins	7	37	1612	2	sereins
serin	5	54	3444	2	ser_in_
serine	6	54	3267	2	ser_ine
seringa	8	33	1074	2	ser_inga
serins	6	40	2967	2	ser_ins
serrying	12	16	770	2	serrying
servings	12	24	922	2	servings
setting	8	36	2139	2	setting
sewing	10	38	1962	2	se_wing
sexing	14	43	1389	2	se_xing
sieging	9	26	1320	2	sieging
singing	9	32	2142	2	singing
siring	7	51	2831	2	sir_ing
sledging	11	28	818	2	sledging
smerking	15	25	847	2	smerking
sorbing	10	28	1526	2	sorbing
soring	7	47	3188	2	sor_ing
sorning	8	31	1681	2	sorning
sorting	8	32	2181	2	sorting
sparging	12	26	1113	2	sparging
spring	9	45	2601	2	spr_ing
staging	9	38	1837	2	staging
sterling	9	36	1555	2	sterling
string	7	53	2756	2	str_ing
surfing	11	29	1448	2	surfing
swaging	12	42	1063	2	swaging
swerving	15	4	611	2	swerving
terming	10	40	1600	2	terming
urging	8	34	1312	2	_urging
vegging	13	30	887	2	vegging
venging	12	37	1094	2	venging
versing	11	23	1419	2	versing
wedging	13	30	872	2	wedging
yerking	15	36	881	2	yerking
zeroing	17	3	834	2	zeroing

Search took 5 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.403	443402.0
2	DLD Change Limit	107671	90	3.656	29450.5
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	4.092	43668.4