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

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

60 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
backings	17	40	1221	(None)
backing	16	55	2344	1	backing_
bakings	14	43	1202	1	ba_kings
bankings	15	48	940	1	bankings
blackings	18	31	676	1	blackings
packings	17	43	1006	1	packings
sackings	15	38	963	1	sackings
actings	10	45	1246	2	_actings
askings	12	51	917	2	_askings
baching	15	60	1775	2	baching_
backlogs	17	4	663	2	backlogs
backswings	22	4	311	2	backswings
baggings	13	30	752	2	baggings
baking	13	56	2662	2	ba_king_
balking	14	37	1735	2	balking_
banking	14	46	2135	2	banking_
barking	14	47	2418	2	barking_
bashings	14	43	1124	2	bashings
basking	14	47	1861	2	basking_
bastings	11	42	1469	2	bastings
battings	11	40	1057	2	battings
becking	16	44	1607	2	becking_
blacking	17	42	1360	2	blacking_
bookings	15	35	873	2	bookings
bracings	13	36	929	2	brac_ings
brokings	15	31	771	2	brokings
bucking	16	36	1757	2	bucking_
calkings	15	28	922	2	calkings
crackings	18	34	684	2	crackings
deckings	16	34	668	2	deckings
facings	13	45	1126	2	fac_ings
gaskings	14	42	747	2	gaskings
hacking	17	37	2061	2	hacking_
hawkings	19	33	613	2	hawkings
jacking	21	45	1526	2	jacking_
lacings	10	50	1365	2	lac_ings
lacking	14	38	2154	2	lacking_
lakings	12	47	1351	2	la_kings
lickings	15	29	814	2	lickings
makings	14	54	1316	2	ma_kings
markings	15	34	1024	2	markings
maskings	15	44	875	2	maskings
neckings	15	34	611	2	neckings
packing	16	44	2072	2	packing_
parkings	15	36	1068	2	parkings
pickings	17	35	938	2	pickings
racings	10	50	1513	2	rac_ings
racking	14	43	2366	2	racking_
rankings	13	38	917	2	rankings
sacking	14	41	2270	2	sacking_
sacrings	11	27	892	2	sacrings
tacking	14	44	2148	2	tacking_
tacklings	16	23	585	2	tacklings
takings	12	45	1257	2	ta_kings
talkings	13	35	840	2	talkings
tickings	15	36	858	2	tickings
trackings	16	24	754	2	trackings
walkings	16	32	731	2	walkings
wickings	18	35	718	2	wickings
yacking	17	43	1568	2	yacking_

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	121059	0.390	458182.1
2	DLD Change Limit	121059	60	3.300	36684.5
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	3.703	48255.7