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

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

264 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
slaps	7	60	2571	(None)
claps	9	56	2618	1	claps
flaps	10	56	2138	1	flaps
laps	6	68	4887	1	_laps
salps	7	44	2324	1	salps
saps	6	53	4637	1	s_aps
slabs	7	53	2264	1	slabs
slags	6	65	2590	1	slags
slams	7	49	2790	1	slams
slap	6	64	3404	1	slap_
slats	5	54	3690	1	slats
slaws	8	52	2271	1	slaws
slays	8	57	2368	1	slays
slips	7	60	2372	1	slips
slops	7	50	2601	1	slops
snaps	7	47	1956	1	snaps
soaps	7	51	2071	1	soaps
swaps	10	48	1920	1	swaps
alans	5	56	3617	2	alans
alas	4	63	5812	2	ala_s
alps	6	55	2924	2	al_ps
ataps	7	64	1483	2	ataps
baps	8	60	4084	2	_baps
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blams	9	50	2385	2	blams
blats	7	51	3250	2	blats
blaws	10	56	2046	2	blaws
blips	9	56	1578	2	blips
caps	8	71	4789	2	_caps
chaps	12	53	2606	2	chaps
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
clamps	12	45	1508	2	clamps
clams	9	51	2767	2	clams
clans	7	50	3101	2	clans
clap	8	64	2904	2	clap_
clapt	9	80	2717	2	clapt
clasp	9	55	1719	2	clasp
clasps	10	45	1209	2	clasps
class	7	55	2548	2	class
claws	10	60	2083	2	claws
clays	10	55	2133	2	clays
clips	9	60	1830	2	clips
clops	9	59	2485	2	clops
craps	9	53	2864	2	craps
daps	7	72	3916	2	_daps
elans	5	55	2775	2	elans
elapse	8	5	752	2	elapse
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flams	10	51	2501	2	flams
flans	8	53	2797	2	flans
flap	9	61	2870	2	flap_
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
flips	10	51	1774	2	flips
flops	10	59	2014	2	flops
fraps	10	56	2055	2	fraps
gaps	7	60	4297	2	_gaps
glads	7	56	2061	2	glads
glams	8	58	2293	2	glams
glans	6	51	2583	2	glans
glass	6	55	1813	2	glass
glops	8	56	1955	2	glops
haps	9	64	4346	2	_haps
heaps	10	52	2322	2	heaps
jalaps	15	29	918	2	jalaps
knaps	11	55	1117	2	knaps
labs	6	71	4512	2	_labs
lacs	6	69	4248	2	_lacs
lads	5	65	4913	2	_lads
lags	5	65	4622	2	_lags
lamps	9	56	2483	2	_lamps
lams	6	65	5226	2	_lams
lap	5	85	6527	2	_lap_
lapis	7	62	2315	2	_lapis
lapse	7	49	1768	2	_lapse
lars	4	69	5657	2	_lars
las	3	72	8147	2	_la_s
lass	4	74	4454	2	_lass
lats	4	59	6270	2	_lats
lavs	7	67	3415	2	_lavs
laws	7	64	4168	2	_laws
lays	7	60	4325	2	_lays
leaps	7	55	2293	2	leaps
lips	6	71	4144	2	_lips
lops	6	60	4335	2	_lops
maps	8	61	4105	2	_maps
naps	6	62	3858	2	_naps
neaps	7	56	1832	2	neaps
palps	9	47	1956	2	palps
paps	8	64	4345	2	_paps
plans	7	57	3127	2	plans
plats	7	55	3137	2	plats
plays	10	63	2077	2	plays
plops	9	59	2033	2	plops
raps	6	62	4773	2	_raps
reaps	7	56	2619	2	reaps
sabs	6	66	4374	2	s_abs
sacs	6	57	3907	2	s_acs
sags	5	59	4840	2	s_ags
salads	7	53	1696	2	salads
salals	6	51	2008	2	salals
saleps	8	50	1490	2	saleps
sales	5	60	5559	2	sales
salp	6	45	3409	2	salp_
salpa	7	50	1835	2	salpa
salpas	8	51	1692	2	salpas
sals	4	68	5167	2	s_als
salts	5	54	3188	2	salts
samps	9	61	2467	2	samps
sans	4	51	5336	2	s_ans
sap	5	64	6323	2	s_ap_
sass	4	50	3562	2	s_ass
saws	7	58	3948	2	s_aws
says	7	59	4210	2	s_ays
scabs	9	48	1864	2	scabs
scads	8	54	1996	2	scads
scags	8	55	2097	2	scags
scalps	10	43	1523	2	scalps
scamps	12	50	1417	2	scamps
scams	9	44	2397	2	scams
scans	7	46	2510	2	scans
scape	9	69	2184	2	scape
scapes	10	51	2226	2	scapes
scarps	10	47	1860	2	scarps
scars	7	54	3353	2	scars
scats	7	59	3060	2	scats
scaups	10	54	1193	2	scaups
scops	9	58	2019	2	scops
scraps	10	60	1724	2	scraps
scups	9	53	1665	2	scups
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seeps	7	48	2875	2	seeps
selahs	9	3	1321	2	selahs
shads	9	51	2448	2	shads
shags	9	51	2386	2	shags
shahs	11	59	1951	2	shahs
shams	10	58	2941	2	shams
shape	10	51	2511	2	shape
shapes	11	51	2494	2	shapes
sharps	11	55	1608	2	sharps
shaws	11	62	2626	2	shaws
shays	11	60	2143	2	shays
ships	10	51	2377	2	ships
shleps	11	47	1033	2	shleps
shnaps	11	4	808	2	shnaps
shops	10	42	2290	2	shops
sials	5	42	2724	2	sials
simps	9	47	1976	2	simps
sips	6	57	4010	2	s_ips
skags	10	43	1607	2	skags
skas	8	53	2571	2	ska_s
skats	9	46	2154	2	skats
skeps	11	56	1425	2	skeps
skips	11	56	1660	2	skips
slab	6	71	3376	2	sla_b
slack	11	50	2176	2	slack
slacks	12	44	1653	2	slacks
slag	5	59	3435	2	sla_g
slain	5	49	2357	2	slain
slake	9	37	2405	2	slake
slakes	10	40	2188	2	slakes
slam	6	77	3797	2	sla_m
slang	6	63	2402	2	slang
slangs	7	56	1534	2	slangs
slank	9	58	2277	2	slank
slant	5	52	3870	2	slant
slants	6	48	1908	2	slants
slash	8	47	1968	2	slash
slat	4	69	5902	2	sla_t
slate	5	54	3828	2	slate
slates	6	49	3406	2	slates
slaty	8	65	2315	2	slaty
slave	8	42	2403	2	slave
slaves	9	50	2302	2	slaves
slaw	7	79	3071	2	sla_w
slay	7	64	3638	2	sla_y
sleds	6	44	1885	2	sleds
sleeps	8	39	1332	2	sleeps
slept	7	57	2810	2	slept
slews	8	62	2035	2	slews
slims	7	54	2365	2	slims
slip	6	70	3173	2	slip_
slipe	7	56	2613	2	slipe
slipes	8	49	2141	2	slipes
slipt	7	66	2748	2	slipt
slits	5	61	2885	2	slits
slobs	7	44	1987	2	slobs
sloes	5	47	2887	2	sloes
slogs	6	45	2184	2	slogs
sloops	8	55	1362	2	sloops
slop	6	65	3387	2	slop_
slope	7	58	2356	2	slope
slopes	8	48	2045	2	slopes
slots	5	48	3053	2	slots
slows	8	53	2346	2	slows
slubs	7	47	1953	2	slubs
slues	5	45	2717	2	slues
slugs	6	46	1856	2	slugs
slumps	10	43	1358	2	slumps
slums	7	46	2343	2	slums
slurps	8	44	1000	2	slurps
slurs	5	41	2337	2	slurs
sluts	5	45	2398	2	sluts
slype	10	51	1236	2	slype
slypes	11	44	1048	2	slypes
snags	6	44	2131	2	snags
snap	6	57	2703	2	snap_
snaws	8	61	1636	2	snaws
sneaps	8	45	1086	2	sneaps
snips	7	58	1801	2	snips
soaks	9	52	2029	2	soaks
soap	6	58	3113	2	soap_
soapy	10	61	1478	2	soapy
soars	5	47	3251	2	soars
solans	6	41	2249	2	solans
sops	6	52	4456	2	s_ops
soups	7	53	2294	2	soups
spaes	7	60	2997	2	spaes
spams	9	49	2219	2	spams
spans	7	45	2873	2	spans
spars	7	54	3154	2	spars
spas	6	70	3672	2	spa_s
spats	7	50	3138	2	spats
spays	10	55	2051	2	spays
splats	8	48	1730	2	splats
splays	11	49	1087	2	splays
stabs	7	62	2138	2	stabs
stags	6	62	2674	2	stags
stamps	10	56	1402	2	stamps
stapes	8	50	2873	2	stapes
staph	10	43	1465	2	staph
staphs	11	44	1103	2	staphs
stars	5	58	3657	2	stars
stats	5	59	3336	2	stats
stays	8	60	2202	2	stays
steps	7	66	1988	2	steps
stops	7	48	2728	2	stops
straps	8	77	2178	2	straps
sumps	9	50	2343	2	sumps
sups	6	48	3443	2	s_ups
swabs	10	58	1727	2	swabs
swags	9	49	2125	2	swags
swamps	13	59	1026	2	swamps
swans	8	46	2501	2	swans
swap	9	59	2543	2	swap_
swats	8	57	2686	2	swats
sways	11	55	1846	2	sways
swops	10	59	1397	2	swops
taps	6	60	5067	2	_taps
traps	7	57	2748	2	traps
ulans	5	49	2130	2	ulans
waps	9	66	4208	2	_waps
whaps	13	51	1516	2	whaps
wraps	10	56	1715	2	wraps
yaps	9	59	3352	2	_yaps
zaps	15	68	2689	2	_zaps

Search took 3 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.300	595636.7
2	DLD Change Limit	53800	264	1.716	31352.0
3	Display Results	264	264	0.080	3300.0
	(SQL Overall)	178691	264	2.096	85253.3