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

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

80 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
ridings	9	34	1209	(None)
hidings	12	34	970	1	hidings
riding	8	43	2596	1	riding_
risings	8	32	1189	1	risings
sidings	9	40	1146	1	sidings
tidings	9	38	1026	1	tidings
aiding	8	44	2361	2	aiding_
airings	8	39	1384	2	airings
audings	9	28	939	2	audings
biddings	13	39	756	2	biddings
biding	10	47	2079	2	biding_
bindings	12	38	1047	2	bindings
birdings	12	37	882	2	birdings
bodings	11	37	1165	2	bodings
braidings	13	28	590	2	braidings
bridgings	14	25	429	2	bridgings
dings	7	63	3140	2	__dings
drivings	13	26	576	2	drivings
endings	9	29	1044	2	endings
fadings	12	46	930	2	fadings
filings	11	52	1307	2	filings
findings	13	32	844	2	findings
finings	11	43	1177	2	finings
firings	11	41	1233	2	firings
fixings	18	34	744	2	fixings
gildings	11	35	697	2	gildings
griding	10	30	1497	2	griding_
hiding	11	43	1933	2	hiding_
hildings	13	34	750	2	hildings
icings	9	42	845	2	_icings
ladings	9	38	1413	2	ladings
likings	12	53	941	2	likings
linings	8	43	1307	2	linings
livings	11	40	892	2	livings
minings	10	39	1207	2	minings
niding	8	32	1798	2	niding_
pilings	10	33	1361	2	pilings
pipings	12	33	825	2	pipings
priding	11	33	1754	2	priding_
primings	13	33	814	2	primings
racings	10	50	1513	2	racings
raiding	9	36	1759	2	raiding_
railings	9	34	1215	2	railings
raisings	9	33	844	2	raisings
ratings	8	42	1741	2	ratings
ravings	11	46	1450	2	ravings
readings	10	35	1264	2	readings
reding	8	38	2556	2	reding_
redwings	13	30	573	2	redwings
reedings	10	35	1036	2	reedings
ribbings	13	27	592	2	ribbings
ricing	9	48	2276	2	ricing_
ricins	8	36	1870	2	ricin_s
ricinus	9	40	812	2	ricinus
ridding	10	33	1419	2	ridding_
ridging	10	41	1298	2	ridging_
ridglings	12	21	418	2	ridglings
riflings	12	22	730	2	riflings
riggings	11	32	713	2	riggings
riling	7	42	2797	2	riling_
riming	9	33	2222	2	riming_
rings	6	50	2917	2	r__ings
rinsings	9	31	801	2	rinsings
riping	9	38	2161	2	riping_
rising	7	40	2588	2	rising_
riving	10	45	2142	2	riving_
rovings	11	43	949	2	rovings
rowings	11	37	1036	2	rowings
rulings	8	33	1038	2	rulings
siding	8	38	2213	2	siding_
sizings	17	37	801	2	sizings
tiding	8	35	2009	2	tiding_
tilings	8	42	1279	2	tilings
timings	10	27	930	2	timings
uridines	9	8	951	2	uridines
vikings	15	38	662	2	vikings
wildings	13	28	793	2	wildings
windings	13	32	997	2	windings
wirings	11	39	1011	2	wirings
writings	12	29	811	2	writings

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.376	475242.0
2	DLD Change Limit	107671	80	2.906	37051.3
3	Display Results	80	80	0.013	6153.8
	(SQL Overall)	178691	80	3.295	54231.0