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

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

311 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
detects	10	40	1109	(None)
defects	13	45	1152	1	defects
dejects	17	38	922	1	dejects
detect	9	42	1740	1	detect_
detents	8	36	1515	1	detents
detests	8	37	1174	1	detests
deceits	10	28	1088	2	deceits
decocts	12	3	783	2	decocts
deducts	11	6	659	2	deducts
deets	6	53	3024	2	de_e_ts
defeats	11	35	1123	2	defeats
defect	12	48	1617	2	defect_
deflects	14	33	673	2	deflects
deject	16	45	1284	2	deject_
dejecta	17	37	636	2	dejecta
delicts	10	40	1225	2	delicts
dements	10	30	1662	2	dements
depicts	12	35	846	2	depicts
deserts	8	25	1305	2	deserts
detected	12	28	973	2	detected
detecter	11	29	873	2	detecter
detecters	12	21	775	2	detecters
detector	11	27	832	2	detector
detectors	12	27	830	2	detectors
detent	7	36	2448	2	detent_
detente	8	33	1360	2	detente
detentes	9	27	1287	2	detentes
deters	7	47	2468	2	dete_rs
detest	7	41	2284	2	detest_
deticks	14	3	735	2	deticks
detracts	11	13	883	2	detracts
devests	11	44	1047	2	devests
directs	10	27	1026	2	directs
ejects	15	40	995	2	_ejects
elects	8	33	1500	2	_elects
erects	8	41	1618	2	_erects
refects	12	40	1274	2	refects
rejects	16	39	1069	2	rejects
resects	9	41	1559	2	resects
retests	7	38	1385	2	retests
selects	9	19	1214	2	selects
advects	13	27	601	3	advects
affects	15	3	539	3	affects
aspects	11	4	674	3	aspects
attests	7	27	881	3	attests
bedecks	16	3	579	3	bedecks
beets	7	61	3144	3	be_e_ts
begets	9	62	1552	3	bege_ts
behests	12	3	595	3	behests
berets	8	58	2252	3	bere_ts
besets	8	57	1880	3	bese_ts
betels	8	45	1506	3	bete_ls
bisects	11	3	713	3	bisects
cathects	15	4	579	3	cathects
cements	11	27	1422	3	cements
cetes	7	57	3110	3	cete__s
coerects	12	5	854	3	coerects
daters	7	48	2737	3	date_rs
dates	6	56	3915	3	date__s
debeaks	14	3	610	3	debeaks
debits	9	42	1450	3	de_bits
debts	8	64	1837	3	d__ebts
debuts	9	39	1175	3	de_buts
decants	10	35	1444	3	decants
deceit	9	30	1821	3	deceit_
decent	9	40	2370	3	decent_
decerns	10	11	905	3	decerns
decks	12	48	2219	3	d__ecks
decoct	11	3	1378	3	decoct_
decos	8	55	2212	3	d__ecos
deduces	11	6	879	3	deduces
deduct	10	6	1079	3	deduct_
deeds	7	54	2376	3	de_e_ds
deems	8	54	2177	3	de_e_ms
deeps	8	49	2177	3	de_e_ps
deers	6	49	3052	3	de_e_rs
dees	5	63	5663	3	de_e__s
deet	5	73	5658	3	de_e_t_
defaces	13	32	1340	3	defaces
defats	10	51	1455	3	de_fats
defeat	10	38	1716	3	defeat_
defecate	14	3	879	3	defecate
defecates	15	3	859	3	defecates
defected	15	28	997	3	defected
defector	14	27	795	3	defector
defectors	15	23	788	3	defectors
defences	14	3	963	3	defences
defends	12	35	877	3	defends
defers	10	51	1694	3	defe_rs
deficits	14	4	727	3	deficits
deflect	13	39	997	3	deflect_
defocus	13	3	528	3	defocus
deftest	11	26	1171	3	deftest_
degerms	11	3	562	3	degerms
degusts	9	3	606	3	degusts
dehorts	11	37	977	3	dehorts
deicers	10	36	1273	3	deicers
deices	9	41	1937	3	de_ices
deists	7	49	1643	3	de_ists
dejected	19	30	759	3	dejected
dekes	10	52	2445	3	deke__s
deleads	9	37	970	3	deleads
deles	6	51	3925	3	dele__s
delete	7	36	2070	3	dele_te
deletes	8	31	1793	3	deletes
delfts	10	43	967	3	de_lfts
delict	9	43	2033	3	delict_
delists	8	44	1417	3	delists
delts	6	57	3179	3	d__elts
demasts	10	8	922	3	demasts
demeans	10	3	971	3	demeans
dement	9	38	2514	3	dement_
demerits	11	3	1076	3	demerits
demes	8	60	3269	3	deme__s
demits	9	49	1807	3	de_mits
denes	6	56	3972	3	dene__s
dentists	9	3	926	3	dentists
dents	6	50	3180	3	d__ents
departs	10	43	1068	3	departs
depends	11	34	899	3	depends
deperms	12	3	660	3	deperms
depict	11	35	1479	3	depict_
deports	10	50	1288	3	deports
depots	9	47	1634	3	de_pots
derats	7	46	2506	3	de_rats
derelicts	12	15	418	3	derelicts
desalts	8	3	957	3	desalts
descents	11	25	1120	3	descents
deselects	12	4	449	3	deselects
desert	7	27	2549	3	desert_
desexes	15	3	783	3	desexes
desists	8	36	1172	3	desists
despots	10	31	968	3	despots
desserts	9	24	792	3	desserts
destructs	12	4	577	3	destructs
detach	12	3	1041	3	detac_h
detaches	14	3	965	3	detaches
details	8	42	1404	3	details
detains	8	37	1609	3	detains
detecting	13	25	998	3	detecting
detection	12	13	1041	3	detection
detections	13	14	1004	3	detect~~ion~~s
detective	15	4	810	3	detective
detectives	16	4	578	3	detect~~ive~~s
detentist	10	4	932	3	detentist
deter	6	50	2804	3	dete__r
deterge	9	11	846	3	deterge
deterges	10	15	1009	3	deterges
detested	10	27	962	3	detested
detester	9	23	968	3	detester
detesters	10	29	830	3	detesters
detick	13	3	938	3	detic_k
detours	8	5	804	3	detours
detoxes	15	3	880	3	detoxes
detract	10	14	1463	3	detract_
detritus	9	4	547	3	detritus
deuces	9	40	1551	3	de_uces
deveins	11	3	880	3	deveins
devels	10	43	1390	3	deve_ls
devest	10	44	1870	3	devest_
devices	13	32	1258	3	devices
dexes	13	52	2451	3	dexe__s
dialects	11	12	600	3	dialects
didacts	11	8	606	3	didacts
dieters	8	32	1643	3	diete_rs
diets	6	60	2664	3	d_ie_ts
digests	9	36	1061	3	digests
direct	9	38	1733	3	direct_
disjects	18	27	592	3	disjects
dissects	11	27	924	3	dissects
dites	6	63	3915	3	dite__s
diverts	11	44	1203	3	diverts
divests	11	45	1093	3	divests
docents	10	28	1080	3	docents
doters	7	44	2391	3	dote_rs
dotes	6	58	3669	3	dote__s
dovecots	14	4	432	3	dovecots
drecks	13	45	920	3	d_recks
ducts	8	53	1989	3	d__ucts
duets	6	53	2388	3	d_ue_ts
dulcets	10	4	628	3	dulcets
duteous	8	3	845	3	duteous
duvets	10	3	922	3	duve_ts
edicts	9	49	1170	3	_edicts
educts	9	43	989	3	_educts
effects	15	3	528	3	effects
egests	7	44	1125	3	_egests
eject	14	50	1604	3	_eject_
ejecta	15	33	739	3	_ejecta
elect	7	43	2703	3	_elect_
enacts	8	40	1297	3	_enacts
epacts	10	50	1039	3	_epacts
erect	7	41	2933	3	_erect_
eructs	8	36	1079	3	_eructs
events	9	48	1407	3	_events
everts	9	45	1489	3	_everts
evicts	11	36	855	3	_evicts
exacts	15	35	961	3	_exacts
execs	14	53	972	3	_exec_s
exerts	13	37	1229	3	_exerts
expects	18	6	688	3	expects
exsects	16	5	557	3	exsects
extents	14	26	1017	3	extents
fetes	8	56	3014	3	fete__s
geests	7	59	1216	3	ge_ests
genets	7	57	1666	3	gene_ts
gerents	8	26	1292	3	gerents
heteros	10	3	1268	3	heteros
infects	12	27	971	3	infects
injects	16	25	745	3	injects
insects	9	37	1084	3	insects
intents	7	21	1570	3	intents
jetes	12	49	2284	3	jete__s
keets	9	51	2348	3	ke_e_ts
ketenes	11	48	1350	3	ketenes
latents	7	52	1431	3	latents
latests	7	39	1031	3	latests
leets	5	49	2712	3	le_e_ts
meets	7	42	2461	3	me_e_ts
meteors	9	46	1001	3	meteors
metepas	11	3	630	3	metepas
meters	8	56	2583	3	mete_rs
metes	7	47	3621	3	mete__s
motets	8	42	1619	3	mote_ts
neglects	11	4	438	3	neglects
netts	5	53	2072	3	net__ts
objects	18	12	369	3	objects
obtect	10	12	963	3	obtect_
obtests	9	13	623	3	obtests
octets	8	3	940	3	octe_ts
outacts	9	3	1021	3	outacts
outeats	7	22	1570	3	outeats
patents	9	48	1520	3	patents
perfects	15	10	735	3	perfects
peters	8	66	2459	3	pete_rs
prefects	15	9	813	3	prefects
prelects	12	9	972	3	prelects
pretests	10	3	1001	3	pretests
pretexts	17	3	560	3	pretexts
protects	12	3	974	3	protects
reacts	8	36	1660	3	re_acts
rebecks	15	28	801	3	rebecks
rebecs	10	39	1367	3	rebec_s
recepts	11	30	1026	3	recepts
redacts	10	5	1094	3	redacts
redefects	15	4	379	3	redefects
reejects	17	33	608	3	reejects
reelects	10	31	1088	3	reelects
reerects	10	31	992	3	reerects
reests	6	46	1889	3	re_ests
refect	11	43	1933	3	refect_
reflects	13	28	887	3	reflects
regents	8	34	1654	3	regents
reheats	10	45	1352	3	reheats
reject	15	41	1628	3	reject_
relents	7	40	1850	3	relents
relets	6	40	2567	3	rele_ts
relicts	9	44	1459	3	relicts
relucts	9	36	967	3	relucts
remeets	9	37	1241	3	remeets
remelts	9	35	1149	3	remelts
renests	7	40	1421	3	renests
repeats	9	43	1605	3	repeats
repents	9	37	1762	3	repents
rerents	7	33	1942	3	rerents
reseats	7	43	1958	3	reseats
resect	8	44	2470	3	resect_
resents	7	42	2122	3	resents
resets	6	54	2761	3	rese_ts
respects	12	4	770	3	respects
retacks	13	22	1071	3	retacks
reteams	9	33	956	3	reteams
retears	7	28	1492	3	retears
retells	7	32	1152	3	retells
retems	8	39	1457	3	rete_ms
retenes	7	63	2462	3	retenes
retest	6	40	2845	3	retest_
retints	7	47	1701	3	retints
retorts	7	60	1651	3	retorts
retracts	10	11	1131	3	retracts
retreats	8	3	1141	3	retreats
reverts	10	47	1504	3	reverts
revests	10	44	1373	3	revests
revets	9	40	2217	3	reve_ts
rewets	9	46	1721	3	rewe_ts
sects	7	56	2289	3	__sects
select	8	26	2117	3	select_
senecas	9	3	901	3	senecas
septets	9	9	895	3	septe_ts
sestets	7	9	1147	3	seste_ts
setouts	7	41	1033	3	setouts
setts	5	51	2432	3	set__ts
sextets	14	9	714	3	sexte_ts
stents	6	50	1945	3	_stents
stets	5	54	2391	3	_ste_ts
tacts	7	65	2412	3	__tacts
teats	5	56	3681	3	__teats
techs	10	69	1583	3	__techs
tecta	7	42	1552	3	__tecta
tenets	6	55	1895	3	tene_ts
tents	5	64	3421	3	__tents
tercets	9	35	1244	3	tercets
tests	5	65	3019	3	__tests
tets	4	58	4746	3	__te_ts
texts	12	55	1504	3	__texts
urtexts	14	3	314	3	urtexts
weets	8	54	2772	3	we_e_ts
xebecs	17	35	536	3	xebec_s
yetts	8	67	1513	3	yet__ts
zebecks	24	27	419	3	zebecks
zebecs	19	31	618	3	zebec_s

Search took 8 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	134027	0.390	458182.1
2	DLD Change Limit	134027	311	6.813	19672.2
3	Display Results	311	311	0.126	2468.3
	(SQL Overall)	178691	311	7.329	24381.4