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

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

397 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
defect	12	48	1617	(None)
defeat	10	38	1716	1	defeat
defects	13	45	1152	1	defects
deflect	13	39	997	1	deflect
deject	16	45	1284	1	deject
detect	9	42	1740	1	detect
refect	11	43	1933	1	refect
affect	14	4	890	2	affect
deafest	11	29	1151	2	deafest
deceit	9	30	1821	2	deceit
decent	9	40	2370	2	decent
decoct	11	3	1378	2	decoct
deduct	10	6	1079	2	deduct
deet	5	73	5658	2	de_e_t
deface	12	31	1386	2	deface
defat	9	54	2669	2	def_at
defeats	11	35	1123	2	defeats
defecate	14	3	879	2	defecate
defected	15	28	997	2	defected
defector	14	27	795	2	defector
defence	13	3	989	2	defence
defend	11	39	1049	2	defend
defer	9	46	1975	2	defe_r
defers	10	51	1694	2	defers
deffest	14	30	880	2	deffest
deficit	13	3	967	2	deficit
deflects	14	33	673	2	deflects
deft	8	55	4022	2	def__t
deftest	11	26	1171	2	deftest
defunct	13	4	577	2	defunct
dejecta	17	37	636	2	dejecta
dejects	17	38	922	2	dejects
delict	9	43	2033	2	delict
dement	9	38	2514	2	dement
depict	11	35	1479	2	depict
desert	7	27	2549	2	desert
detects	10	40	1109	2	detects
detent	7	36	2448	2	detent
detest	7	41	2284	2	detest
devest	10	44	1870	2	devest
direct	9	38	1733	2	direct
effect	14	3	744	2	effect
eject	14	50	1604	2	_eject
elect	7	43	2703	2	_elect
erect	7	41	2933	2	_erect
infect	11	34	1344	2	infect
perfect	14	10	1083	2	perfect
prefect	14	10	1107	2	prefect
redefect	14	4	605	2	redefect
refects	12	40	1274	2	refects
refelt	9	45	2142	2	refelt
reflect	12	39	1371	2	reflect
reject	15	41	1628	2	reject
resect	8	44	2470	2	resect
select	8	26	2117	2	select
abject	17	13	770	3	abject
advect	12	30	912	3	advect
affects	15	3	539	3	affects
aspect	10	6	1282	3	aspect
bedeck	15	3	621	3	bedeck
beech	12	43	1550	3	be_ech
beet	6	64	5754	3	be_e_t
befell	11	42	871	3	befell
befit	10	52	2266	3	bef_it
befleck	18	4	394	3	befleck
befret	11	3	1596	3	befret
beget	8	56	3255	3	bege_t
behest	11	3	1461	3	behest
bereft	11	43	1730	3	bereft
beret	7	49	4636	3	bere_t
beset	7	67	3913	3	bese_t
bewept	13	4	1032	3	bewept
bisect	10	3	1287	3	bisect
cement	10	33	2166	3	cement
coeffect	18	4	393	3	coeffect
coerect	11	9	1335	3	coerect
confect	14	36	1427	3	confect
daft	8	55	3725	3	daf__t
daftest	11	24	894	3	daftest
deadest	9	30	1488	3	deadest
deafen	10	38	967	3	deafe_n
deafens	11	31	725	3	deafens
deafer	10	41	1481	3	deafe_r
dealt	6	52	3428	3	de_alt
dearest	8	36	1867	3	dearest
debeak	13	3	676	3	debeak
debit	8	57	2785	3	de_bit
debt	7	71	3902	3	d__ebt
debut	8	60	2414	3	de_but
decant	9	35	2422	3	decant
deceits	10	28	1088	3	deceits
decency	15	3	745	3	decency
decern	9	13	1095	3	decern
deck	11	58	2775	3	d__eck
deco	7	61	2597	3	d__eco
decocts	12	3	783	3	decocts
deduce	10	7	925	3	deduce
deducts	11	6	659	3	deducts
dee	4	76	6582	3	de_e__
deed	6	53	4090	3	de_e_d
deeds	7	54	2376	3	de_eds
deedy	10	43	1589	3	de_edy
deem	7	54	3289	3	de_e_m
deems	8	54	2177	3	de_ems
deep	7	60	3188	3	de_e_p
deepest	10	3	1044	3	deepest
deeps	8	49	2177	3	de_eps
deer	5	67	3902	3	de_e_r
deers	6	49	3052	3	de_ers
dees	5	63	5663	3	de_e_s
deets	6	53	3024	3	de_ets
def	7	65	4672	3	def___
defaced	14	29	1097	3	defaced
defacer	13	28	1036	3	defacer
defaces	13	32	1340	3	defaces
defame	12	32	1243	3	defame
defang	11	3	775	3	defang
defats	10	51	1455	3	defats
default	11	4	789	3	default
defeated	13	28	1216	3	defeated
defeater	12	26	1166	3	defeater
defecated	16	3	749	3	defecated
defecates	15	3	859	3	defecates
defecator	15	4	638	3	defecator
defecting	16	25	1022	3	defect~~ing~~
defection	15	16	1064	3	defect~~ion~~
defective	18	4	800	3	defect~~ive~~
defectors	15	23	788	3	defect~~ors~~
defenced	15	3	720	3	defenced
defences	14	3	963	3	defences
defends	12	35	877	3	defends
defense	11	3	750	3	defense
deferent	12	27	1287	3	deferent
deffer	13	44	1130	3	deffer
defi	8	63	2149	3	def__i
defiant	11	3	1192	3	defiant
deficits	14	4	727	3	deficits
defied	11	50	1638	3	defied
defier	10	51	1865	3	defier
defiers	11	39	1399	3	defiers
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
deflected	16	3	598	3	deflected
deflector	15	5	506	3	deflector
defoam	12	3	856	3	defoam
defocus	13	3	528	3	defocus
defog	10	4	852	3	def_og
defogs	11	5	668	3	defogs
deforce	13	26	724	3	deforce
deforest	12	3	879	3	deforest
deform	12	5	961	3	deform
defrag	11	3	646	3	defrag
defray	13	3	764	3	defray
defrock	17	4	464	3	defrock
defrost	11	3	955	3	defrost
defter	10	42	1592	3	defter
deftly	13	3	653	3	deftly
defuel	10	34	893	3	defuel
defuels	11	29	698	3	defuels
defund	11	44	798	3	defund
defuse	10	57	1272	3	defuse
defuze	19	48	784	3	defuze
defy	11	49	2126	3	def__y
degerm	10	3	789	3	degerm
degust	8	3	1025	3	degust
dehort	10	46	1810	3	dehort
deice	8	43	2003	3	de_ice
deiced	10	42	1448	3	deiced
deicer	9	41	1441	3	deicer
deices	9	41	1937	3	deices
deific	12	3	731	3	deific_
deist	6	46	3359	3	de_ist
dejected	19	30	759	3	dejected
deke	9	52	2876	3	deke__
deked	11	57	1853	3	deke_d
dekes	10	52	2445	3	deke_s
dele	5	68	4308	3	dele__
delead	8	41	1234	3	delead
deled	7	53	2654	3	dele_d
deles	6	51	3925	3	dele_s
delete	7	36	2070	3	delete
delft	9	56	2332	3	de_lft
delicts	10	40	1225	3	delicts
delist	7	46	2505	3	delist
delt	5	78	5527	3	d__elt
demast	9	5	1706	3	demast
deme	7	65	3628	3	deme__
demean	9	5	1056	3	demean
dements	10	30	1662	3	dements
demerit	10	3	1499	3	demerit
demes	8	60	3269	3	deme_s
demic	10	51	1919	3	demic_
demit	8	48	3230	3	de_mit
dene	5	66	4341	3	dene__
denes	6	56	3972	3	dene_s
densest	8	31	1247	3	densest
dent	5	71	5841	3	d__ent
depart	9	47	2056	3	depart
depend	10	35	1092	3	depend
deperm	11	3	936	3	deperm
depicts	12	35	846	3	depicts
deport	9	49	2239	3	deport
depot	8	57	2792	3	de_pot
derat	6	50	4408	3	de_rat
dere	5	68	4590	3	dere__
derelict	11	13	848	3	derelict
desalt	7	5	1831	3	desalt
descent	10	26	1629	3	descent
deselect	11	4	752	3	deselect
deserts	8	25	1305	3	deserts
desex	13	3	1198	3	dese_x
desist	7	48	1881	3	desist
despot	9	34	1329	3	despot
dessert	8	29	1645	3	dessert
detach	12	3	1041	3	detach
detected	12	28	973	3	detected
detecter	11	29	873	3	detecter
detector	11	27	832	3	detector
detente	8	33	1360	3	detente
detents	8	36	1515	3	detents
deter	6	50	2804	3	dete_r
deters	7	47	2468	3	deters
detests	8	37	1174	3	detests
detick	13	3	938	3	detick
detract	10	14	1463	3	detract
deuce	8	45	1749	3	de_uce
deuced	10	41	1212	3	deuced
deuces	9	40	1551	3	deuces
devein	10	3	914	3	devein
devel	9	42	1712	3	deve_l
devels	10	43	1390	3	devels
devests	11	44	1047	3	devests
device	12	45	1216	3	device
devout	10	7	1299	3	devout
dewed	10	50	2030	3	dewe_d
dewiest	11	3	1234	3	dewiest
dexes	13	52	2451	3	dexe_s
dialect	10	12	1026	3	dialect
didact	10	7	1120	3	didact
diet	5	73	5753	3	d_ie_t
digest	8	40	1962	3	digest
dioecy	12	3	554	3	dioecy
directs	10	27	1026	3	directs
direst	7	50	2424	3	direst
disject	17	26	867	3	disject
dissect	10	36	1413	3	dissect
divert	10	39	2281	3	divert
divest	10	68	2007	3	divest
docent	9	29	1868	3	docent
doest	6	58	2952	3	d_oest
dovecot	13	5	673	3	dovecot
dreck	12	48	1280	3	d_reck
drest	6	55	3034	3	d_rest
driest	7	47	2275	3	driest
dryest	10	48	1112	3	dryest
duct	7	57	3546	3	d__uct
duet	5	64	4626	3	d_ue_t
dulcet	9	3	1449	3	dulcet
duvet	9	3	2187	3	duve_t
dwelt	9	43	1652	3	d_welt
edict	8	47	2228	3	_edict
educt	8	50	1710	3	_educt
effects	15	3	528	3	effects
eft	6	60	3882	3	_ef__t
egest	6	52	2234	3	_egest
ejecta	15	33	739	3	_ejecta
ejects	15	40	995	3	_ejects
elects	8	33	1500	3	_elects
enact	7	35	2536	3	_enact
epact	9	49	2153	3	_epact
erects	8	41	1618	3	_erects
eruct	7	40	2235	3	_eruct
event	8	59	2444	3	_event
evert	8	49	2951	3	_evert
evict	10	44	1714	3	_evict
exact	14	35	1693	3	_exact
exec	13	53	1394	3	_exec_
execs	14	53	972	3	_execs
exert	12	46	2414	3	_exert
expect	17	5	890	3	expect
exsect	15	5	850	3	exsect
fact	9	71	4254	3	__fact
feat	7	64	5822	3	__feat
feck	13	49	2343	3	__feck
feet	7	53	5221	3	__feet
felt	7	51	4693	3	__felt
fest	7	49	4944	3	__fest
fet	6	64	7163	3	__fe_t
fewest	12	3	1166	3	fewest
feyest	12	3	1140	3	feyest
geest	6	48	2961	3	ge_est
genet	6	60	3868	3	gene_t
gerent	7	32	2309	3	gerent
heft	10	67	3629	3	hef__t
hereat	9	35	2741	3	hereat
infects	12	27	971	3	infects
infest	9	33	1543	3	infest
inflect	12	4	922	3	inflect
inject	15	32	1023	3	inject
insect	8	39	1658	3	insect
jefe	14	65	1688	3	jefe__
jefes	15	56	1367	3	jefe_s
keet	8	53	4733	3	ke_e_t
leech	10	49	1321	3	le_ech
leet	4	59	5790	3	le_e_t
left	7	63	4048	3	lef__t
leftest	10	26	946	3	leftest
liefest	10	3	844	3	liefest
meet	6	53	5055	3	me_e_t
merest	8	47	2511	3	merest
neglect	10	4	736	3	neglect
newest	9	3	1421	3	newest
object	17	13	580	3	object
obtect	10	12	963	3	obtect
perfecta	15	11	520	3	perfecta
perfecto	15	10	574	3	perfecto
perfects	15	10	735	3	perfects
praefect	15	4	477	3	praefect
prefects	15	9	813	3	prefects
prelect	11	10	1383	3	prelect
react	7	46	3433	3	re_act
rebec	9	44	1654	3	rebec_
rebeck	14	41	991	3	rebeck
rebecs	10	39	1367	3	rebecs
recent	8	36	3085	3	recent
recept	10	33	1907	3	recept
redact	9	4	1904	3	redact
redefeat	12	4	631	3	redefeat
redefects	15	4	379	3	redefects
reeject	16	34	962	3	reeject
reelect	9	115	1563	3	reelect
reerect	9	29	1588	3	reerect
reest	5	49	3809	3	re_est
reface	11	36	1635	3	reface
refected	14	23	1166	3	refected
refed	9	39	2192	3	refe_d
refeed	10	47	1762	3	refeed
refeel	9	39	1324	3	refeel
refel	8	49	2081	3	refe_l
refell	9	42	1444	3	refell
refels	9	46	1805	3	refels
refence	12	3	1223	3	refence
refer	8	48	2214	3	refe_r
refers	9	39	2108	3	refers
refit	8	42	3006	3	ref_it
reflects	13	28	887	3	reflects
reflet	9	40	2423	3	reflet
refract	12	13	1160	3	refract
reft	7	51	4127	3	ref__t
regent	7	41	2767	3	regent
reheat	9	44	2394	3	reheat
reinfect	13	4	648	3	reinfect
rejects	16	39	1069	3	rejects
relent	6	44	3185	3	relent
relet	5	47	4982	3	rele_t
relict	8	36	2390	3	relict
reluct	8	39	1611	3	reluct
remeet	8	63	2547	3	remeet
remelt	8	51	2312	3	remelt
remet	7	48	4372	3	reme_t
renest	6	45	2971	3	renest
repeat	8	51	2721	3	repeat
repent	8	47	2887	3	repent
rerent	6	38	3245	3	rerent
reseat	6	41	3149	3	reseat
resects	9	41	1559	3	resects
resent	6	38	3362	3	resent
reset	5	50	5186	3	rese_t
respect	11	4	1203	3	respect
retest	6	40	2845	3	retest
revert	9	35	2911	3	revert
revest	9	46	2360	3	revest
revet	8	49	3884	3	reve_t
rewet	8	51	3515	3	rewe_t
rifest	9	31	1458	3	rifest
safest	9	50	1660	3	safest
sect	6	74	4362	3	__sect
selects	9	19	1214	3	selects
seneca	8	3	979	3	seneca
serest	6	48	3161	3	serest
tenet	5	55	4221	3	tene_t
tercet	8	36	2491	3	tercet
unfelt	9	24	1346	3	unfelt
webfeet	15	4	459	3	webfeet
weest	8	50	2677	3	we_est
weet	7	52	5415	3	we_e_t
weft	10	54	3501	3	wef__t
xebec	16	37	829	3	xebec_
xebecs	17	35	536	3	xebecs
zebec	18	41	926	3	zebec_
zebeck	23	25	520	3	zebeck
zebecs	19	31	618	3	zebecs

Search took 6 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.126	1418182.5
2	DLD Change Limit	112716	397	5.263	21416.7
3	Display Results	397	397	0.126	3150.8
	(SQL Overall)	178691	397	5.515	32400.9