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

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

120 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
crying	12	36	1228	(None)
coying	12	40	2148	1	coying
drying	11	34	1160	1	drying
frying	13	45	1140	1	frying
prying	12	41	1480	1	prying
scrying	13	3	866	1	scrying
trying	10	42	1407	1	trying
wrying	13	37	962	1	wrying
abying	12	44	1041	2	abying
arcing	9	58	1964	2	arcing
arming	9	47	1980	2	arming
baying	12	52	2258	2	baying
braying	13	44	1631	2	braying
bring	8	55	2850	2	br_ing
burying	13	34	1391	2	burying
buying	12	42	1383	2	buying
caging	10	53	2102	2	caging
caking	13	46	2467	2	caking
caning	9	41	2862	2	caning
carding	11	39	2243	2	carding
caring	9	51	3799	2	caring
carking	14	43	2285	2	carking
carling	10	37	2706	2	carling
carping	12	35	2108	2	carping
carrying	14	14	837	2	carrying
carting	10	42	2828	2	carting
carving	13	39	1677	2	carving
casing	9	48	2910	2	casing
caving	12	48	2261	2	caving
cawing	12	43	2261	2	cawing
ceding	10	40	1480	2	ceding
cering	9	45	2253	2	cering
citing	9	42	2018	2	citing
claying	13	36	1430	2	claying
cling	8	64	2467	2	c_ling
cloying	13	35	1175	2	cloying
cluing	9	39	1350	2	cluing
coding	10	40	2479	2	coding
coking	13	45	2388	2	coking
coming	11	42	2545	2	coming
coning	9	43	3182	2	coning
cooing	9	40	2492	2	cooing
coping	11	39	2766	2	coping
copying	15	34	1198	2	copying
cording	11	36	2082	2	cording
coring	9	44	3396	2	coring
corking	14	30	1882	2	corking
corning	10	37	2012	2	corning
cosying	13	45	1313	2	cosying
coting	9	46	2925	2	coting
coving	12	43	2152	2	coving
cowing	12	45	2632	2	cowing
coxing	16	42	1886	2	coxing
cozying	22	30	806	2	cozying
craning	10	36	2030	2	craning
craping	12	40	1871	2	craping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
creping	12	29	1365	2	creping
crewing	13	32	1263	2	crewing
cringe	9	35	1548	2	cr_inge
crowing	13	38	1476	2	crowing
cryingly	17	3	574	2	cryingly
cubing	11	42	1395	2	cubing
cueing	9	49	1361	2	cueing
cuing	8	54	2019	2	c_uing
curbing	12	38	1402	2	curbing
curding	11	35	1513	2	curding
curing	9	48	2478	2	curing
curling	10	43	2018	2	curling
curring	10	36	1684	2	curring
currying	14	19	649	2	currying
cursing	10	42	1703	2	cursing
curving	13	39	1210	2	curving
decrying	15	23	741	2	decrying
draying	12	38	1384	2	draying
dying	10	53	1603	2	_dying
erring	7	38	1648	2	erring
eying	9	61	1792	2	_eying
faying	13	45	2107	2	faying
flying	13	46	1215	2	flying
fraying	14	34	1343	2	fraying
graying	12	41	1588	2	graying
greying	12	41	1089	2	greying
guying	11	37	972	2	guying
gyring	11	39	1036	2	gyring
haying	13	44	2061	2	haying
hying	12	65	1474	2	_hying
iring	6	60	2542	2	ir_ing
irking	11	46	1175	2	irking
joying	17	38	1080	2	joying
jurying	18	33	776	2	jurying
keying	14	3	804	2	keying
laying	10	45	2570	2	laying
lying	9	57	1745	2	_lying
maying	12	44	2115	2	maying
orbing	9	33	1236	2	orbing
paying	12	37	2216	2	paying
plying	12	43	1208	2	plying
praying	13	37	1732	2	praying
preying	13	31	1455	2	preying
raying	10	50	2719	2	raying
ring	5	65	4115	2	_r_ing
ruing	6	72	2105	2	_ruing
ryking	14	34	811	2	_ryking
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
toying	10	50	1730	2	toying
truing	7	39	1393	2	truing
tying	9	60	1984	2	_tying
tyring	10	46	1302	2	tyring
urging	8	34	1312	2	urging
urping	9	39	1405	2	urping
varying	14	2	972	2	varying
vying	12	51	1181	2	_vying
wring	9	59	2071	2	wr_ing

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	120	2.343	35233.0
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	2.732	65406.7