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

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

92 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
takings	12	45	1257	(None)
bakings	14	43	1202	1	bakings
lakings	12	47	1351	1	lakings
makings	14	54	1316	1	makings
taking	11	47	2595	1	taking_
takins	10	51	1740	1	takin_s
talkings	13	35	840	1	talkings
agings	8	63	1267	2	_agings
askings	12	51	917	2	askings
backings	17	40	1221	2	backings
baking	13	56	2662	2	baking_
bankings	15	48	940	2	bankings
caking	13	46	2467	2	caking_
calkings	15	28	922	2	calkings
casings	10	40	1351	2	casings
cavings	13	47	1254	2	cavings
darings	9	37	1365	2	darings
earings	8	45	1771	2	earings
eatings	8	46	1644	2	eatings
facings	13	45	1126	2	facings
fadings	12	46	930	2	fadings
faking	14	55	2098	2	faking_
gamings	11	46	1091	2	gamings
gaskings	14	42	747	2	gaskings
gatings	9	52	1282	2	gatings
hawkings	19	33	613	2	hawkings
hayings	14	37	939	2	hayings
hazings	20	37	834	2	hazings
kings	10	58	2556	2	__kings
lacings	10	50	1365	2	lacings
ladings	9	38	1413	2	ladings
laking	11	50	2704	2	laking_
lawings	11	36	1147	2	lawings
likings	12	53	941	2	likings
making	13	48	2385	2	making_
markings	15	34	1024	2	markings
maskings	15	44	875	2	maskings
matings	10	45	1621	2	matings
mayings	13	44	1051	2	mayings
packings	17	43	1006	2	packings
pagings	11	44	1106	2	pagings
palings	10	39	1582	2	palings
parings	10	42	1921	2	parings
parkings	15	36	1068	2	parkings
pavings	13	40	1163	2	pavings
racings	10	50	1513	2	racings
raking	11	47	2842	2	raking_
rankings	13	38	917	2	rankings
ratings	8	42	1741	2	ratings
ravings	11	46	1450	2	ravings
sackings	15	38	963	2	sackings
savings	11	44	1295	2	savings
sayings	11	36	1083	2	sayings
stagings	10	37	834	2	stagings
staking	12	39	1980	2	staking_
stalkings	14	31	498	2	stalkings
tacking	14	44	2148	2	tacking_
tacklings	16	23	585	2	tacklings
tahinis	10	4	801	2	tahinis
tailings	9	32	1167	2	tailings
tains	5	49	3632	2	ta_in_s
taints	6	45	2053	2	ta_ints
takin	9	49	2130	2	takin__
takingly	16	3	591	2	takingly
talking	12	38	1582	2	talking_
taming	9	40	2343	2	taming_
tangs	6	50	2834	2	ta__ngs
tanking	12	39	1879	2	tanking_
tankinis	12	24	591	2	tankinis
tannings	9	26	863	2	tannings
taping	9	42	2239	2	taping_
tappings	13	26	771	2	tappings
taring	7	39	3228	2	taring_
tasking	12	46	1632	2	tasking_
tattings	9	40	882	2	tattings
tawing	10	45	2155	2	tawing_
taxing	14	38	1671	2	taxing_
things	10	49	1430	2	t_hings
tickings	15	36	858	2	tickings
tidings	9	38	1026	2	tidings
tilings	8	42	1279	2	tilings
timings	10	27	930	2	timings
tings	6	53	2920	2	t__ings
toking	11	44	2072	2	toking_
tracings	11	29	1041	2	tracings
trackings	16	24	754	2	trackings
tsking	11	42	1042	2	tsking_
tubings	10	33	648	2	tubings
vikings	15	38	662	2	vikings
waking	14	48	2138	2	waking_
walkings	16	32	731	2	walkings
waxings	18	36	645	2	waxings

Search took 7 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.686	260482.5
2	DLD Change Limit	107671	92	6.000	17945.2
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	6.716	26606.8