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

Here are the results of your fuzzy-string dictionary search for “mucking” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
mucking	16	32	1382	(None)
bucking	16	36	1757	1	bucking
ducking	15	43	1505	1	ducking
fucking	17	32	1228	1	fucking
lucking	14	36	1583	1	lucking
mocking	16	36	1445	1	mocking
rucking	14	32	1667	1	rucking
sucking	14	32	1741	1	sucking
tucking	14	34	1518	1	tucking
yucking	17	32	1169	1	yucking
arcking	14	58	1196	2	arcking
backing	16	55	2344	2	backing
becking	16	44	1607	2	becking
buckling	17	25	911	2	buckling
bulking	14	38	1512	2	bulking
bunking	14	40	1619	2	bunking
burking	14	37	1632	2	burking
busking	14	41	1657	2	busking
chucking	20	37	950	2	chucking
clucking	17	42	999	2	clucking
cocking	16	36	1998	2	cocking
decking	15	39	1559	2	decking
dicking	15	36	1761	2	dicking
docking	15	36	1501	2	docking
duckling	16	24	770	2	duckling
ducting	11	37	1359	2	ducting
duking	12	47	1513	2	du_king
dunking	13	38	1326	2	dunking
dusking	13	39	1205	2	dusking
funking	15	40	1302	2	funking
gecking	15	41	1136	2	gecking
hacking	17	37	2061	2	hacking
hocking	17	34	1724	2	hocking
hulking	15	39	1098	2	hulking
husking	15	43	1205	2	husking
jacking	21	45	1526	2	jacking
juking	18	38	1047	2	ju_king
junking	19	39	1007	2	junking
kecking	13	41	1188	2	kecking
kicking	13	33	1402	2	kicking
lacking	14	38	2154	2	lacking
licking	14	41	1828	2	licking
locking	14	37	1815	2	locking
lurking	12	37	1085	2	lurking
macing	11	42	2155	2	mac_ing
mackling	17	27	1006	2	mackling
making	13	48	2385	2	m_aking
marking	14	40	2013	2	marking
masking	14	51	1661	2	masking
miching	15	29	1180	2	miching
miking	13	42	1846	2	m_iking
milking	14	37	1276	2	milking
mouching	16	31	1058	2	mouching
mucin	9	31	1682	2	muc_in_
mucins	10	27	1251	2	muc_ins
muckier	15	34	1148	2	muckier
muckily	18	27	774	2	muckily
mudding	12	33	1081	2	mudding
muffing	16	32	1040	2	muffing
mugging	12	27	1179	2	mugging
mulching	16	28	710	2	mulching
mulcting	13	24	698	2	mulcting
muling	9	35	1988	2	mu_ling
mulling	10	38	1999	2	mulling
mumming	11	40	1002	2	mumming
mumping	14	34	1163	2	mumping
munching	16	29	997	2	munching
munting	10	37	1877	2	munting
muring	9	51	2037	2	mu_ring
muscling	13	3	785	2	muscling
mushing	13	42	1763	2	mushing
musicking	18	4	451	2	musicking
musing	9	39	1950	2	mu_sing
mussing	10	40	1554	2	mussing
musting	10	32	2107	2	musting
muting	9	39	2152	2	mu_ting
necking	14	39	1389	2	necking
nicking	14	35	1632	2	nicking
nocking	14	36	1511	2	nocking
nuking	11	34	1125	2	nu_king
ouching	13	43	1490	2	ouching
packing	16	44	2072	2	packing
pecking	16	40	1778	2	pecking
picking	16	34	1833	2	picking
plucking	17	35	772	2	plucking
pocking	16	39	1676	2	pocking
puking	13	39	1306	2	pu_king
quacking	24	3	674	2	quacking
quaking	21	3	931	2	quaking
racking	14	43	2366	2	racking
recking	14	43	1992	2	recking
ricking	14	39	2023	2	ricking
rocking	14	36	1963	2	rocking
ruching	13	36	1293	2	ruching
ruckling	15	25	857	2	ruckling
sacking	14	41	2270	2	sacking
shucking	18	33	943	2	shucking
sicking	14	37	2017	2	sicking
smacking	17	35	1076	2	smacking
smocking	17	34	910	2	smocking
socking	14	35	1860	2	socking
suckling	15	24	1002	2	suckling
sulking	12	45	1431	2	sulking
tacking	14	44	2148	2	tacking
ticking	14	32	1875	2	ticking
trucking	15	33	1016	2	trucking
tusking	12	42	1206	2	tusking
wicking	17	34	1477	2	wicking
yacking	17	43	1568	2	yacking
yocking	17	37	1237	2	yocking
yukking	14	37	473	2	yukking

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.376	475242.0
2	DLD Change Limit	107671	111	3.470	31029.1
3	Display Results	111	111	0.030	3700.0
	(SQL Overall)	178691	111	3.876	46101.9