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

Here are the results of your fuzzy-string dictionary search for “tufting” 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
tufting	11	28	987	(None)
tuftings	12	26	432	1	tuftings
tutting	8	35	1591	1	tutting
buffing	16	34	1139	2	buffing
bunting	10	37	1883	2	bunting
busting	10	42	2179	2	busting
butting	10	35	1928	2	butting
cuffing	16	32	1025	2	cuffing
cutting	10	38	1749	2	cutting
ducting	11	37	1359	2	ducting
dueting	9	38	1439	2	dueting
dunting	9	34	1838	2	dunting
dusting	9	36	1899	2	dusting
gifting	12	38	1089	2	gifting
gusting	9	39	1716	2	gusting
gutting	9	34	1592	2	gutting
hafting	14	40	1417	2	hafting
hefting	14	45	1091	2	hefting
huffing	17	27	883	2	huffing
hunting	11	43	1712	2	hunting
hurting	11	39	1403	2	hurting
hutting	11	30	1603	2	hutting
justing	15	36	1516	2	justing
jutting	15	33	1371	2	jutting
lifting	11	33	1327	2	lifting
lofting	11	33	1131	2	lofting
luffing	14	33	1010	2	luffing
lunting	8	38	1774	2	lunting
lusting	8	36	1932	2	lusting
luting	7	52	2175	2	lu_ting
muffing	16	32	1040	2	muffing
munting	10	37	1877	2	munting
musting	10	32	2107	2	musting
muting	9	39	2152	2	mu_ting
nutting	8	33	1623	2	nutting
ousting	8	40	2135	2	ousting
outing	7	41	2815	2	ou_ting
puffing	16	29	1094	2	puffing
punting	10	33	1844	2	punting
putting	10	32	1857	2	putting
quoting	17	3	1004	2	quoting
rafting	11	38	1575	2	rafting
rifting	11	35	1500	2	rifting
ruffing	14	32	1084	2	ruffing
rusting	8	38	2126	2	rusting
rutting	8	27	1804	2	rutting
sifting	11	30	1459	2	sifting
stuffing	15	24	784	2	stuffing
stunting	9	28	1150	2	stunting
suiting	8	34	1900	2	suiting
tarting	8	42	2265	2	tarting
tasting	8	46	2421	2	tasting
tatting	8	40	1952	2	tatting
taunting	9	35	1093	2	taunting
tauting	8	33	1638	2	tauting
tenting	8	46	2115	2	tenting
testing	8	60	2105	2	testing
tiffing	14	33	938	2	tiffing
tilting	8	34	1710	2	tilting
tinting	8	46	2060	2	tinting
toiting	8	32	1709	2	toiting
tooting	8	30	1942	2	tooting
toting	7	41	2379	2	t_oting
totting	8	28	1684	2	totting
touting	8	41	1845	2	touting
trusting	9	34	1165	2	trusting
tubbing	12	35	1009	2	tubbing
tubing	9	38	1309	2	tu_bing
tucking	14	34	1518	2	tucking
tuftier	10	9	660	2	tuftier
tuftily	13	3	557	2	tuftily
tugging	10	26	1123	2	tugging
tumping	12	31	1424	2	tumping
tuning	7	40	1684	2	tu_ning
tunning	8	35	1445	2	tunning
tupping	12	34	1166	2	tupping
turfing	11	30	1005	2	turfing
turning	8	37	1318	2	turning
turtling	9	23	883	2	turtling
tushing	11	42	1401	2	tushing
tusking	12	42	1206	2	tusking
wafting	14	39	1166	2	wafting

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.516	346300.4
2	DLD Change Limit	107671	82	3.343	32207.9
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	3.889	45947.8