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

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

371 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
deflea	10	3	744	(None)
beflea	11	4	712	1	beflea
defleas	11	4	722	1	defleas
befleas	12	3	697	2	befleas
dealer	7	41	2214	2	dealer
defeat	10	38	1716	2	def_eat
defer	9	46	1975	2	def_er
deffer	13	44	1130	2	deffer
defied	11	50	1638	2	defied
defier	10	51	1865	2	defier
defies	10	46	2405	2	defies
defile	10	52	1666	2	defile_
defiled	12	40	1310	2	defiled
defiler	11	39	1188	2	defiler
defiles	11	40	1684	2	defiles
defleaed	13	4	495	2	defleaed
deflect	13	39	997	2	deflect
defter	10	42	1592	2	defter
defuel	10	34	893	2	defuel
dele	5	68	4308	2	de_le_
delead	8	41	1234	2	de_lead
deled	7	53	2654	2	de_led
deles	6	51	3925	2	de_les
delta	6	61	1777	2	de_lta
flea	7	56	2849	2	__flea
reflet	9	40	2423	2	reflet
reflew	12	38	945	2	reflew
reflex	16	35	951	2	reflex
azalea	15	3	700	3	azalea
befell	11	42	871	3	befell
beflag	12	6	588	3	beflag
befleaed	14	5	466	3	befleaed
befleck	18	4	394	3	befleck
befret	11	3	1596	3	befret
beleap	10	4	1028	3	be_leap
belga	8	3	1323	3	be_lga
belle	7	58	2783	3	belle_
belled	9	46	2619	3	belled
belles	8	53	2599	3	belles
biflex	18	3	495	3	biflex
ceiled	9	41	1495	3	ceiled
ceiler	8	40	1396	3	ceiler
celeb	9	3	1487	3	ce_leb
cella	7	54	2031	3	ce_lla
cellae	8	49	1593	3	cellae
celled	9	44	2032	3	celled
daffed	14	42	949	3	daffed
dafter	10	48	1334	3	dafter
dahlia	10	3	577	3	dahlia
dale	5	56	4398	3	d_ale_
dales	6	64	3974	3	d_ales
dalles	7	42	2206	3	dalles
deaden	8	37	1432	3	deaden
deader	8	42	2047	3	deader
deafen	10	38	967	3	deafen
deafer	10	41	1481	3	deafer
deafly	13	38	912	3	deafl_y
deal	5	63	4741	3	deal__
dealers	8	41	1861	3	dealers
deals	6	54	3534	3	deal_s
dealt	6	52	3428	3	deal_t
deaned	8	46	2045	3	deaned
dearer	7	48	2280	3	dearer
deave	9	50	2233	3	deave_
deaved	11	49	1655	3	deaved
deaves	10	53	1953	3	deaves
debeak	13	3	676	3	de_beak
debye	11	3	890	3	debye_
debyes	12	3	810	3	debyes
decile	9	46	1921	3	decile_
deciles	10	44	1772	3	deciles
decked	14	52	1762	3	decked
deckel	13	49	1104	3	deckel
decker	13	52	1599	3	decker
deckle	13	120	1245	3	deckle_
deckles	14	33	1280	3	deckles
declaw	12	6	670	3	declaw
decree	9	31	1778	3	decree
dee	4	76	6582	3	de__e_
deed	6	53	4090	3	de__ed
deeded	9	46	1554	3	deeded
deem	7	54	3289	3	de__em
deemed	10	47	1306	3	deemed
deep	7	60	3188	3	de__ep
deepen	9	33	919	3	deepen
deeper	9	36	1350	3	deeper
deer	5	67	3902	3	de__er
dees	5	63	5663	3	de__es
deet	5	73	5658	3	de__et
def	7	65	4672	3	def___
deface	12	31	1386	3	deface
defaced	14	29	1097	3	defaced
defacer	13	28	1036	3	defacer
defaces	13	32	1340	3	defaces
defame	12	32	1243	3	defame
defamed	14	30	983	3	defamed
defamer	13	27	1032	3	defamer
defames	13	28	1225	3	defames
defang	11	3	775	3	defang
defat	9	54	2669	3	def_at
defats	10	51	1455	3	defats
defeats	11	35	1123	3	def_eats
defect	12	48	1617	3	defect
defend	11	39	1049	3	defend
defers	10	51	1694	3	defers
deffest	14	30	880	3	deffest
defi	8	63	2149	3	def__i
defiers	11	39	1399	3	defiers
defilers	12	43	947	3	defilers
define	10	47	1814	3	define
defined	12	38	1382	3	defined
definer	11	44	1377	3	definer
defines	11	41	1868	3	defines
defis	9	67	1750	3	def_is
deflate	11	36	1394	3	deflate
deflated	13	34	1230	3	deflated
deflater	12	32	1160	3	deflater
deflates	12	30	1394	3	deflates
defleaing	14	4	474	3	deflea~~ing~~
deflects	14	33	673	3	deflects
deflexed	20	4	388	3	deflexed
deflower	15	12	607	3	deflower
defoam	12	3	856	3	defoam
defog	10	4	852	3	def_og
defogs	11	5	668	3	defogs
deform	12	5	962	3	deform
defrag	11	3	646	3	defrag
defray	13	3	764	3	defray
deft	8	55	4022	3	def__t
deftest	11	26	1171	3	deftest
deftly	13	3	653	3	deftly
defueled	13	7	451	3	defueled
defuels	11	29	698	3	defuels
defund	11	44	798	3	defund
defuse	10	57	1272	3	defuse
defused	12	52	1109	3	defused
defuser	11	51	1050	3	defuser
defuses	11	48	1459	3	defuses
defuze	19	48	784	3	defuze
defuzed	21	44	704	3	defuzed
defuzes	20	39	830	3	defuzes
defy	11	49	2126	3	def__y
degree	8	28	1485	3	degree
deice	8	43	2003	3	deice_
deiced	10	42	1448	3	deiced
deicer	9	41	1441	3	deicer
deices	9	41	1937	3	deices
deified	12	31	1241	3	deified
deifier	11	30	1312	3	deifier
deifies	11	33	1745	3	deifies
deil	5	62	3162	3	deil__
deils	6	57	2286	3	deil_s
deke	9	52	2876	3	de_ke_
deked	11	57	1853	3	de_ked
dekes	10	52	2445	3	de_kes
del	4	67	5275	3	de_l__
delay	9	48	2063	3	de_lay
deleads	9	37	970	3	de_leads
deleave	11	4	772	3	de_leave
delete	7	36	2070	3	de_lete
delf	8	54	3657	3	de_l_f
delfs	9	49	1867	3	de_lfs
delft	9	56	2332	3	de_lft
delfts	10	43	967	3	delfts
deli	5	56	3129	3	de_l_i
delis	6	49	2854	3	de_lis
dell	5	69	3820	3	de_l_l
dellies	8	36	2221	3	dellies
dells	6	66	3094	3	de_lls
delly	9	60	2387	3	de_lly
dels	5	67	4547	3	de_l_s
delt	5	78	5527	3	de_l_t
deltas	7	44	1482	3	de_ltas
delts	6	57	3179	3	de_lts
delve	9	60	1826	3	de_lve
delved	11	41	1275	3	delved
delver	10	49	1349	3	delver
delves	10	49	1708	3	delves
deme	7	65	3628	3	de_me_
demean	9	5	1056	3	de_mean
demes	8	60	3269	3	de_mes
demies	9	48	2580	3	demies
demoed	10	37	1344	3	demoed
dene	5	66	4341	3	de_ne_
denes	6	56	3972	3	de_nes
denied	8	43	1863	3	denied
denier	7	44	2069	3	denier
denies	7	47	2964	3	denies
denned	8	42	1563	3	denned
dense	6	59	2350	3	dense_
denser	7	41	1519	3	denser
dented	8	41	2051	3	dented
deplete	10	30	1042	3	deplete
deploy	12	3	758	3	deploy
dere	5	68	4590	3	de_re_
derma	8	49	1851	3	de_rma
desex	13	3	1198	3	de_sex
deter	6	50	2804	3	de_ter
deuce	8	45	1749	3	deuce_
deuced	10	41	1212	3	deuced
deuces	9	40	1551	3	deuces
deva	8	57	2098	3	de__va
devel	9	42	1712	3	de_vel
develed	12	36	1193	3	develed
devels	10	43	1390	3	devels
deviled	12	41	1218	3	deviled
dewed	10	50	2030	3	de_wed
dewier	10	40	1346	3	dewier
dewlap	12	6	484	3	dewlap
dewless	11	3	747	3	dewless
dexes	13	52	2451	3	de_xes
dexie	13	47	1689	3	dexie_
dexies	14	50	1834	3	dexies
dexter	14	38	1089	3	dexter
dhole	9	52	1536	3	dhole_
dholes	10	49	1479	3	dholes
dialed	8	47	1645	3	dialed
dialer	7	43	1543	3	dialer
differ	13	39	1084	3	differ
dilled	8	41	2222	3	dilled
diplex	16	40	805	3	diplex
dirled	8	45	1490	3	dirled
dobla	8	49	1364	3	dobl_a
doffed	14	42	850	3	doffed
doffer	13	39	1135	3	doffer
dogleg	9	3	632	3	dogleg
doiled	8	48	1729	3	doiled
dole	5	65	5000	3	d_ole_
doled	7	54	3091	3	d_oled
doles	6	78	4375	3	d_oles
dolled	8	35	1807	3	dolled
dolma	8	62	1417	3	d_olma
doolee	7	30	1895	3	doolee
doula	6	57	1777	3	doul_a
doyley	13	48	728	3	doyley
dueled	8	48	1366	3	dueled
dueler	7	42	1368	3	dueler
duelled	9	35	975	3	duelled
dueller	8	32	983	3	dueller
duffel	13	40	775	3	duffel
duffer	13	47	1166	3	duffer
duffle	13	36	853	3	duffle_
duffles	14	30	892	3	duffles
dulia	6	10	1498	3	d_ulia
dulled	8	47	1942	3	dulled
duller	7	40	1770	3	duller
duple	8	53	1586	3	duple_
duplex	16	38	697	3	duplex
dwelled	12	33	759	3	dwelled
dweller	11	29	727	3	dweller
edile	6	48	1949	3	edile_
ediles	7	40	1698	3	ediles
feeler	9	32	1517	3	feeler
fella	8	49	1865	3	fe_lla
felled	10	37	2030	3	felled
feller	9	44	1955	3	feller
fleam	10	60	1728	3	__fleam
fleas	8	64	2366	3	__fleas
fled	8	54	2977	3	__fled
flee	7	62	3879	3	__flee
flew	10	58	2425	3	__flew
flex	14	61	2347	3	__flex
fley	10	66	2685	3	__fley
galea	6	47	2294	3	_galea
gelee	6	36	2698	3	ge_lee
gelled	8	47	1889	3	gelled
healed	10	51	2144	3	healed
healer	9	42	2180	3	healer
heeled	10	40	1841	3	heeled
heeler	9	39	1731	3	heeler
hefted	13	49	1142	3	hefted
hefter	12	43	1392	3	hefter
heiled	10	44	1561	3	heiled
helled	10	40	2470	3	helled
heller	9	33	2251	3	heller
henley	12	3	748	3	henley
ilea	4	59	3146	3	__ilea
jefe	14	65	1688	3	jef_e_
jefes	15	56	1367	3	jef_es
jelled	14	49	1606	3	jelled
keeled	11	44	1427	3	keeled
kegler	11	39	824	3	kegler
kelep	11	60	1456	3	ke_lep
lea	3	76	6018	3	___lea
leaflet	10	19	974	3	leaflet
lefter	9	36	1343	3	lefter
medley	12	9	834	3	medley
melee	7	37	2910	3	me_lee
melena	8	11	1047	3	me_lena
melled	9	50	2302	3	melled
merle	7	58	2437	3	merle_
merles	8	53	2276	3	merles
mewled	12	37	1005	3	mewled
mewler	11	35	1023	3	mewler
olea	4	65	3272	3	__olea
palea	7	50	2866	3	_palea
pealed	9	53	2281	3	pealed
pedler	9	36	1462	3	pedler
peeled	9	41	1971	3	peeled
peeler	8	35	1738	3	peeler
pele	6	55	3955	3	pe_le_
peles	7	57	3808	3	pe_les
pellet	8	33	2655	3	pellet
pepla	9	3	1286	3	pepl_a
perea	7	50	2644	3	pe_rea
pilea	7	51	2395	3	_pilea
plea	6	68	3060	3	__plea
quelea	15	4	730	3	quelea
realer	6	35	2859	3	realer
reales	6	49	3412	3	reales
realia	6	3	1459	3	realia
reclean	9	3	852	3	reclean
redleg	8	3	927	3	redleg
reeled	7	47	2553	3	reeled
reeler	6	38	2257	3	reeler
refed	9	39	2192	3	ref_ed
refeed	10	47	1762	3	refeed
refeel	9	39	1324	3	refeel
refel	8	49	2081	3	ref_el
refell	9	42	1444	3	refell
refels	9	46	1805	3	refels
refelt	9	45	2142	3	refelt
refer	8	48	2214	3	ref_er
reffed	13	47	1251	3	reffed
refile	9	51	2237	3	refile_
refiled	11	43	1865	3	refiled
refiles	10	41	2242	3	refiles
reflag	10	9	808	3	reflag
reflect	12	39	1371	3	reflect
reflets	10	35	1315	3	reflets
reflies	10	44	1853	3	reflies
refloat	10	3	1083	3	refloat
reflow	12	37	965	3	reflow
reflux	16	31	541	3	reflux
refly	11	39	1456	3	refl_y
refuel	9	39	1262	3	refuel
reglet	7	37	2423	3	reglet
relet	5	47	4982	3	re_let
replead	10	39	901	3	replead
repled	9	33	1978	3	repled
rifle	8	55	1833	3	rifle_
rifled	10	41	1500	3	rifled
rifler	9	40	1426	3	rifler
rifles	9	42	1770	3	rifles
sealed	7	43	2836	3	sealed
sealer	6	39	2896	3	sealer
seeled	7	39	2209	3	seeled
selfed	10	3	1091	3	selfed
selle	5	44	2831	3	selle_
seller	6	38	2460	3	seller
selles	6	44	2698	3	selles
selva	8	30	1427	3	se_lva
teflon	9	3	745	3	teflon
tela	4	55	3297	3	te_l_a
telae	5	43	2329	3	te_lae
tele	4	50	4087	3	te_le_
telega	7	3	677	3	te_lega
teles	5	45	3600	3	te_les
telex	12	52	1482	3	te_lex
telfer	9	37	989	3	telfer
telia	5	58	2114	3	te_lia
teller	6	35	1982	3	teller
tesla	5	56	1260	3	tesl_a
vealed	10	39	1632	3	vealed
vealer	9	40	1654	3	vealer
veiled	10	37	1454	3	veiled
veiler	9	38	1435	3	veiler
vela	7	57	2554	3	ve_l_a
welled	10	38	2021	3	welled
yelled	10	41	1625	3	yelled
yeller	9	42	1451	3	yeller

Search took 10 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	112716	0.406	440125.6
2	DLD Change Limit	112716	371	9.203	12247.7
3	Display Results	371	371	0.233	1592.3
	(SQL Overall)	178691	371	9.842	18156.0