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

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

91 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
fussing	11	36	1168	(None)
bussing	10	36	1462	1	bussing
cussing	10	38	1427	1	cussing
fessing	11	38	1286	1	fessing
fusing	10	44	1595	1	fu_sing
mussing	10	40	1554	1	mussing
sussing	8	40	1370	1	sussing
bossing	10	37	1460	2	bossing
bushing	13	40	1858	2	bushing
busing	9	64	2059	2	bu_sing
busking	14	41	1657	2	busking
bussings	11	38	666	2	bussings
busting	10	42	2179	2	busting
busying	13	42	1199	2	busying
cessing	10	38	1481	2	cessing
cursing	10	42	1703	2	cursing
dissing	9	45	1768	2	dissing
dossing	9	33	1327	2	dossing
dusking	13	39	1205	2	dusking
dusting	9	36	1899	2	dusting
fashing	14	49	1879	2	fashing
fasting	11	45	2283	2	fasting
feasing	11	39	1665	2	feasing
fishing	14	39	1386	2	fishing
fisting	11	38	1812	2	fisting
flossing	12	24	790	2	flossing
flushing	15	28	883	2	flushing
focussing	15	4	417	2	focussing
fubbing	15	40	957	2	fubbing
fucking	17	32	1228	2	fucking
fudging	13	33	1001	2	fudging
fueling	11	36	1513	2	fueling
fugging	13	39	1291	2	fugging
fugling	12	42	1251	2	fugling
fuguing	12	33	748	2	fuguing
fulling	11	40	1970	2	fulling
fuming	12	40	1329	2	fu_ming
funding	12	41	1366	2	funding
funking	15	40	1302	2	funking
funning	11	38	1361	2	funning
furling	11	40	1656	2	furling
furring	11	40	1314	2	furring
fusain	9	5	864	2	fusain_
fusains	10	3	836	2	fusains
fussier	10	36	1067	2	fussier
fussily	13	26	761	2	fussily
futzing	20	30	790	2	futzing
fuzing	19	41	1064	2	fu_zing
fuzzing	19	33	618	2	fuzzing
gassing	9	42	1633	2	gassing
guessing	10	3	624	2	guessing
guising	9	35	1141	2	guising
gushing	12	40	1422	2	gushing
gussying	13	3	406	2	gussying
gusting	9	39	1716	2	gusting
hissing	11	42	1314	2	hissing
hushing	14	45	1447	2	hushing
husking	15	43	1205	2	husking
jessing	15	37	1062	2	jessing
justing	15	36	1516	2	justing
kissing	12	29	1105	2	kissing
lushing	11	43	1611	2	lushing
lusting	8	36	1932	2	lusting
massing	10	43	1802	2	massing
messing	10	39	1639	2	messing
missing	10	36	1907	2	missing
mossing	10	39	1542	2	mossing
moussing	11	3	814	2	moussing
mushing	13	42	1763	2	mushing
musing	9	39	1950	2	mu_sing
musting	10	32	2107	2	musting
nursing	8	40	1255	2	nursing
ousting	8	40	2135	2	ousting
outsing	8	33	2046	2	outsing
passing	10	43	1842	2	passing
pissing	10	39	1480	2	pissing
pulsing	10	37	1286	2	pulsing
pursing	10	37	1555	2	pursing
pushing	13	36	1545	2	pushing
rushing	11	38	1770	2	rushing
rusting	8	38	2126	2	rusting
sassing	8	46	1555	2	sassing
sudsing	9	29	1032	2	sudsing
tossing	8	36	1256	2	tossing
trussing	9	26	865	2	trussing
tushing	11	42	1401	2	tushing
tusking	12	42	1206	2	tusking
tussling	9	3	582	2	tussling
using	6	63	1796	2	_u_sing
wissing	11	32	1294	2	wissing
yessing	11	32	1006	2	yessing

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.390	458182.1
2	DLD Change Limit	107671	91	3.203	33615.7
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	3.623	49321.3