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

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

82 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
facings	13	45	1126	(None)
facing	12	53	2157	1	facing_
fadings	12	46	930	1	fadings
lacings	10	50	1365	1	lacings
racings	10	50	1512	1	racings
acing	8	74	2915	2	_acing_
acinus	8	3	1125	2	_acinus
actings	10	45	1246	2	_actings
agings	8	63	1267	2	_agings
backings	17	40	1221	2	backings
bakings	14	43	1201	2	bakings
bracings	13	36	928	2	bracings
casings	10	40	1351	2	casings
cavings	13	47	1254	2	cavings
darings	9	37	1364	2	darings
earings	8	45	1770	2	earings
eatings	8	46	1643	2	eatings
facials	12	33	1074	2	facials
facias	11	34	1580	2	faci_as
faciends	14	4	357	2	faciends
facies	11	39	2159	2	faci_es
fading	11	48	2111	2	fading_
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
farcing	13	35	1400	2	farcing_
farinas	10	32	1523	2	farinas
faring	10	52	3128	2	faring_
farmings	14	29	821	2	farmings
fascines	13	3	1014	2	fascines
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_
fencings	14	22	566	2	fencings
ficins	11	35	1398	2	ficin_s
filings	11	52	1307	2	filings
finings	11	43	1177	2	finings
firings	11	41	1232	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	812	2	framings
frayings	15	32	598	2	frayings
gamings	11	46	1091	2	gamings
gatings	9	52	1282	2	gatings
hayings	14	37	939	2	hayings
hazings	20	37	834	2	hazings
icings	9	42	845	2	_icings
lacing	9	46	2623	2	lacing_
ladings	9	38	1413	2	ladings
lakings	12	47	1350	2	lakings
lawings	11	36	1147	2	lawings
macing	11	42	2155	2	macing_
makings	14	54	1315	2	makings
matings	10	45	1620	2	matings
mayings	13	44	1050	2	mayings
pacing	11	45	2275	2	pacing_
packings	17	43	1006	2	packings
pagings	11	44	1106	2	pagings
palings	10	39	1582	2	palings
parings	10	42	1921	2	parings
pavings	13	40	1163	2	pavings
racing	9	50	3053	2	racing_
ratings	8	42	1740	2	ratings
ravings	11	46	1449	2	ravings
sackings	15	38	963	2	sackings
sacrings	11	27	892	2	sacrings
savings	11	44	1295	2	savings
sayings	11	36	1083	2	sayings
spacings	13	28	704	2	spacings
takings	12	45	1256	2	takings
tracings	11	29	1040	2	tracings
waxings	18	36	645	2	waxings

Search took 5 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.123	1452772.4
2	DLD Change Limit	107671	82	4.046	26611.7
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	4.202	42525.2