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

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

273 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
deers	6	49	3052	(None)
beers	7	56	2839	1	beers
dears	6	57	3688	1	dears
deeds	7	54	2376	1	deeds
deems	8	54	2177	1	deems
deeps	8	49	2177	1	deeps
deer	5	67	3902	1	deer_
dees	5	63	5663	1	dee_s
deets	6	53	3024	1	deets
defers	10	51	1694	1	defers
deters	7	47	2468	1	deters
doers	6	52	2571	1	doers
dyers	9	66	1713	1	dyers
jeers	12	48	1813	1	jeers
leers	5	48	2898	1	leers
peers	7	51	3027	1	peers
seers	5	51	3638	1	seers
veers	8	45	2136	1	veers
adders	8	43	1570	2	adders
adeems	9	4	633	2	adeems
agers	6	50	2785	2	agers
ameers	8	40	1557	2	ameers
apers	7	66	2913	2	apers
avers	8	51	2731	2	avers
bears	7	57	3904	2	bears
beefs	10	56	1856	2	beefs
beeps	9	53	2097	2	beeps
beer	6	56	3599	2	beer_
beery	10	52	2012	2	beery
bees	6	54	5338	2	bee_s
beets	7	61	3144	2	beets
biers	7	62	2522	2	biers
ceders	9	38	1767	2	ceders
cees	6	59	4159	2	cee_s
ceres	7	55	4001	2	ceres
cheers	11	45	1891	2	cheers
darers	7	59	2187	2	darers
dares	6	61	4670	2	dares
daters	7	48	2737	2	daters
deads	7	57	2691	2	deads
deairs	7	40	1378	2	deairs
dealers	8	41	1861	2	dealers
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear_
deary	9	58	2684	2	deary
debars	9	42	1804	2	debars
debris	9	33	1149	2	debris
debs	7	65	3024	2	d_ebs
debts	8	64	1837	2	debts
decern	9	13	1095	2	decern
decerns	10	11	905	2	decerns
deckers	14	44	1383	2	deckers
decks	12	48	2219	2	decks
decors	9	40	1777	2	decors
decos	8	55	2212	2	decos
decry	11	55	1435	2	decry
dee	4	76	6582	2	dee__
deed	6	53	4090	2	dee_d
deedy	10	43	1589	2	deedy
deem	7	54	3289	2	dee_m
deep	7	60	3188	2	dee_p
deet	5	73	5658	2	dee_t
defer	9	46	1975	2	defer_
defiers	11	39	1399	2	defiers
defis	9	67	1750	2	defis
degas	7	51	1916	2	degas
degerm	10	3	789	2	degerm
degerms	11	3	562	2	degerms
deicers	10	36	1273	2	deicers
deils	6	57	2286	2	deils
dekes	10	52	2445	2	dekes
deles	6	51	3925	2	deles
delfs	9	49	1867	2	delfs
delis	6	49	2854	2	delis
dells	6	66	3094	2	dells
dels	5	67	4547	2	d_els
delts	6	57	3179	2	delts
delvers	11	34	1199	2	delvers
demes	8	60	3269	2	demes
demos	8	60	2299	2	demos
demurs	9	3	977	2	demurs
denars	7	46	2143	2	denars
denes	6	56	3972	2	denes
deniers	8	45	1518	2	deniers
dens	5	59	4507	2	d_ens
dents	6	50	3180	2	dents
deperm	11	3	936	2	deperm
deperms	12	3	660	2	deperms
dere	5	68	4590	2	d_ere
derm	7	60	3189	2	d_erm
derms	8	50	2289	2	derms
derris	7	36	1527	2	derris
derry	9	47	2137	2	derry
desert	7	27	2549	2	desert
deserts	8	25	1305	2	deserts
desks	10	59	1307	2	desks
deter	6	50	2804	2	deter_
devas	9	62	1888	2	devas
devels	10	43	1390	2	devels
devs	8	64	2403	2	d_evs
dewars	10	51	1707	2	dewars
dews	8	62	3060	2	d_ews
dexes	13	52	2451	2	dexes
deys	8	50	2747	2	d_eys
dicers	9	47	2074	2	dicers
dies	5	56	5352	2	die_s
dieters	8	32	1643	2	dieters
diets	6	60	2664	2	diets
dikers	11	44	1879	2	dikers
dimers	9	43	2109	2	dimers
diners	7	55	2595	2	diners
divers	10	50	2496	2	divers
doer	5	77	3470	2	doer_
does	5	65	5447	2	doe_s
doors	6	50	2213	2	doors
dopers	9	55	2248	2	dopers
dorrs	6	55	2059	2	dorrs
dors	5	67	4760	2	d_ors
dosers	7	57	2363	2	dosers
doters	7	44	2391	2	doters
dowers	10	45	2329	2	dowers
dozers	16	48	1542	2	dozers
drears	7	46	1425	2	drears
drees	6	56	2852	2	drees
dregs	7	61	1486	2	dregs
dreks	10	57	1475	2	dreks
dress	6	53	1983	2	dress
driers	7	45	1673	2	driers
dryers	10	44	927	2	dryers
duelers	8	34	1205	2	duelers
duels	6	56	1923	2	duels
dues	5	60	4550	2	due_s
duets	6	53	2388	2	duets
dupers	9	46	1560	2	dupers
dures	6	56	3592	2	dures
durrs	6	55	1999	2	durrs
dweebs	12	3	365	2	dweebs
dyer	8	55	2211	2	dyer_
dyes	8	53	3189	2	dye_s
ears	4	63	5659	2	_ears
edgers	8	44	1392	2	edgers
eels	4	65	3674	2	_eels
eery	7	61	2962	2	_eery
egers	6	51	2037	2	egers
emeers	8	33	1418	2	emeers
errs	4	56	2253	2	_errs
ers	3	60	4628	2	__ers
ewers	8	60	1882	2	ewers
eyers	8	65	2133	2	eyers
fears	8	48	2939	2	fears
feebs	10	61	1268	2	feebs
feeds	9	49	2114	2	feeds
feels	8	52	2304	2	feels
fees	7	64	5060	2	fee_s
feres	8	60	3818	2	feres
fevers	12	54	1489	2	fevers
fleers	9	60	1579	2	fleers
freers	9	47	1730	2	freers
gears	6	46	2869	2	gears
geeks	10	49	1584	2	geeks
gees	5	56	4788	2	gee_s
goers	6	55	2025	2	goers
hears	8	67	3737	2	hears
heders	10	41	1976	2	heders
heeds	9	54	2042	2	heeds
heels	8	56	2553	2	heels
heirs	8	56	1856	2	heirs
heres	8	62	4590	2	heres
hers	7	58	4487	2	_hers
hewers	12	37	1527	2	hewers
hexers	16	56	1275	2	hexers
hoers	8	57	2492	2	hoers
idlers	7	40	1281	2	idlers
jeeps	14	47	1537	2	jeeps
jeer	11	54	2646	2	jeer_
jees	11	59	3854	2	jee_s
keefs	12	51	1628	2	keefs
keeks	8	47	1725	2	keeks
keels	9	46	2241	2	keels
keens	9	57	2118	2	keens
keeps	11	60	2028	2	keeps
keets	9	51	2348	2	keets
keirs	9	53	1367	2	keirs
kiers	9	53	2009	2	kiers
lears	5	59	3873	2	lears
leeks	9	53	1889	2	leeks
leer	4	62	3935	2	leer_
leery	8	59	1913	2	leery
lees	4	54	5588	2	lee_s
leets	5	49	2712	2	leets
legers	7	45	1831	2	legers
lehrs	8	61	1113	2	lehrs
lepers	8	48	1732	2	lepers
levers	9	46	2132	2	levers
liers	5	51	3040	2	liers
meeds	8	49	2027	2	meeds
meets	7	42	2461	2	meets
meres	7	51	4357	2	meres
meters	8	56	2583	2	meters
nears	5	55	2942	2	nears
needs	6	57	1963	2	needs
neems	7	73	1629	2	neems
neeps	7	56	1788	2	neeps
omers	7	69	2319	2	omers
overs	8	52	2479	2	overs
oyers	8	76	2088	2	oyers
pears	7	51	3861	2	pears
peeks	11	50	2111	2	peeks
peels	7	52	2642	2	peels
peens	7	64	2819	2	peens
peeps	9	58	2236	2	peeps
peer	6	62	3835	2	peer_
peery	10	57	1944	2	peery
pees	6	52	5737	2	pee_s
peres	7	62	4664	2	peres
peters	8	66	2459	2	peters
piers	7	59	2633	2	piers
queers	15	35	1077	2	queers
rears	5	47	3965	2	rears
reeds	6	54	3090	2	reeds
reefs	8	51	2166	2	reefs
reeks	9	41	2403	2	reeks
reels	5	53	3326	2	reels
rees	4	53	6419	2	ree_s
refers	9	39	2108	2	refers
revers	9	45	2963	2	revers
ruers	5	150	1941	2	ruers
sears	5	47	4491	2	sears
seders	7	44	2028	2	seders
seeds	6	43	3006	2	seeds
seeks	9	47	2464	2	seeks
seels	5	56	3282	2	seels
seems	7	55	2502	2	seems
seeps	7	48	2875	2	seeps
seer	4	55	4704	2	seer_
sees	4	53	6105	2	see_s
seres	5	54	4889	2	seres
sers	4	57	4665	2	_sers
severs	9	41	2112	2	severs
sewers	9	47	1972	2	sewers
sheers	9	43	2240	2	sheers
sneers	6	40	1617	2	sneers
speers	8	50	1995	2	speers
steers	6	38	2098	2	steers
suers	5	51	2848	2	suers
tears	5	54	3646	2	tears
teels	5	57	2637	2	teels
teems	7	60	1978	2	teems
teens	5	62	2748	2	teens
tees	4	53	5358	2	tee_s
tiers	5	55	2652	2	tiers
tyers	8	62	2005	2	tyers
udders	8	39	1129	2	udders
users	5	58	1757	2	users
veeps	10	47	1572	2	veeps
veer	7	62	2957	2	veer_
veery	11	58	1625	2	veery
vees	7	54	3943	2	vee_s
vexers	16	52	1040	2	vexers
viers	8	56	2195	2	viers
wears	8	60	3030	2	wears
webers	11	3	1094	2	webers
weeds	9	52	2221	2	weeds
weeks	12	50	1786	2	weeks
weens	8	52	2405	2	weens
weeps	10	41	2056	2	weeps
weer	7	55	3509	2	weer_
wees	7	62	4912	2	wee_s
weets	8	54	2772	2	weets
weirs	8	43	1649	2	weirs
years	8	45	2767	2	years
zees	13	63	3189	2	zee_s

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.300	595636.7
2	DLD Change Limit	53800	273	1.466	36698.5
3	Display Results	273	273	0.080	3412.5
	(SQL Overall)	178691	273	1.846	96799.0