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

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

284 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
detours	8	5	804	(None)
detour	7	7	819	1	detour_
devours	11	6	664	1	devours
debtors	10	3	853	2	debto_rs
decors	9	40	1777	2	deco_rs
demurs	9	3	977	2	de_murs
deters	7	47	2468	2	det_ers
detoured	10	3	651	2	detoured
detoxes	15	3	880	2	detoxes
devoirs	11	7	578	2	devoirs
devour	10	7	670	2	devour_
dolours	8	43	882	2	dolours
dyvours	14	5	318	2	dyvours
fetors	9	10	1447	2	feto_rs
repours	9	3	1023	2	repours
setous	6	49	1737	2	setou_s
setouts	7	41	1033	2	setouts
stours	6	50	1563	2	_stours
tenours	7	26	1007	2	tenours
tours	5	53	2589	2	__tours
velours	10	27	808	2	velours
vetoers	10	35	947	2	vetoers
acetous	9	4	1036	3	acetou_s
actors	8	10	1677	3	acto_rs
aethers	10	36	1494	3	aethers
amours	8	35	1266	3	_amours
arbours	9	39	1004	3	arbours
ardours	8	36	888	3	ardours
armours	9	38	985	3	armours
auteurs	7	13	751	3	auteurs
befouls	12	3	605	3	befouls
bescours	12	4	509	3	bescours
betons	8	49	1955	3	beto_ns
betters	9	44	2209	3	betters
bettors	9	33	1247	3	bettors
bevors	11	16	1034	3	bevo_rs
bezoars	18	3	679	3	bezoars
centaurs	10	3	573	3	centaurs
cerous	8	58	2120	3	cerou_s
clours	8	52	1509	3	_clours
colours	9	59	1344	3	colours
contours	10	3	965	3	contours
cutouts	9	3	803	3	cutouts
daters	7	48	2737	3	dat_ers
datos	6	52	2278	3	dato__s
datums	9	3	635	3	dat_ums
datura	7	3	804	3	dat_ura
daturas	8	3	878	3	dat_uras
deairs	7	40	1378	3	de_airs
dealers	8	41	1861	3	dealers
dears	6	57	3688	3	de__ars
debars	9	42	1804	3	de_bars
deboners	11	26	811	3	deboners
debones	10	33	1511	3	debones
debouch	15	12	425	3	debouch
debtor	9	3	833	3	debto_r_
debugs	10	46	782	3	de_bugs
debuts	9	39	1175	3	de_buts
deckers	14	44	1383	3	deckers
decocts	12	3	783	3	decocts
decoders	12	28	1041	3	decoders
decodes	11	39	1498	3	decodes
decolors	11	8	771	3	decolors
decolours	12	7	441	3	decolours
decor	8	47	1757	3	deco_r_
decorum	12	4	694	3	decorum
decorums	13	4	499	3	decorums
decos	8	55	2212	3	deco__s
decoyers	14	28	771	3	decoyers
decoys	12	39	1128	3	deco_ys
decury	12	7	796	3	de_cury
deers	6	49	3052	3	de__ers
defers	10	51	1694	3	de_fers
defiers	11	39	1399	3	defiers
defoams	13	3	619	3	defoams
defocus	13	3	528	3	defocus
defogs	11	5	668	3	defo_gs
deform	12	5	962	3	defo_rm
deforms	13	3	780	3	deforms
degauss	9	3	392	3	degauss
degums	10	43	862	3	de_gums
dehorn	10	43	965	3	deho_rn
dehorns	11	42	836	3	dehorns
dehort	10	46	1810	3	deho_rt
dehorts	11	37	977	3	dehorts
deicers	10	36	1273	3	deicers
delators	9	23	1483	3	delato_rs
delouse	8	3	983	3	delouse
delousers	10	4	466	3	delousers
delouses	9	3	1001	3	delouses
deltoids	10	4	548	3	deltoids
delvers	11	34	1199	3	delvers
demobs	11	42	948	3	demo_bs
demons	9	49	1772	3	demo_ns
demos	8	60	2299	3	demo__s
demoses	10	38	1583	3	demoses
demotes	10	47	1767	3	demotes
demount	10	4	974	3	demount
demounts	11	3	547	3	demounts
demur	8	3	1116	3	de_mur_
demure	9	3	1153	3	de_mure
denars	7	46	2143	3	de_nars
dengues	9	3	818	3	dengues
deniers	8	45	1518	3	deniers
denotes	8	38	1700	3	denotes
denture	8	3	1189	3	denture
dentures	9	3	1245	3	dentures
deodars	9	3	762	3	deodars
depones	10	37	1709	3	depones
deport	9	49	2239	3	depo_rt
deports	10	50	1288	3	deports
deposers	11	35	924	3	deposers
deposes	10	31	1721	3	deposes
depots	9	47	1634	3	depo_ts
desorb	9	52	1020	3	deso_rb
desorbs	10	43	771	3	desorbs
details	8	42	1404	3	details
detains	8	37	1609	3	detains
detects	10	40	1109	3	detects
detents	8	36	1515	3	detents
deter	6	50	2804	3	det_er_
detests	8	37	1174	3	detests
deticks	14	3	735	3	deticks
detinues	9	56	982	3	detinues
detouring	11	3	697	3	detouring
detox	13	3	1095	3	deto__x
detoxed	16	3	610	3	detoxed
detrude	9	3	608	3	detrude
detrudes	10	3	620	3	detrudes
devious	11	3	852	3	deviou_s
devoir	10	7	603	3	devoir_
devons	10	45	1225	3	devo_ns
devotes	11	37	1375	3	devotes
devoured	13	3	572	3	devoured
devourer	12	3	506	3	devourer
devourers	13	4	409	3	devourers
devout	10	7	1299	3	devou_t
dewars	10	51	1707	3	de_wars
dewools	11	4	559	3	dewools
deworm	12	4	953	3	dewo_rm
deworms	13	3	803	3	deworms
dextrous	16	4	659	3	dextrou_s
dieters	8	32	1643	3	diet_ers
diethers	12	5	745	3	diethers
dimouts	10	3	789	3	dimouts
diseurs	8	3	940	3	diseurs
dithers	11	40	1615	3	dithers
doctors	10	3	999	3	docto_rs
doers	6	52	2571	3	d__oers
dolors	7	51	1531	3	dolo_rs
dolour	7	57	1013	3	dolour_
donors	7	51	1579	3	dono_rs
doors	6	50	2213	3	d__oors
dorrs	6	55	2059	3	d__orrs
dors	5	67	4760	3	d__o_rs
doters	7	44	2391	3	dot_ers
dotters	8	37	1597	3	dotters
doums	8	54	1764	3	d__oums
dour	5	63	3043	3	d__our_
doura	6	65	1866	3	d__oura
douras	7	50	1672	3	d__ouras
drouks	11	3	712	3	d_rouks
dugouts	9	3	504	3	dugouts
duteous	8	3	845	3	duteou_s
dyvour	13	9	334	3	dyvour_
ecotours	10	4	446	3	ecotours
editors	8	3	942	3	edito_rs
ethers	9	45	1841	3	_ethers
etuis	5	40	1313	3	_et_uis
faitours	11	3	426	3	faitours
favours	13	43	709	3	favours
femurs	11	3	671	3	fe_murs
fervours	14	5	305	3	fervours
fetor	8	12	1453	3	feto_r_
fetters	10	35	1790	3	fetters
fetus	8	58	1654	3	fet_u_s
flours	9	44	1405	3	_flours
foetors	10	3	976	3	foeto_rs
fours	8	55	2149	3	__fours
gators	7	41	1584	3	gato_rs
getters	8	42	1610	3	getters
getups	9	34	685	3	get_ups
giaours	8	3	457	3	giaours
hectors	12	35	1326	3	hecto_rs
honours	10	33	938	3	honours
hours	8	54	2239	3	__hours
humours	12	8	644	3	humours
inpours	9	3	642	3	inpours
jetons	13	45	1261	3	jeto_ns
ketols	10	42	1076	3	keto_ls
ketones	11	50	1450	3	ketones
ketoses	11	49	1287	3	ketoses
ketosis	11	42	973	3	ketosis
labours	9	34	989	3	labours
lectors	9	34	1577	3	lecto_rs
lemurs	8	3	725	3	le_murs
letters	7	38	1985	3	letters
letups	8	31	768	3	let_ups
lours	5	51	2529	3	__lours
memoirs	11	3	680	3	memoirs
mentors	9	3	1499	3	mento_rs
meous	7	61	2006	3	me_ou_s
meteors	9	46	1001	3	meteors
meters	8	56	2583	3	met_ers
metiers	9	33	1284	3	metiers
metols	8	41	1577	3	meto_ls
metopes	11	3	1136	3	metopes
motors	8	46	1660	3	moto_rs
nestors	7	36	1497	3	nesto_rs
netops	8	3	922	3	neto_ps
netters	7	36	1858	3	netters
odours	7	41	825	3	_odours
ours	4	72	3756	3	___ours
outpours	10	3	668	3	outpours
pelorus	9	3	927	3	pelorus
peters	8	66	2459	3	pet_ers
petrous	9	27	1442	3	petrou_s
petters	9	37	2236	3	petters
pours	7	46	2318	3	__pours
pretors	9	3	1681	3	preto_rs
putouts	9	3	708	3	putouts
recoups	11	8	884	3	recoups
recourse	10	3	838	3	recourse
rectors	9	35	2052	3	recto_rs
recurs	8	33	1580	3	re_curs
redouts	8	14	1166	3	redouts
repour	8	3	1099	3	repour_
retears	7	28	1492	3	retears
retools	7	34	1102	3	retools
retore	6	76	3077	3	reto_re
retorn	6	109	2343	3	reto_rn
retort	6	68	3115	3	reto_rt
retorts	7	60	1651	3	retorts
retouch	12	3	586	3	retouch
return	6	232	2252	3	ret_urn
returns	7	97	1259	3	ret_urns
rhetors	10	3	851	3	rheto_rs
rigours	8	20	700	3	rigours
rotors	6	49	1795	3	roto_rs
rumours	9	7	637	3	rumours
santours	8	3	718	3	santours
sapours	9	36	1062	3	sapours
savours	10	38	934	3	savours
scours	8	49	1359	3	_scours
sectors	9	31	1645	3	secto_rs
senors	6	36	2079	3	seno_rs
serous	6	50	2356	3	serou_s
setoffs	13	3	413	3	setoffs
setons	6	46	2017	3	seto_ns
setout	6	47	1947	3	setou_t
setters	7	38	2206	3	setters
setups	8	39	1046	3	set_ups
sours	5	52	3050	3	__sours
stoups	8	53	1327	3	_stoups
stour	5	49	1674	3	_stour_
stoure	6	48	1494	3	_stoure
stoures	7	46	1416	3	_stoures
stoury	9	52	994	3	_stoury
stouts	6	50	1900	3	_stouts
tabours	9	41	1009	3	tabours
tenors	6	32	1775	3	teno_rs
tenour	6	26	1073	3	tenour_
tethers	10	38	1531	3	tethers
tetotums	10	12	406	3	tetotums
tetters	7	43	2047	3	tetters
torrs	5	39	2356	3	__torrs
tors	4	61	5738	3	__to_rs
torus	5	43	2976	3	__torus
tour	4	55	3038	3	__tour_
touts	5	48	3039	3	__touts
tumours	9	7	675	3	tumours
tutors	6	9	1233	3	tuto_rs
valours	10	24	874	3	valours
vapours	12	27	746	3	vapours
vectors	12	32	1259	3	vecto_rs
velour	9	32	876	3	velour_
venous	9	37	1319	3	venou_s
vetoer	9	34	1006	3	vetoer_
vetoes	9	29	1408	3	veto_es
vetters	10	40	1632	3	vetters
vigours	11	28	548	3	vigours
wethers	13	52	1469	3	wethers
wetters	10	38	1775	3	wetters
yours	8	52	1788	3	__yours

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.423	422437.4
2	DLD Change Limit	134027	284	6.766	19808.9
3	Display Results	284	284	0.110	2581.8
	(SQL Overall)	178691	284	7.299	24481.6