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

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

323 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
defray	13	3	764	(None)
defrag	11	3	646	1	defrag
defrays	14	3	611	1	defrays
deray	9	50	2418	1	de_ray
affray	15	3	497	2	affray
betray	11	15	1144	2	betray
bewray	14	14	773	2	bewray
dearly	10	46	1532	2	dearly
deary	9	58	2684	2	dear_y
decay	11	47	1848	2	de_cay
decry	11	55	1435	2	decr_y
deejay	17	3	452	2	deejay
defat	9	54	2669	2	def_at
defeat	10	38	1716	2	defeat
defoam	12	3	856	2	defoam
defrags	12	3	619	2	defrags
defraud	12	4	391	2	defraud
defrayal	15	4	261	2	defrayal
defrayed	16	3	540	2	defrayed
defrayer	15	3	493	2	defrayer
deftly	13	3	653	2	deftly
defy	11	49	2126	2	def__y
delay	9	48	2063	2	de_lay
denary	10	53	1686	2	denary
derat	6	50	4408	2	de_rat
derays	10	55	1425	2	de_rays
derby	11	47	1534	2	de_rby
derry	9	47	2137	2	de_rry
dray	8	54	2809	2	d__ray
fray	10	54	2890	2	__fray
orfray	12	3	439	2	orfray
refry	11	44	1246	2	refr_y
aery	7	72	3168	3	ae_r_y
affrays	16	4	406	3	affrays
array	8	63	1714	3	_array
astray	9	56	1554	3	astray
beery	10	52	2012	3	beer_y
beflag	12	6	588	3	beflag
befret	11	3	1596	3	befret
belay	10	50	2152	3	be_lay
belfry	14	3	507	3	belfr_y
benday	12	38	1081	3	benday
berry	10	45	2177	3	be_rry
betrays	12	12	782	3	betrays
bewrap	13	15	705	3	bewrap
bewrays	15	14	511	3	bewrays
bray	9	52	3290	3	__bray
cedary	12	41	960	3	cedary
daffy	15	55	1028	3	daf_fy
daftly	13	3	544	3	daftly
dairy	9	70	1630	3	dair_y
darky	13	60	1883	3	d_arky
datary	10	3	1024	3	datary
day	7	62	5411	3	d___ay
dead	6	54	3424	3	de__ad
deadly	11	38	1147	3	deadly
deaf	8	58	3840	3	de__af
deafly	13	38	912	3	deafly
deal	5	63	4741	3	de__al
dean	5	60	3948	3	de__an
dear	5	53	4360	3	de__ar
dearer	7	48	2280	3	dearer
dearie	7	33	1981	3	dearie
dears	6	57	3688	3	dear_s
dearth	10	42	1251	3	dearth
deathy	13	42	1023	3	deathy
debag	9	42	1230	3	de_bag
debar	8	55	1786	3	de_bar
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
debeak	13	3	676	3	debeak
debris	9	33	1149	3	debris
decaf	11	49	1944	3	de_caf
decal	8	55	2323	3	de_cal
decare	9	39	1915	3	decare
decays	12	46	1291	3	de_cays
declaw	12	6	670	3	declaw
decoy	11	57	1631	3	de_coy
decree	9	31	1778	3	decree
decrial	10	3	1032	3	decrial
decury	12	7	796	3	decury
dedal	7	57	1902	3	de_dal
deedy	10	43	1589	3	de_edy
deejays	18	4	343	3	deejays
deeply	12	5	701	3	deeply
deer	5	67	3902	3	deer__
deerfly	14	4	398	3	deerfly
deers	6	49	3052	3	deer_s
deewan	10	26	755	3	deewan
def	7	65	4672	3	def___
deface	12	31	1386	3	deface
defame	12	32	1243	3	defame
defang	11	3	775	3	defang
defats	10	51	1455	3	defats
defeats	11	35	1123	3	defeats
defect	12	48	1617	3	defect
defend	11	39	1049	3	defend
defer	9	46	1975	3	def_er
deferral	12	4	435	3	deferral
defers	10	51	1694	3	defers
deffer	13	44	1130	3	deffer
defi	8	63	2149	3	def__i
defiant	11	3	1192	3	defiant
defied	11	50	1638	3	defied
defier	10	51	1865	3	defier
defies	10	46	2405	3	defies
defile	10	52	1666	3	defile
define	10	47	1814	3	define
defis	9	67	1750	3	def_is
deflate	11	36	1394	3	deflate
deflea	10	3	744	3	deflea
defleas	11	4	722	3	defleas
defoams	13	3	619	3	defoams
defog	10	4	852	3	def_og
defogs	11	5	668	3	defogs
deforce	13	26	724	3	deforce
deform	12	5	962	3	deform
deforms	13	3	780	3	deforms
defrauds	13	4	324	3	defrauds
defrayals	16	4	228	3	defray~~als~~
defrayers	16	4	417	3	defray~~ers~~
defraying	17	3	585	3	defray~~ing~~
defrock	17	4	464	3	defrock
defrost	11	3	955	3	defrost
deft	8	55	4022	3	def__t
defter	10	42	1592	3	defter
defuel	10	34	893	3	defuel
defund	11	44	798	3	defund
defuse	10	57	1272	3	defuse
defuze	19	48	784	3	defuze
degas	7	51	1916	3	de_gas
degrade	10	22	990	3	degrade
degree	8	28	1485	3	degree
deify	12	41	1276	3	de_ify
deity	9	43	1677	3	de_ity
dekare	11	28	1156	3	dekare
delays	10	40	1405	3	de_lays
delead	8	41	1234	3	delead
delly	9	60	2387	3	de_lly
delta	6	61	1777	3	delta_
deltas	7	44	1482	3	deltas
demark	13	42	1102	3	demark
demean	9	5	1056	3	demean
demy	10	54	2285	3	de__my
denar	6	52	2329	3	de_nar
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
denial	7	47	2051	3	denial
dental	7	43	1917	3	dental
deny	8	60	2712	3	de__ny
deodar	8	3	771	3	deodar
deoxy	16	4	888	3	de_oxy
depart	9	47	2056	3	depart
deploy	12	3	758	3	deploy
deprave	13	3	707	3	deprave
deputy	12	42	671	3	deputy
derail	7	42	1881	3	de_rail
derate	7	45	3123	3	de_rate
derats	7	46	2506	3	de_rats
dere	5	68	4590	3	de_r_e
derm	7	60	3189	3	de_r_m
derma	8	49	1851	3	de_rma
dermal	9	36	1434	3	dermal
dermas	9	41	1681	3	dermas
derms	8	50	2289	3	de_rms
derris	7	36	1527	3	derris
descry	12	5	618	3	descry
desman	9	3	1169	3	desman
desoxy	17	4	462	3	desoxy
destroy	11	3	815	3	destroy
detract	10	14	1463	3	detract
detrain	8	4	1225	3	detrain
deva	8	57	2098	3	de_va_
devas	9	62	1888	3	de_vas
dewan	9	57	1804	3	de_wan
dewar	9	58	1773	3	de_war
dewars	10	51	1707	3	dewars
dewax	16	55	1085	3	de_wax
dewily	13	3	834	3	dewily
dewlap	12	6	484	3	dewlap
dewy	11	54	1902	3	de__wy
dextral	15	7	700	3	dextral
dextran	15	8	616	3	dextran
dexy	15	61	1855	3	de__xy
dey	7	72	4337	3	de___y
diary	9	50	1697	3	diar_y
dietary	11	5	866	3	dietary
diram	8	44	1947	3	d_iram
dirty	9	56	1780	3	d_irty
dismay	12	22	947	3	dismay
dobra	8	50	1310	3	dobra_
dobras	9	48	1191	3	dobras
doorway	14	4	424	3	doorway
dorky	13	55	1874	3	d_orky
dormy	11	58	1747	3	d_ormy
dorty	9	62	2081	3	d_orty
dory	8	58	3623	3	d_or_y
doura	6	65	1866	3	doura_
dourah	10	47	981	3	dourah
douras	7	50	1672	3	douras
dourly	10	32	1043	3	dourly
dowry	12	63	1248	3	dowr_y
drab	7	62	2645	3	d__rab
drag	6	48	2505	3	d__rag
dram	7	58	3200	3	d__ram
drat	5	62	4783	3	d__rat
draw	8	56	2301	3	d__raw
drays	9	58	1977	3	d__rays
dreary	10	46	1167	3	drear_y
dry	7	65	2603	3	d__r_y
dura	5	52	3211	3	d_ura_
dural	6	49	2389	3	d_ural
duras	6	57	2773	3	d_uras
durra	6	53	1579	3	durra_
durras	7	47	1337	3	durras
early	8	53	2412	3	_early
eery	7	61	2962	3	_eer_y
embay	12	34	1060	3	_embay
era	3	57	4150	3	_e_ra_
eras	4	54	4150	3	_e_ras
essay	8	6	762	3	_essay
estray	9	57	1333	3	estray
eyra	7	62	1755	3	_eyra_
eyras	8	47	1592	3	_eyras
eyry	10	63	1588	3	_eyr_y
fay	9	74	5486	3	__f_ay
feral	8	54	2465	3	fe_ral
ferly	11	55	1735	3	fe_rly
ferny	11	58	1618	3	fe_rny
ferry	11	60	2080	3	fe_rry
flay	10	63	3280	3	__flay
foray	11	50	2397	3	_foray
frae	7	53	3047	3	__frae
frag	8	51	2627	3	__frag
frap	9	59	2581	3	__frap
frat	7	56	4854	3	__frat
frays	11	69	2010	3	__frays
fry	9	62	2650	3	__fr_y
gerah	9	3	1530	3	ge_rah
germy	11	51	1366	3	ge_rmy
gray	8	53	2989	3	__gray
hearsay	13	3	552	3	hearsay
hearty	12	63	1363	3	hearty
hefty	14	61	1213	3	hef_ty
henry	11	40	1447	3	henr_y
herby	13	47	1531	3	he_rby
herry	11	49	2247	3	he_rry
heyday	16	3	514	3	heyday
hooray	12	30	1137	3	hooray
hurray	12	45	991	3	hurray
infra	8	3	864	3	infra_
jerky	19	67	1242	3	je_rky
jerry	15	50	1618	3	je_rry
jetway	19	10	527	3	jetway
kerry	12	49	1609	3	ke_rry
keyway	19	4	382	3	keyway
leary	8	59	2738	3	lear_y
leery	8	59	1913	3	leer_y
leeway	12	5	588	3	leeway
lefty	11	56	1356	3	lef_ty
mercy	12	59	1618	3	me_rcy
merry	10	47	2149	3	me_rry
moray	10	54	2379	3	_moray
nearby	11	35	605	3	nearby
nearly	9	48	1373	3	nearly
nerdy	9	50	1470	3	ne_rdy
nervy	11	46	1086	3	ne_rvy
neural	6	3	1199	3	neural
ofay	10	64	1610	3	_of_ay
orfrays	13	4	353	3	orfrays
pearly	11	64	1484	3	pearly
peery	10	57	1944	3	peer_y
perdy	11	54	1733	3	pe_rdy
perky	14	53	1948	3	pe_rky
perry	10	52	2271	3	pe_rry
pray	9	63	3153	3	__pray
ray	6	63	6199	3	___ray
redbay	12	3	833	3	redbay
redraw	10	26	985	3	redraw
redry	9	43	1436	3	redr_y
reflag	10	9	808	3	reflag
refly	11	39	1456	3	ref_ly
refract	12	13	1160	3	refract
refrain	10	3	1004	3	refrain
reframe	12	3	939	3	reframe
relay	8	44	2467	3	re_lay
repay	10	48	1845	3	re_pay
replay	11	34	1292	3	replay
reran	5	73	2910	3	re_ran
resay	8	53	2054	3	re_say
respray	12	3	650	3	respray
retral	6	44	1974	3	retral
retry	8	47	1808	3	retr_y
rewrap	11	12	753	3	rewrap
seaway	12	30	999	3	seaway
senary	9	37	1607	3	senary
sera	4	61	4139	3	se_ra_
serac	7	59	2520	3	se_rac
serai	5	68	3016	3	se_rai
seral	5	63	3638	3	se_ral
serry	8	48	2412	3	se_rry
spray	10	67	2006	3	_spray
stray	8	85	2557	3	_stray
sunray	9	3	1012	3	sunray
teary	8	51	2405	3	tear_y
terai	5	35	2548	3	te_rai
terra	5	44	1967	3	terra_
terrae	6	29	1521	3	terrae
terras	6	35	1697	3	terras
terry	8	47	2187	3	te_rry
tetra	5	34	1795	3	tetra_
tetrad	7	36	1205	3	tetrad
tetras	6	30	1762	3	tetras
tray	7	76	3259	3	__tray
veejay	19	3	370	3	veejay
veery	11	58	1625	3	veer_y
vera	7	68	2884	3	ve_ra_
very	10	80	2564	3	ve_r_y
weary	11	56	2061	3	wear_y
weirdy	13	39	546	3	weirdy
yearly	12	52	1027	3	yearly
zebra	16	3	788	3	zebra_
zebras	17	3	785	3	zebras

Search took 9 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.373	479064.3
2	DLD Change Limit	112716	323	7.500	15028.8
3	Display Results	323	323	0.250	1292.0
	(SQL Overall)	178691	323	8.123	21998.2