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

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

83 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
lysing	10	47	1044	(None)
lasing	7	47	2798	1	lasing
losing	7	40	2287	1	losing
lying	9	57	1745	1	ly_ing
lysin	8	45	1278	1	lysin_
lysine	9	42	1055	1	lysine
lysins	9	46	1095	1	lysins
basing	9	54	2766	2	basing
busing	9	64	2059	2	busing
casing	9	48	2910	2	casing
closing	10	31	1484	2	closing
dosing	8	39	2027	2	dosing
dyeing	11	42	821	2	dyeing
dying	10	53	1603	2	dy_ing
dyking	15	45	801	2	dyking
easing	7	49	2646	2	easing
eyeing	10	42	936	2	eyeing
eying	9	61	1792	2	ey_ing
flying	13	46	1215	2	fly_ing
flyting	14	37	855	2	flyting
fusing	10	44	1595	2	fusing
gybing	13	35	593	2	gybing
gyring	11	39	1036	2	gyring
gyving	14	41	571	2	gyving
hosing	10	34	2110	2	hosing
hying	12	65	1474	2	hy_ing
hyping	15	40	848	2	hyping
lacing	9	46	2623	2	lacing
lading	8	42	2712	2	lading
laking	11	50	2704	2	laking
laming	9	45	2836	2	laming
lapsing	10	35	1116	2	lapsing
lashing	11	44	2289	2	lashing
lasting	8	47	2524	2	lasting
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
laying	10	45	2570	2	laying
lazing	16	48	2147	2	lazing
leasing	8	39	2016	2	leasing
lensing	8	40	1510	2	lensing
liking	11	43	1958	2	liking
liming	9	40	2124	2	liming
ling	5	74	4796	2	l__ing
lining	7	45	2680	2	lining
lisping	10	34	1275	2	lisping
listing	8	40	2059	2	listing
living	10	43	1832	2	living
looing	7	36	2104	2	looing
loosing	8	35	1596	2	loosing
loping	9	39	2141	2	loping
losings	8	28	1062	2	losings
lousing	8	38	1773	2	lousing
loving	10	44	1672	2	loving
lowing	10	46	2327	2	lowing
loxing	14	36	1527	2	loxing
lubing	9	41	1404	2	lubing
luging	8	39	1529	2	luging
luring	7	38	2075	2	luring
lushing	11	43	1611	2	lushing
lusting	8	36	1932	2	lusting
luting	7	52	2175	2	luting
lyings	10	48	850	2	ly_ings
lysines	10	36	909	2	lysines
lysis	8	45	1146	2	lysi_s
musing	9	39	1950	2	musing
nosing	7	34	1984	2	nosing
plying	12	43	1208	2	ply_ing
posing	9	39	2264	2	posing
rasing	7	43	3083	2	rasing
rising	7	40	2588	2	rising
rosing	7	39	2559	2	rosing
ryking	14	34	811	2	ryking
sing	5	75	4417	2	__sing
tying	9	60	1984	2	ty_ing
tyning	10	55	1041	2	tyning
typing	12	41	1058	2	typing
tyring	10	46	1302	2	tyring
using	6	63	1796	2	_using
vising	10	39	1587	2	vising
vying	12	51	1181	2	vy_ing
wising	10	33	1822	2	wising
wyling	13	36	855	2	wyling
wyting	13	27	724	2	wyting

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	83	2.436	33887.9
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	2.812	63545.9