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

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

87 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
fadings	12	46	930	(None)
facings	13	45	1126	1	facings
fading	11	48	2111	1	fading_
ladings	9	38	1413	1	ladings
agings	8	63	1267	2	_agings
audings	9	28	939	2	audings
bakings	14	43	1202	2	bakings
beadings	12	37	1178	2	beadings
bladings	12	33	775	2	bladings
bodings	11	37	1165	2	bodings
cardings	12	38	1263	2	cardings
casings	10	40	1351	2	casings
cavings	13	47	1254	2	cavings
darings	9	37	1365	2	darings
dings	7	63	3140	2	__dings
earings	8	45	1771	2	earings
eatings	8	46	1644	2	eatings
endings	9	29	1044	2	endings
facing	12	53	2157	2	facing_
fadeins	11	6	850	2	fadein_s
fadging	13	42	1024	2	fadging_
fagins	10	5	1386	2	fagin_s
failings	12	38	1101	2	failings
faints	9	48	1878	2	fa_ints
fairings	12	38	819	2	fairings
faking	14	55	2098	2	faking_
famines	12	32	1626	2	famines
faming	12	49	2297	2	faming_
fangs	9	62	2407	2	fa__ngs
farding	12	37	1674	2	farding_
farinas	10	32	1523	2	farinas
faring	10	52	3128	2	faring_
farmings	14	29	822	2	farmings
fastings	12	40	1194	2	fastings
fating	10	53	2867	2	fating_
fatlings	12	35	930	2	fatlings
faxing	17	51	1705	2	faxing_
faying	13	45	2107	2	faying_
fazing	19	44	1864	2	fazing_
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
flings	10	67	1528	2	f_lings
flyings	14	49	606	2	flyings
foxings	18	44	696	2	foxings
framings	14	33	813	2	framings
frayings	15	32	599	2	frayings
gamings	11	46	1091	2	gamings
gatings	9	52	1282	2	gatings
hading	11	39	2294	2	hading_
hayings	14	37	939	2	hayings
hazings	20	37	834	2	hazings
headings	13	35	1049	2	headings
hidings	12	34	970	2	hidings
jading	15	42	1402	2	jading_
lacings	10	50	1365	2	lacings
lading	8	42	2712	2	lading_
ladinos	8	38	996	2	ladinos
lakings	12	47	1351	2	lakings
landings	10	31	1007	2	landings
lawings	11	36	1147	2	lawings
leadings	10	35	1124	2	leadings
loadings	10	37	838	2	loadings
makings	14	54	1316	2	makings
matings	10	45	1621	2	matings
mayings	13	44	1051	2	mayings
paddings	13	29	701	2	paddings
pagings	11	44	1106	2	pagings
palings	10	39	1582	2	palings
parings	10	42	1921	2	parings
pavings	13	40	1163	2	pavings
racings	10	50	1513	2	racings
ratings	8	42	1741	2	ratings
ravings	11	46	1450	2	ravings
readings	10	35	1264	2	readings
ridings	9	34	1209	2	ridings
savings	11	44	1295	2	savings
sayings	11	36	1083	2	sayings
shadings	13	32	743	2	shadings
sidings	9	40	1146	2	sidings
takings	12	45	1257	2	takings
tidings	9	38	1026	2	tidings
waddings	14	35	647	2	waddings
wading	11	46	1953	2	wading_
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.376	475242.0
2	DLD Change Limit	107671	87	2.923	36835.8
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.329	53677.1