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

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

98 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
ravings	11	46	1450	(None)
cavings	13	47	1254	1	cavings
cravings	14	42	822	1	cravings
pavings	13	40	1163	1	pavings
racings	10	50	1513	1	racings
ratings	8	42	1741	1	ratings
ravines	10	42	2023	1	ravines
raving	10	51	2885	1	raving_
ravins	9	46	2256	1	ravin_s
rovings	11	43	949	1	rovings
savings	11	44	1295	1	savings
agings	8	63	1267	2	_agings
armings	10	38	1150	2	armings
bakings	14	43	1202	2	bakings
bracings	13	36	929	2	bracings
braving	13	37	1461	2	braving_
carvings	14	38	1021	2	carvings
casings	10	40	1351	2	casings
caving	12	48	2261	2	caving_
covings	13	45	1124	2	covings
craving	13	40	1573	2	craving_
darings	9	37	1365	2	darings
drawings	13	38	628	2	drawings
drivings	13	26	576	2	drivings
earings	8	45	1771	2	earings
eatings	8	46	1644	2	eatings
facings	13	45	1126	2	facings
fadings	12	46	930	2	fadings
framings	14	33	813	2	framings
frayings	15	32	599	2	frayings
gamings	11	46	1091	2	gamings
gatings	9	52	1282	2	gatings
gratings	10	39	1076	2	gratings
graving	12	31	1456	2	graving_
grazings	19	33	726	2	grazings
having	13	42	2037	2	having_
hayings	14	37	939	2	hayings
hazings	20	37	834	2	hazings
lacings	10	50	1365	2	lacings
ladings	9	38	1413	2	ladings
lakings	12	47	1351	2	lakings
laving	10	46	2357	2	laving_
lawings	11	36	1147	2	lawings
leavings	12	40	749	2	leavings
livings	11	40	892	2	livings
makings	14	54	1316	2	makings
matings	10	45	1621	2	matings
mavins	11	51	1918	2	mavin_s
mayings	13	44	1051	2	mayings
pagings	11	44	1106	2	pagings
palings	10	39	1582	2	palings
parings	10	42	1921	2	parings
paving	12	45	1974	2	paving_
pavins	11	49	1966	2	pavin_s
racing	9	50	3053	2	racing_
raging	8	51	2643	2	raging_
railings	9	34	1215	2	railings
rains	5	51	4023	2	ra_in_s
raisings	9	33	844	2	raisings
raking	11	47	2842	2	raking_
rankings	13	38	917	2	rankings
rapines	9	51	2086	2	rapines
raping	9	48	2985	2	raping_
raring	7	43	3287	2	raring_
rasing	7	43	3083	2	rasing_
raspings	11	33	785	2	raspings
ratines	7	53	2858	2	ratines
rating	7	49	3870	2	rating_
ravelings	13	37	738	2	ravelings
ravenings	13	23	518	2	ravenings
ravens	9	39	1688	2	raven_s
ravin	8	56	2465	2	ravin__
ravine	9	55	2222	2	ravin_e
ravined	11	54	1182	2	ravined
ravingly	15	3	729	2	ravingly
rawins	9	56	1762	2	rawin_s
raxing	14	43	2102	2	raxing_
raying	10	50	2719	2	raying_
razing	16	45	2454	2	razing_
readings	10	35	1264	2	readings
reaving	11	38	2053	2	reaving_
ridings	9	34	1209	2	ridings
rings	6	50	2917	2	r__ings
risings	8	32	1189	2	risings
riving	10	45	2142	2	riving_
roarings	9	24	829	2	roarings
roving	10	36	1874	2	roving_
rowings	11	37	1036	2	rowings
rulings	8	33	1038	2	rulings
savines	10	44	1763	2	savines
saving	10	47	2451	2	saving_
savins	9	39	2313	2	savin_s
sayings	11	36	1083	2	sayings
shavings	15	35	633	2	shavings
takings	12	45	1257	2	takings
tracings	11	29	1041	2	tracings
waving	13	40	1820	2	waving_
waxings	18	36	645	2	waxings

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.360	496363.9
2	DLD Change Limit	107671	98	3.483	30913.3
3	Display Results	98	98	0.033	2969.7
	(SQL Overall)	178691	98	3.876	46101.9