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

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

139 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
jacking	21	45	1526	(None)
backing	16	55	2344	1	backing
hacking	17	37	2061	1	hacking
jauking	19	41	832	1	jauking
lacking	14	38	2154	1	lacking
packing	16	44	2072	1	packing
racking	14	43	2366	1	racking
sacking	14	41	2270	1	sacking
tacking	14	44	2148	1	tacking
yacking	17	43	1568	1	yacking
aching	12	65	2197	2	_aching
acing	8	74	2915	2	_ac_ing
acting	9	59	2098	2	_acting
arcking	14	58	1196	2	arcking
asking	11	60	1723	2	_asking
baching	15	60	1775	2	baching
backings	17	40	1221	2	backings
baking	13	56	2662	2	ba_king
balking	14	37	1735	2	balking
banking	14	46	2135	2	banking
barking	14	47	2418	2	barking
basking	14	47	1861	2	basking
becking	16	44	1607	2	becking
blacking	17	42	1360	2	blacking
bucking	16	36	1757	2	bucking
caching	15	63	1750	2	caching
cackling	17	26	1094	2	cackling
caking	13	46	2467	2	ca_king
calking	14	46	1778	2	calking
carking	14	43	2285	2	carking
casking	14	43	1735	2	casking
clacking	17	33	1349	2	clacking
cocking	16	36	1998	2	cocking
cracking	17	40	1390	2	cracking
darking	13	42	1734	2	darking
decking	15	39	1559	2	decking
dicking	15	36	1761	2	dicking
docking	15	36	1501	2	docking
ducking	15	43	1505	2	ducking
facing	12	53	2157	2	fac_ing
faking	14	55	2098	2	fa_king
flacking	18	43	1179	2	flacking
fucking	17	32	1228	2	fucking
gasking	13	44	1591	2	gasking
gawking	16	39	882	2	gawking
gecking	15	41	1136	2	gecking
hackling	18	33	1016	2	hackling
hanking	15	46	1910	2	hanking
harking	15	41	2094	2	harking
hawking	18	37	1142	2	hawking
hijacking	26	4	276	2	hijacking
hocking	17	34	1724	2	hocking
jabbing	19	31	941	2	jabbing
jacketing	23	4	564	2	jacketing
jackies	20	29	1262	2	jackies
jackleg	21	3	504	2	jackleg
jading	15	42	1402	2	ja_ding
jagging	17	33	1199	2	jagging
jailing	15	34	1584	2	jailing
jambing	19	32	853	2	jambing
jamming	19	32	979	2	jamming
japing	16	50	1357	2	ja_ping
jarring	15	36	1319	2	jarring
jauping	17	30	719	2	jauping
jawing	17	44	1496	2	ja_wing
jazzing	23	3	388	2	jazzing
jerking	19	30	892	2	jerking
jinking	19	36	1354	2	jinking
joking	18	41	1302	2	j_oking
jouking	19	30	761	2	jouking
juking	18	38	1047	2	j_uking
junking	19	39	1007	2	junking
kecking	13	41	1188	2	kecking
kicking	13	33	1402	2	kicking
knacking	14	29	671	2	knacking
lacing	9	46	2623	2	lac_ing
laking	11	50	2704	2	la_king
larking	12	37	1825	2	larking
licking	14	41	1828	2	licking
locking	14	37	1815	2	locking
lucking	14	36	1583	2	lucking
macing	11	42	2155	2	mac_ing
mackling	17	27	1006	2	mackling
making	13	48	2385	2	ma_king
marking	14	40	2013	2	marking
masking	14	51	1661	2	masking
mocking	16	36	1445	2	mocking
mucking	16	32	1382	2	mucking
narking	12	40	1538	2	narking
necking	14	39	1389	2	necking
nicking	14	35	1632	2	nicking
nocking	14	36	1511	2	nocking
pacing	11	45	2275	2	pac_ing
packings	17	43	1006	2	packings
paiking	14	38	1481	2	paiking
parking	14	34	2304	2	parking
pecking	16	40	1778	2	pecking
picking	16	34	1833	2	picking
pocking	16	39	1676	2	pocking
quacking	24	3	674	2	quacking
racing	9	50	3053	2	rac_ing
raking	11	47	2842	2	ra_king
ranking	12	43	2088	2	ranking
recking	14	43	1992	2	recking
ricking	14	39	2023	2	ricking
rocking	14	36	1963	2	rocking
rucking	14	32	1667	2	rucking
sackings	15	38	963	2	sackings
sacring	10	31	1598	2	sacring
shacking	18	40	1408	2	shacking
sicking	14	37	2017	2	sicking
slacking	15	39	1413	2	slacking
smacking	17	35	1076	2	smacking
snacking	15	34	1170	2	snacking
socking	14	35	1860	2	socking
stacking	15	42	1508	2	stacking
sucking	14	32	1741	2	sucking
tackling	15	32	1112	2	tackling
taking	11	47	2595	2	ta_king
talcking	15	6	708	2	talcking
talking	12	38	1582	2	talking
tanking	12	39	1879	2	tanking
tasking	12	46	1632	2	tasking
thacking	18	31	1004	2	thacking
ticking	14	32	1875	2	ticking
tracking	15	37	1546	2	tracking
tucking	14	34	1518	2	tucking
waking	14	48	2138	2	wa_king
walking	15	40	1330	2	walking
wanking	15	42	1678	2	wanking
warking	15	35	1957	2	warking
wauking	15	34	1001	2	wauking
whacking	21	37	748	2	whacking
wicking	17	34	1477	2	wicking
wracking	18	34	996	2	wracking
yakking	14	37	642	2	yakking
yanking	15	45	1246	2	yanking
yocking	17	37	1237	2	yocking
yucking	17	32	1169	2	yucking

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	139	3.250	33129.5
3	Display Results	139	139	0.046	3021.7
	(SQL Overall)	178691	139	3.656	48876.1