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

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

137 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
whops	13	50	1393	(None)
chops	12	50	1987	1	chops
hops	9	79	4263	1	_hops
shops	10	42	2290	1	shops
whaps	13	51	1516	1	whaps
whips	13	49	1708	1	whips
whomps	16	45	760	1	whomps
whoops	14	48	786	1	whoops
whop	12	55	2092	1	whop_
whups	13	42	1000	1	whups
woops	10	49	1752	1	woops
wops	9	66	3415	1	w_ops
bops	8	60	3798	2	_bops
chaps	12	53	2606	2	chaps
chips	12	57	2125	2	chips
chomps	15	51	1222	2	chomps
chop	11	60	2492	2	chop_
chows	13	56	1820	2	chows
clops	9	59	2485	2	clops
coops	9	62	2964	2	coops
cops	8	67	5137	2	_cops
crops	9	61	2523	2	crops
dhows	12	59	1122	2	dhows
drops	8	57	1950	2	drops
flops	10	59	2014	2	flops
fops	9	65	3268	2	_fops
glops	8	56	1955	2	glops
goops	8	66	2096	2	goops
haps	9	64	4346	2	_haps
hips	9	64	3370	2	_hips
hobs	9	70	3898	2	_hobs
hods	8	72	3986	2	_hods
hoes	7	57	5573	2	_hoes
hogs	8	71	3966	2	_hogs
hols	7	69	4629	2	_hols
hons	7	73	5078	2	_hons
hoops	10	56	2107	2	hoops
hop	8	75	5459	2	_hop_
hope	9	66	3967	2	_hope
hopes	10	58	3564	2	_hopes
hos	6	83	6419	2	_ho_s
hots	7	83	4933	2	_hots
hows	10	63	4560	2	_hows
hoys	10	77	3393	2	_hoys
hyps	12	54	1841	2	_hyps
knops	11	59	1181	2	knops
kops	10	70	3129	2	_kops
loops	7	57	2396	2	loops
lops	6	60	4335	2	_lops
mhos	9	55	1777	2	mho_s
mops	8	59	4013	2	_mops
oops	6	52	3267	2	_oops
ops	5	66	4125	2	__ops
phons	10	52	2114	2	phons
phots	10	54	1850	2	phots
plops	9	59	2033	2	plops
poops	9	44	2241	2	poops
pops	8	63	4095	2	_pops
props	9	57	2688	2	props
rhos	7	63	1906	2	rho_s
scops	9	58	2019	2	scops
ships	10	51	2377	2	ships
shoes	8	54	2966	2	shoes
shogs	9	53	1971	2	shogs
shoos	8	42	2636	2	shoos
shop	9	56	2984	2	shop_
shots	8	47	3085	2	shots
shows	11	53	2458	2	shows
slops	7	50	2601	2	slops
sops	6	52	4456	2	_sops
stops	7	48	2728	2	stops
swoops	11	49	1092	2	swoops
swops	10	59	1397	2	swops
thorps	11	36	1089	2	thorps
thous	8	60	1726	2	thous
tops	6	62	4812	2	_tops
wahoos	12	23	1059	2	wahoos
waps	9	66	4208	2	w_aps
warps	10	71	2642	2	warps
wasps	10	67	1469	2	wasps
weeps	10	41	2056	2	weeps
whams	13	55	1564	2	whams
whap	12	51	1964	2	whap_
whats	11	77	1899	2	whats
whaups	14	40	575	2	whaups
wheeps	14	43	995	2	wheeps
whelps	14	43	784	2	whelps
whens	11	46	1876	2	whens
whets	11	50	1961	2	whets
whews	14	51	1449	2	whews
wheys	14	59	1155	2	wheys
whids	12	54	1398	2	whids
whigs	12	56	1264	2	whigs
whims	13	45	1533	2	whims
whins	11	49	2233	2	whins
whip	12	55	2184	2	whip_
whipt	13	53	1742	2	whipt
whirs	11	52	1809	2	whirs
whits	11	59	2382	2	whits
who	9	55	2677	2	who__
whoa	10	66	1520	2	who_a
whole	11	44	1809	2	whole
wholes	12	46	1677	2	wholes
whom	12	70	1818	2	who_m
whomp	15	50	1132	2	whomp
whomso	14	3	413	2	whomso
whoof	14	46	1269	2	whoof
whoofs	15	45	724	2	whoofs
whoop	13	42	1144	2	whoop
whoosh	15	24	435	2	whoosh
whore	11	60	1804	2	whore
whores	12	56	1710	2	whores
whorl	11	46	1245	2	whorl
whorls	12	44	1016	2	whorls
whort	11	46	2369	2	whort
whorts	12	51	1143	2	whorts
whose	11	49	1453	2	whose
whosis	12	3	717	2	whosis
whoso	11	50	922	2	whoso
whumps	16	42	709	2	whumps
whup	12	57	1416	2	whup_
whys	13	70	1166	2	wh_ys
wimps	12	52	1380	2	wimps
wisps	10	52	1418	2	wisps
woes	7	64	4066	2	w_oes
wogs	8	65	3140	2	w_ogs
woks	11	62	2490	2	w_oks
wons	7	49	4204	2	w_ons
woods	9	57	2303	2	woods
woofs	11	49	1800	2	woofs
wools	8	44	2146	2	wools
woos	7	62	3880	2	w_oos
wop	8	71	4513	2	w_op_
wos	6	69	5353	2	w_o_s
wots	7	63	4289	2	w_ots
wows	10	46	3349	2	w_ows
wraps	10	56	1715	2	wraps

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	137	1.360	39558.8
3	Display Results	137	137	0.030	4566.7
	(SQL Overall)	178691	137	1.686	105985.2