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

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

185 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
racking	14	43	2366	(None)
arcking	14	58	1196	1	arcking
backing	16	55	2344	1	backing
cracking	17	40	1390	1	cracking
hacking	17	37	2061	1	hacking
jacking	21	45	1526	1	jacking
lacking	14	38	2154	1	lacking
packing	16	44	2072	1	packing
racing	9	50	3053	1	rac_ing
raking	11	47	2842	1	ra_king
ranking	12	43	2088	1	ranking
recking	14	43	1992	1	recking
ricking	14	39	2023	1	ricking
rocking	14	36	1963	1	rocking
rucking	14	32	1667	1	rucking
sacking	14	41	2270	1	sacking
tacking	14	44	2148	1	tacking
tracking	15	37	1546	1	tracking
wracking	18	34	996	1	wracking
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
arching	13	62	1669	2	arching
arcing	9	58	1964	2	arc_ing
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
bracing	12	38	1761	2	brac_ing
braking	14	39	1771	2	bra_king
bricking	17	39	1140	2	bricking
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
crackings	18	34	684	2	crackings
crackling	18	15	700	2	crackling
cranking	15	46	1307	2	cranking
cricking	17	34	1265	2	cricking
crocking	17	43	1344	2	crocking
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
franking	16	43	1086	2	franking
frocking	18	30	957	2	frocking
fucking	17	32	1228	2	fucking
gasking	13	44	1591	2	gasking
gawking	16	39	882	2	gawking
gecking	15	41	1136	2	gecking
gracing	11	32	1644	2	grac_ing
hackling	18	33	1016	2	hackling
hanking	15	46	1910	2	hanking
harking	15	41	2094	2	harking
hawking	18	37	1142	2	hawking
hocking	17	34	1724	2	hocking
jauking	19	41	832	2	jauking
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
pranking	15	38	1338	2	pranking
pricking	17	32	1260	2	pricking
quacking	24	3	674	2	quacking
racings	10	50	1513	2	rac_ings
racketing	16	4	787	2	racketing
rackingly	19	4	511	2	rackingly
radding	10	37	1500	2	radding
rafting	11	38	1575	2	rafting
ragging	10	35	1668	2	ragging
raging	8	51	2643	2	ra_ging
raiding	9	36	1759	2	raiding
railing	8	33	2564	2	railing
raining	8	39	2269	2	raining
raising	8	32	2053	2	raising
ramming	12	31	1506	2	ramming
ramping	12	33	1687	2	ramping
ranching	14	17	1204	2	ranching
ranging	9	41	2026	2	ranging
rankings	13	38	917	2	rankings
rankling	13	26	1011	2	rankling
ranting	8	40	2541	2	ranting
raping	9	48	2985	2	ra_ping
rapping	12	36	1910	2	rapping
raring	7	43	3287	2	ra_ring
rasing	7	43	3083	2	ra_sing
rasping	10	43	1625	2	rasping
rating	7	49	3870	2	ra_ting
ratting	8	38	2236	2	ratting
raving	10	51	2885	2	ra_ving
raxing	14	43	2102	2	ra_xing
raying	10	50	2719	2	ra_ying
razing	16	45	2454	2	ra_zing
razzing	16	3	632	2	razzing
reaching	14	33	1720	2	reaching
reacting	11	33	1789	2	reacting
reeking	12	33	1864	2	reeking
repacking	18	3	828	2	repacking
reracking	16	3	931	2	reracking
retacking	16	5	897	2	retacking
ricing	9	48	2276	2	ric_ing
risking	12	39	1424	2	risking
roaching	14	32	1043	2	roaching
rockling	15	25	938	2	rockling
rooking	12	35	1736	2	rooking
ruching	13	36	1293	2	ruching
ruckling	15	25	857	2	ruckling
ryking	14	34	811	2	r_yking
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
tracing	10	37	2015	2	trac_ing
trackings	16	24	754	2	trackings
traiking	13	25	1197	2	traiking
tricking	15	27	1451	2	tricking
trocking	15	36	1242	2	trocking
trucking	15	33	1016	2	trucking
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
wrecking	18	32	815	2	wrecking
wricking	18	34	949	2	wricking
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	185	3.000	35890.3
3	Display Results	185	185	0.063	2936.5
	(SQL Overall)	178691	185	3.423	52203.0