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

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

412 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
detect	9	42	1740	(None)
defect	12	48	1617	1	defect
deject	16	45	1284	1	deject
detects	10	40	1109	1	detects
detent	7	36	2448	1	detent
detest	7	41	2284	1	detest
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
defeat	10	38	1716	2	defeat
defects	13	45	1152	2	defects
deflect	13	39	997	2	deflect
deftest	11	26	1171	2	deftest
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
detach	12	3	1041	2	detach
detected	12	28	973	2	detected
detecter	11	29	873	2	detecter
detector	11	27	832	2	detector
detente	8	33	1360	2	detente
detents	8	36	1515	2	detents
deter	6	50	2804	2	dete_r
deters	7	47	2468	2	deters
detests	8	37	1174	2	detests
detick	13	3	938	2	detick
detract	10	14	1463	2	detract
devest	10	44	1870	2	devest
direct	9	38	1733	2	direct
eject	14	50	1604	2	_eject
elect	7	43	2703	2	_elect
erect	7	41	2933	2	_erect
obtect	10	12	963	2	obtect
refect	11	43	1933	2	refect
reject	15	41	1628	2	reject
resect	8	44	2470	2	resect
retest	6	40	2845	2	retest
select	8	26	2117	2	select
abject	17	13	770	3	abject
adeptest	11	4	545	3	adeptest
advect	12	30	912	3	advect
affect	14	4	890	3	affect
aptest	8	29	1751	3	aptest
aspect	10	6	1282	3	aspect
attent	6	28	1832	3	attent
attest	6	26	1861	3	attest
bedeck	15	3	621	3	bedeck
beech	12	43	1550	3	be_ech
beet	6	64	5754	3	be_e_t
beget	8	56	3256	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
betel	7	44	1990	3	bete_l
betels	8	45	1506	3	betels
bewept	13	4	1032	3	bewept
bisect	10	3	1287	3	bisect
cathect	14	3	986	3	cathect
cement	10	33	2166	3	cement
cete	6	49	3478	3	cete__
cetes	7	57	3110	3	cete_s
coerect	11	9	1335	3	coerect
cutest	8	58	2014	3	cutest
daftest	11	24	894	3	daftest
date	5	64	4332	3	date__
dated	7	55	3099	3	date_d
dater	6	53	3231	3	date_r
daters	7	48	2737	3	daters
dates	6	56	3915	3	date_s
deadest	9	30	1488	3	deadest
deafest	11	29	1151	3	deafest
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
deface	12	31	1386	3	deface
defat	9	54	2669	3	de_fat
defeats	11	35	1123	3	defeats
defecate	14	3	879	3	defecate
defected	15	28	997	3	defected
defector	14	27	795	3	defector
defence	13	3	989	3	defence
defend	11	39	1049	3	defend
defer	9	46	1975	3	defe_r
defers	10	51	1694	3	defers
deffest	14	30	880	3	deffest
deficit	13	3	967	3	deficit
deflects	14	33	673	3	deflects
deft	8	55	4022	3	d__eft
defter	10	42	1592	3	defte_r
defunct	13	4	577	3	defunct
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
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
deltic	9	3	1250	3	deltic_
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
dented	8	41	2051	3	dente_d
dentist	8	3	1674	3	dentist
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
destruct	11	4	838	3	destruct
detail	7	45	1643	3	detail
detain	7	46	1738	3	detain
detecters	12	21	775	3	detect~~ers~~
detecting	13	25	998	3	detect~~ing~~
detection	12	13	1041	3	detect~~ion~~
detective	15	4	810	3	detect~~ive~~
detectors	12	27	830	3	detect~~ors~~
detentes	9	27	1287	3	detentes
deterge	9	11	846	3	deterge
detested	10	27	962	3	detested
detester	9	23	968	3	detester
deticks	14	3	735	3	deticks
detour	7	7	819	3	detour
detox	13	3	1095	3	det_ox
detracts	11	13	883	3	detracts
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
dexter	14	38	1089	3	dexte_r
dialect	10	12	1026	3	dialect
didact	10	7	1120	3	didact
diet	5	73	5753	3	d_ie_t
dieted	8	31	1549	3	diete_d
dieter	7	35	1677	3	diete_r
dieters	8	32	1643	3	dieters
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
distent	8	41	2085	3	distent
ditch	11	50	1509	3	dit_ch
dite	5	55	4755	3	dite__
dites	6	63	3915	3	dite_s
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
dote	5	54	4288	3	dote__
doted	7	52	2707	3	dote_d
doter	6	54	2862	3	dote_r
doters	7	44	2391	3	doters
dotes	6	58	3669	3	dote_s
dotiest	8	37	1745	3	dotiest
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
dueted	8	41	1359	3	duete_d
dulcet	9	3	1449	3	dulcet
dutch	11	47	1382	3	dut_ch
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
effect	14	3	744	3	effect
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
etch	9	54	1914	3	_et_ch
etic	6	61	2395	3	_etic_
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
extent	13	27	1491	3	extent
featest	10	27	1511	3	featest
feet	7	53	5221	3	fe_e_t
fetch	13	49	1347	3	fet_ch
fete	7	57	3492	3	fete__
feted	9	44	2093	3	fete_d
fetes	8	56	3014	3	fete_s
fetich	14	7	969	3	fetich
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
hereat	9	35	2741	3	hereat
hetero	9	3	1263	3	hetero
infect	11	34	1344	3	infect
inject	15	32	1023	3	inject
insect	8	39	1658	3	insect
intact	8	3	1466	3	intact
intent	6	31	2277	3	intent
jete	11	59	2725	3	jete__
jetes	12	49	2284	3	jete_s
keet	8	53	4734	3	ke_e_t
ketch	14	49	1202	3	ket_ch
ketene	10	66	1300	3	ketene
latent	6	41	2430	3	latent
latest	6	38	2270	3	latest
leech	10	49	1321	3	le_ech
leet	4	59	5790	3	le_e_t
leftest	10	26	946	3	leftest
letch	10	52	1580	3	let_ch
meet	6	53	5055	3	me_e_t
merest	8	47	2511	3	merest
mete	6	44	3813	3	mete__
meted	8	54	2443	3	mete_d
meteor	8	49	1007	3	meteor
metepa	10	6	601	3	metepa
meter	7	51	3032	3	mete_r
meters	8	56	2583	3	meters
metes	7	47	3621	3	mete_s
motet	7	56	4119	3	mote_t
mutest	8	42	1805	3	mutest
neatest	7	25	1600	3	neatest
neglect	10	4	736	3	neglect
nett	4	66	4323	3	net__t
newest	9	3	1421	3	newest
object	17	13	580	3	object
obtest	8	12	1301	3	obtest
octet	7	3	2406	3	octe_t
oftest	9	12	1200	3	oftest
outact	8	3	1720	3	outact
outeat	6	28	2453	3	outeat
patent	8	45	2492	3	patent
perfect	14	10	1083	3	perfect
pertest	9	3	1704	3	pertest
peter	7	44	2759	3	pete_r
peters	8	66	2459	3	peters
petit	7	43	3265	3	pet_it
potent	8	42	2335	3	potent
prefect	14	10	1107	3	prefect
prelect	11	10	1383	3	prelect
pretest	9	5	1763	3	pretest
pretext	16	3	966	3	pretext
protect	11	3	1363	3	protect
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
redefect	14	4	605	3	redefect
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
refects	12	40	1274	3	refects
refelt	9	45	2142	3	refelt
reflect	12	39	1371	3	reflect
regent	7	41	2767	3	regent
reheat	9	44	2394	3	reheat
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
retack	12	26	1282	3	retack
retch	10	48	1830	3	ret_ch
rete	4	49	4413	3	rete__
reteach	12	3	741	3	reteach
reteam	8	32	1453	3	reteam
retear	6	31	1548	3	retear
retell	6	38	1364	3	retell
retem	7	42	2195	3	rete_m
retems	8	39	1457	3	retems
retene	6	92	2427	3	retene
retests	7	38	1385	3	retests
retint	6	56	3344	3	retint
retort	6	68	3115	3	retort
retract	9	13	1811	3	retract
retreat	7	3	1753	3	retreat
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
sect	6	74	4362	3	__sect
selects	9	19	1214	3	selects
seneca	8	3	979	3	seneca
septet	8	9	2113	3	septe_t
serest	6	48	3161	3	serest
sestet	6	8	2620	3	seste_t
setout	6	47	1946	3	setout
sett	4	59	4905	3	set__t
sextet	13	9	1687	3	sexte_t
stent	5	56	3451	3	_stent
stet	4	59	4732	3	_ste_t
tact	6	73	4903	3	__tact
teat	4	59	6363	3	__teat
tech	9	59	2544	3	__tech
tecta	7	42	1552	3	__tecta
tenet	5	55	4221	3	tene_t
tent	4	61	5986	3	__tent
tercet	8	36	2491	3	tercet
test	4	86	5162	3	__test
tet	3	92	7499	3	__te_t
text	11	60	3393	3	__text
urtext	13	3	743	3	urtext
vetch	13	44	1184	3	vet_ch
weest	8	50	2677	3	we_est
weet	7	52	5415	3	we_e_t
wettest	10	23	936	3	wettest
xebec	16	37	829	3	xebec_
xebecs	17	35	536	3	xebecs
yett	7	64	3449	3	yet__t
zebec	18	41	926	3	zebec_
zebeck	23	25	520	3	zebeck
zebecs	19	31	618	3	zebecs

Search took 7 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.423	422437.4
2	DLD Change Limit	112716	412	5.766	19548.4
3	Display Results	412	412	0.123	3349.6
	(SQL Overall)	178691	412	6.312	28309.7