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

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

87 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
gushing	12	40	1422	(None)
bushing	13	40	1858	1	bushing
gashing	12	51	1923	1	gashing
gusting	9	39	1716	1	gusting
hushing	14	45	1447	1	hushing
lushing	11	43	1611	1	lushing
mushing	13	42	1763	1	mushing
pushing	13	36	1545	1	pushing
rushing	11	38	1770	1	rushing
tushing	11	42	1401	1	tushing
ashing	10	78	2409	2	_ashing
bashing	13	54	2258	2	bashing
blushing	14	33	933	2	blushing
brushing	14	35	996	2	brushing
bushings	14	34	879	2	bushings
busing	9	64	2059	2	bus_ing
busking	14	41	1657	2	busking
bussing	10	36	1462	2	bussing
busting	10	42	2179	2	busting
busying	13	42	1199	2	busying
cashing	13	50	2255	2	cashing
coshing	13	43	1643	2	coshing
crushing	14	30	1005	2	crushing
cussing	10	38	1427	2	cussing
dashing	12	59	1789	2	dashing
dishing	12	40	1710	2	dishing
dusking	13	39	1205	2	dusking
dusting	9	36	1899	2	dusting
fashing	14	49	1879	2	fashing
fishing	14	39	1386	2	fishing
flushing	15	28	883	2	flushing
fusing	10	44	1595	2	fus_ing
fussing	11	36	1168	2	fussing
gasking	13	44	1591	2	gasking
gasping	11	37	1436	2	gasping
gassing	9	42	1633	2	gassing
gasting	9	50	2276	2	gasting
gnashing	13	3	642	2	gnashing
gosling	9	33	1240	2	gosling
guessing	10	3	624	2	guessing
guesting	10	5	846	2	guesting
guiding	10	29	1184	2	guiding
guiling	9	32	1421	2	guiling
guising	9	35	1141	2	guising
gulfing	12	33	947	2	gulfing
gulling	9	40	1956	2	gulling
gulping	11	30	975	2	gulping
gumming	13	38	1019	2	gumming
gunning	9	34	1317	2	gunning
gurging	10	29	1011	2	gurging
gushier	11	31	1007	2	gushier
gushily	14	25	782	2	gushily
gushingly	17	4	425	2	gushingly
gussying	13	3	406	2	gussying
gutting	9	34	1592	2	gutting
guying	11	37	972	2	gu_ying
hashing	14	50	2016	2	hashing
husking	15	43	1205	2	husking
joshing	18	51	941	2	joshing
justing	15	36	1516	2	justing
lashing	11	44	2289	2	lashing
lusting	8	36	1932	2	lusting
mashing	13	44	2224	2	mashing
meshing	13	45	1381	2	meshing
moshing	13	42	1488	2	moshing
musing	9	39	1950	2	mus_ing
mussing	10	40	1554	2	mussing
musting	10	32	2107	2	musting
noshing	11	46	1277	2	noshing
ouching	13	43	1490	2	ouching
ousting	8	40	2135	2	ousting
pashing	13	51	2051	2	pashing
pishing	13	43	1437	2	pishing
quashing	21	3	709	2	quashing
ruching	13	36	1293	2	ruching
rushings	12	38	784	2	rushings
rusting	8	38	2126	2	rusting
sashing	11	46	2147	2	sashing
shushing	15	31	774	2	shushing
slushing	12	29	964	2	slushing
smushing	14	28	745	2	smushing
sughing	12	35	971	2	sughing
sussing	8	40	1370	2	sussing
tusking	12	42	1206	2	tusking
using	6	63	1796	2	_us_ing
washing	14	51	1928	2	washing
wishing	14	41	1489	2	wishing

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.360	496363.9
2	DLD Change Limit	107671	87	2.843	37872.3
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.233	55271.0