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

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

71 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
trocking	15	36	1242	(None)
crocking	17	43	1344	1	crocking
frocking	18	30	957	1	frocking
rocking	14	36	1963	1	_rocking
tracking	15	37	1546	1	tracking
tricking	15	27	1451	1	tricking
troaking	13	33	1096	1	troaking
troking	12	35	1410	1	tro_king
trucking	15	33	1016	1	trucking
arcking	14	58	1196	2	ar_cking
blocking	17	45	1057	2	blocking
bricking	17	39	1140	2	bricking
broking	14	35	1482	2	bro_king
brooking	15	37	1070	2	brooking
chocking	20	40	1101	2	chocking
clocking	17	43	1241	2	clocking
cocking	16	36	1998	2	_cocking
cracking	17	40	1390	2	cracking
cricking	17	34	1265	2	cricking
croaking	15	37	1215	2	croaking
crooking	15	36	1134	2	crooking
docking	15	36	1501	2	_docking
drouking	14	3	644	2	drouking
flocking	18	34	1087	2	flocking
grokking	13	3	481	2	grokking
hocking	17	34	1724	2	_hocking
knocking	14	24	594	2	knocking
locking	14	37	1815	2	_locking
mocking	16	36	1445	2	_mocking
nocking	14	36	1511	2	_nocking
outrocking	17	4	705	2	outrocking
pocking	16	39	1676	2	_pocking
pricking	17	32	1260	2	pricking
racking	14	43	2366	2	_racking
recking	14	43	1992	2	_recking
ricking	14	39	2023	2	_ricking
rockling	15	25	938	2	_rockling
rooking	12	35	1736	2	_rooking
rucking	14	32	1667	2	_rucking
shocking	18	43	1153	2	shocking
smocking	17	34	910	2	smocking
socking	14	35	1860	2	_socking
stocking	15	29	1250	2	stocking
stroking	13	26	1094	2	stro_king
tacking	14	44	2148	2	t_acking
talcking	15	6	708	2	talcking
thacking	18	31	1004	2	thacking
ticking	14	32	1875	2	t_icking
toking	11	44	2072	2	t_o_king
torching	14	25	1008	2	torching
tracing	10	37	2015	2	trac_ing
trackings	16	24	753	2	trackings
traiking	13	25	1197	2	traiking
trekking	12	3	554	2	trekking
tricing	10	34	1735	2	tric_ing
trickling	16	4	772	2	trickling
trolling	9	32	1249	2	trolling
tromping	13	31	959	2	tromping
trooping	11	27	1027	2	trooping
trothing	12	24	1084	2	trothing
trotting	9	25	1091	2	trotting
trouping	11	24	950	2	trouping
trowing	11	34	1370	2	tro_wing
trucing	10	32	1184	2	truc_ing
truckings	16	23	501	2	truckings
truckling	16	4	507	2	truckling
tucking	14	34	1518	2	t_ucking
wracking	18	34	996	2	wracking
wrecking	18	32	815	2	wrecking
wricking	18	34	949	2	wricking
yocking	17	37	1237	2	_yocking

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	121059	0.140	1276364.3
2	DLD Change Limit	121059	71	3.736	32403.4
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	3.906	45747.8