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

Here are the results of your fuzzy-string dictionary search for “abying” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

102 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
abying	12	44	1041	(None)
babying	15	3	796	1	babying
baying	12	52	2258	1	baying
aahing	10	190	1576	2	aahing
abasing	10	6	1067	2	abasing
abating	10	4	1397	2	abating
abiding	11	5	1050	2	abiding
ablings	10	3	874	2	ablings
ablins	8	3	1619	2	ablins
aboding	11	4	1012	2	aboding
abusing	10	4	911	2	abusing
aching	12	65	2197	2	aching
acing	8	74	2915	2	a_cing
acting	9	59	2098	2	acting
adding	9	39	1496	2	adding
adzing	17	41	1001	2	adzing
ageing	8	42	1340	2	ageing
aging	7	70	2635	2	a_ging
ahing	9	89	2835	2	a_hing
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
allying	11	30	1166	2	allying
ambling	12	14	1179	2	ambling
amping	11	43	1757	2	amping
anting	7	58	2702	2	anting
aping	8	73	2723	2	a_ping
arcing	9	58	1964	2	arcing
arming	9	47	1980	2	arming
ashing	10	78	2409	2	ashing
asking	11	60	1723	2	asking
auding	8	36	1693	2	auding
aweing	10	39	1125	2	aweing
awing	9	68	2732	2	a_wing
awning	10	50	1339	2	awning
axing	13	85	2137	2	a_xing
ayin	7	63	3174	2	a_yin_
ayins	8	53	2161	2	a_yins
baaing	9	49	1616	2	baaing
baking	13	56	2662	2	baking
baling	9	48	2969	2	baling
baning	9	51	2783	2	baning
baring	9	51	3585	2	baring
basing	9	54	2766	2	basing
bating	9	51	3225	2	bating
being	8	49	2050	2	_being
boing	8	47	2555	2	_boing
bring	8	55	2850	2	_bring
buying	12	42	1383	2	buying
cabbing	14	36	1315	2	cabbing
cabling	12	40	1755	2	cabling
coying	12	40	2148	2	coying
crying	12	36	1228	2	crying
dabbing	13	35	1123	2	dabbing
drying	11	34	1160	2	drying
dying	10	53	1603	2	_dying
ebbing	11	3	707	2	ebbing
eying	9	61	1792	2	_eying
fabling	13	34	1362	2	fabling
faying	13	45	2107	2	faying
flying	13	46	1215	2	flying
frying	13	45	1140	2	frying
gabbing	13	35	1203	2	gabbing
gabling	11	35	1454	2	gabling
guying	11	37	972	2	guying
gybing	13	35	593	2	gybing
haying	13	44	2061	2	haying
hying	12	65	1474	2	_hying
jabbing	19	31	941	2	jabbing
joying	17	38	1080	2	joying
keying	14	3	804	2	keying
laying	10	45	2570	2	laying
lazying	20	4	667	2	lazying
lying	9	57	1745	2	_lying
maying	12	44	2115	2	maying
nabbing	12	29	996	2	nabbing
obeying	13	3	654	2	obeying
paying	12	37	2216	2	paying
plying	12	43	1208	2	plying
prying	12	41	1480	2	prying
raying	10	50	2719	2	raying
rubying	13	29	793	2	rubying
sabbing	12	33	1474	2	sabbing
sabeing	10	26	1186	2	sabeing
sabring	10	26	1484	2	sabring
saying	10	43	2554	2	saying
shying	13	42	1184	2	shying
skying	14	39	998	2	skying
spying	12	39	1325	2	spying
stying	10	54	1457	2	stying
tabbing	12	36	1191	2	tabbing
tabbying	16	3	397	2	tabbying
tabling	10	32	1603	2	tabling
tabuing	10	30	889	2	tabuing
taxying	18	3	618	2	taxying
toying	10	50	1730	2	toying
trying	10	42	1407	2	trying
tying	9	60	1984	2	_tying
varying	14	2	972	2	varying
vying	12	51	1181	2	_vying
wrying	13	37	962	2	wrying

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	82551	0.346	516448.0
2	DLD Change Limit	82551	102	2.640	31269.3
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	3.016	59247.7