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

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

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

101 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
sickout	13	5	937	(None)
sickouts	14	5	550	1	sickouts
stickout	14	7	633	1	stickout
backout	15	6	1295	2	backout
lockout	13	5	933	2	lockout
sackbut	15	4	594	2	sackbut
scout	7	50	3145	2	s_c_out
sickest	13	18	1379	2	sickest
sicko	11	53	1539	2	sicko__
sickos	12	51	1203	2	sicko_s
stickouts	15	5	397	2	stickouts
backouts	16	9	864	3	backouts
blackout	16	4	741	3	blackout
checkout	19	4	559	3	checkout
clout	7	53	3046	3	__clout
cookout	13	4	1015	3	cookout
dicot	8	54	2909	3	dic_o_t
dimout	9	4	1424	3	di_mout
hackbut	18	4	571	3	hackbut
hickory	19	4	390	3	hickory
hideout	11	7	979	3	hideout
kickoff	18	4	301	3	kickoff
kickup	13	5	413	3	kick_up
knockout	13	4	389	3	knockout
locknut	13	4	525	3	locknut
lockouts	14	4	549	3	lockouts
lookout	11	4	803	3	lookout
missout	9	4	1266	3	missout
piceous	11	3	1069	3	piceous
picket	14	49	2431	3	pick_et
pickoff	21	4	369	3	pickoff
pickup	16	5	563	3	pick_up
picot	9	50	3101	3	pic_o_t
pigout	9	3	1461	3	pi_gout
pitchout	15	4	694	3	pitchout
sacbut	10	8	1194	3	sac_but
sackbuts	16	4	405	3	sackbuts
sackful	16	4	535	3	sackful
scoot	7	57	2915	3	s_c_oot
scot	6	62	4261	3	s_c_o_t
scour	7	53	1553	3	s_c_our
scouth	11	50	1115	3	s_c_outh
scouts	8	48	1794	3	s_c_outs
scut	6	58	3554	3	s_c__ut
sellout	7	3	1358	3	sellout
setout	6	47	1946	3	s_etout
shakeout	15	4	661	3	shakeout
shout	8	54	3317	3	s__hout
shutout	10	4	853	3	shutout
sick	10	64	3557	3	sick___
sickbay	18	4	372	3	sickbay
sickbed	16	39	682	3	sickbed
sicked	13	45	2440	3	sick_ed
sickee	12	46	2222	3	sick_ee
sickees	13	45	1421	3	sickees
sicken	12	46	1525	3	sick_en
sickens	13	44	1148	3	sickens
sicker	12	40	2390	3	sick_er
sickie	12	37	1574	3	sick_ie
sickies	13	37	1750	3	sickies
sicking	14	37	2017	3	sicking
sickish	16	3	842	3	sickish
sickle	12	44	1832	3	sick_le
sickled	14	47	1343	3	sickled
sickles	13	34	1754	3	sickles
sickly	15	31	1048	3	sick_ly
sickroom	16	4	394	3	sickroom
sicks	11	51	2762	3	sick__s
simious	9	3	980	3	simious
sinciput	12	4	477	3	sinciput
sinuous	7	3	906	3	sinuous
skort	9	49	2564	3	s__kort
slickest	14	22	925	3	slickest
slipout	9	4	908	3	slipout
snout	5	45	3063	3	s__nout
socket	12	39	2352	3	sock_et
socko	11	52	1511	3	socko__
soukous	11	3	641	3	soukous
spinout	9	3	1158	3	spinout
spout	7	50	2963	3	s__pout
sprout	8	4	1940	3	s_prout
stakeout	12	4	714	3	stakeout
stickful	17	4	344	3	stickful
stickit	13	3	946	3	stick_it
stickum	15	3	482	3	stick_um
stickup	15	3	385	3	stick_up
stout	5	74	3405	3	s__tout
succour	11	4	469	3	succour
sukkot	9	3	664	3	sukko_t
surtout	7	4	1167	3	surtout
ticket	12	45	2485	3	tick_et
timeout	9	4	859	3	timeout
vicious	12	3	949	3	vicious
walkout	14	4	793	3	walkout
wicket	15	53	1894	3	wick_et
wickiup	18	17	267	3	wickiup
wickyup	21	17	188	3	wickyup
wideout	11	7	903	3	wideout
wipeout	12	8	787	3	wipeout
without	13	4	888	3	without
workout	14	4	839	3	workout

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	101	7.393	18128.9
3	Display Results	101	101	0.046	2195.7
	(SQL Overall)	178691	101	7.845	22777.7