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

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

335 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
drogue	8	93	833	(None)
brogue	9	42	1103	1	brogue
drogues	9	39	839	1	drogues
rogue	6	64	1753	1	_rogue
argue	6	48	1844	2	ar_gue
brogues	10	71	982	2	brogues
dengue	8	3	825	2	dengue
doge	6	62	3380	2	d_og_e
dogie	7	52	2279	2	d_ogie
dragee	8	44	1560	2	dragee
drone	6	53	2498	2	dro_ne
drouk	10	3	943	2	dro_uk
drove	9	55	1806	2	dro_ve
drowse	10	50	1055	2	drowse
morgue	9	3	811	2	morgue
pirogue	10	4	541	2	pirogue
progun	9	6	878	2	progun
rogued	8	47	1147	2	_rogued
rogues	7	46	1767	2	_rogues
roque	14	48	1213	2	_roque
roue	4	59	4174	2	_ro_ue
rouge	6	54	2344	2	_rouge
togue	6	48	1630	2	_togue
vogue	9	56	1304	2	_vogue
ague	5	57	2592	3	__ague
apogee	9	3	1255	3	apogee
argle	6	54	2156	3	ar_gle
argued	8	43	1117	3	ar_gued
arguer	7	45	1054	3	ar_guer
argues	7	45	1641	3	ar_gues
argus	6	67	1654	3	ar_gus
arose	5	58	3208	3	aro_se
arouse	6	50	1998	3	arouse
baroque	18	3	510	3	baroque
bogie	8	95	2410	3	_bogie
bogle	8	58	2168	3	_bogle
bogus	8	56	1647	3	_bogus
boogie	9	35	1599	3	boogie
broche	13	36	1210	3	broche
brogan	9	3	1104	3	brogan
broguery	14	4	331	3	broguery
broke	11	60	1978	3	bro_ke
brome	9	44	2197	3	bro_me
bronze	17	36	1092	3	bronze
brose	7	52	2703	3	bro_se
browse	11	57	1385	3	browse
cangue	9	10	1244	3	cangue
cloque	17	28	874	3	cloque
crocus	10	48	1317	3	crocus
crone	7	52	3133	3	cro_ne
croquet	18	5	968	3	croquet
crore	7	49	2286	3	cro_re
crosse	8	52	1630	3	crosse
croup	9	56	1678	3	cro_up
croupe	10	51	1443	3	croupe
crouse	8	46	1936	3	crouse
croute	8	46	1727	3	croute
croze	16	47	1945	3	cro_ze
dadgum	11	3	458	3	dadgum
daggle	9	37	1190	3	daggle
dangle	8	41	1930	3	dangle
degum	9	47	1190	3	d_egum
deluge	8	18	940	3	deluge
dengues	9	3	818	3	dengues
derogate	10	3	1135	3	derogate
dhole	9	52	1536	3	dho_le
dialogue	10	4	479	3	dialogue
dinge	7	56	2730	3	ding_e
dingle	8	43	1707	3	dingle
dingus	8	36	1184	3	dingus
diode	7	47	1611	3	dio_de
dirge	7	51	1707	3	dirg_e
dobie	8	49	2033	3	d_obie
dodge	8	66	1812	3	d_odge
doe	4	73	6195	3	d_o__e
dog	5	74	4975	3	d_og__
doges	7	56	3016	3	d_oges
dogey	10	57	1951	3	d_ogey
dogged	10	60	1770	3	d_ogged
dogger	9	52	1678	3	d_ogger
doggie	9	39	1089	3	doggie
doggo	8	44	1070	3	d_oggo
doggy	11	52	1487	3	d_oggy
dogies	8	50	2225	3	d_ogies
dogleg	9	3	632	3	d_ogleg
dogma	9	61	1246	3	d_ogma
dogs	6	64	4015	3	d_og_s
dogy	9	61	2649	3	d_og_y
dolce	8	58	1668	3	d_olce
dole	5	65	5000	3	d_o_le
dome	7	72	4073	3	d_o_me
done	5	57	4791	3	d_o_ne
donee	6	69	3101	3	d_onee
dongle	8	36	1249	3	dongle
donne	6	55	2046	3	d_onne
donut	6	3	2451	3	d_onut
doobie	9	47	1268	3	doobie
doodle	8	32	1285	3	doodle
doofus	10	3	616	3	doofus
doolee	7	30	1895	3	doolee
doolie	7	39	1683	3	doolie
doozie	16	39	1064	3	doozie
dope	7	60	3889	3	d_o_pe
dorbug	10	3	495	3	dorbug
dore	5	63	5330	3	d_o_re
dormie	9	3	1262	3	dormie
dorsum	9	4	762	3	dorsum
dose	5	64	4243	3	d_o_se
dote	5	54	4288	3	d_o_te
douce	8	55	1842	3	d_ouce
dough	10	52	1738	3	d_ough
doum	7	62	2667	3	d_o_um
dour	5	63	3043	3	d_o_ur
douse	6	63	2972	3	d_ouse
doux	12	58	1798	3	d_o_ux
dove	8	51	3156	3	d_o_ve
dowie	9	47	2114	3	d_owie
dowse	9	60	2081	3	d_owse
doxie	13	60	1715	3	d_oxie
doze	14	58	2908	3	d_o_ze
drag	6	48	2505	3	drag__
dragees	9	35	948	3	dragees
dragged	11	37	956	3	dragged
dragger	10	30	917	3	dragger
draggle	10	5	610	3	draggle
draggy	12	34	682	3	draggy
dragnet	9	12	1143	3	dragnet
dragon	8	3	884	3	dragon
drags	7	55	2111	3	drag_s
drake	10	49	1830	3	dr_ake
drape	8	53	1963	3	dr_ape
drave	9	52	1927	3	dr_ave
drawee	10	44	1382	3	drawee
dredge	9	30	855	3	dredge
dree	5	66	3832	3	dr__ee
dreg	6	68	2165	3	dreg__
dreggy	12	36	463	3	dreggy
dregs	7	61	1486	3	dreg_s
drive	9	53	1800	3	dr_ive
droid	7	42	1853	3	dro_id
droids	8	47	1258	3	droids
droit	6	51	2712	3	dro_it
droits	7	43	1431	3	droits
droll	6	54	1540	3	dro_ll
drolled	9	38	1022	3	drolled
droller	8	41	1028	3	droller
drolls	7	53	1239	3	drolls
drolly	10	54	1167	3	drolly
dromon	9	3	936	3	dromon
droned	8	46	1686	3	droned
droner	7	47	1767	3	droner
drones	7	50	2343	3	drones
drongo	8	3	679	3	drongo
drongos	9	3	549	3	drongos
drool	6	54	1610	3	dro_ol
drooled	9	36	920	3	drooled
drools	7	44	1281	3	drools
drooly	10	49	1107	3	drooly
droop	8	58	1482	3	dro_op
drooped	11	36	843	3	drooped
droops	9	51	1096	3	droops
droopy	12	45	824	3	droopy
drop	7	53	2440	3	dro__p
droplet	10	3	1211	3	droplet
dropout	10	4	1000	3	dropout
dropped	13	32	928	3	dropped
dropper	12	32	987	3	dropper
drops	8	57	1950	3	dro_ps
dropsy	12	49	747	3	dropsy
dropt	8	69	2443	3	dro_pt
drosky	14	48	616	3	drosky
dross	6	54	1809	3	dro_ss
drosses	8	45	1382	3	drosses
drossy	10	52	847	3	drossy
drought	12	25	887	3	drought
drouked	13	3	554	3	drouked
drouks	11	3	712	3	drouks
drouth	10	44	1010	3	drouth
droved	11	46	1164	3	droved
drover	10	46	1459	3	drover
droves	10	51	1667	3	droves
drown	9	55	1582	3	dro_wn
drownd	11	47	831	3	drownd
drowned	12	41	990	3	drowned
drowner	11	36	980	3	drowner
drowns	10	56	1233	3	drowns
drowsed	12	44	874	3	drowsed
drowses	11	46	1023	3	drowses
drowsy	13	48	790	3	drowsy
drub	7	59	2013	3	dr__ub
drudge	9	31	790	3	drudge
drug	6	57	1813	3	dr__ug
drugged	11	36	717	3	drugged
drugget	10	33	761	3	drugget
druggie	10	13	407	3	druggie
druggy	12	34	474	3	druggy
drugs	7	52	1465	3	drug_s
drum	7	65	2159	3	dr__um
drupe	8	50	1299	3	dr_upe
druse	6	48	1766	3	dr_use
due	4	52	4986	3	d___ue
dugout	8	3	1036	3	dugout
duologue	10	4	300	3	duologue
eclogue	10	4	450	3	eclogue
erode	6	45	2099	3	ero_de
erose	5	57	2727	3	ero_se
fogie	9	67	1900	3	_fogie
forge	9	51	2694	3	forg_e
froe	7	53	2999	3	fro__e
frog	8	56	2436	3	frog__
frogeye	14	4	381	3	frogeye
frogged	13	40	849	3	frogged
froggy	14	3	449	3	froggy
froglet	11	3	1006	3	froglet
frogmen	13	3	589	3	frogmen
frogs	9	62	2077	3	frog_s
frore	8	62	1880	3	fro_re
froze	17	45	1565	3	fro_ze
fugue	9	43	1337	3	_fugue
gangue	8	13	1057	3	gangue
garigue	9	3	558	3	garigue
gigue	7	12	1067	3	_gigue
gorge	7	64	2389	3	gorg_e
gouge	7	82	2006	3	_gouge
grog	6	59	2334	3	grog__
groggy	12	3	480	3	groggy
grogs	7	63	1941	3	grog_s
groove	10	43	887	3	groove
grope	8	48	2161	3	gro_pe
grosze	16	45	773	3	grosze
group	8	54	1392	3	gro_up
grouse	7	43	1502	3	grouse
grout	6	53	3042	3	gro_ut
grove	9	52	1933	3	gro_ve
groyne	10	3	721	3	groyne
grue	5	58	2571	3	gr__ue
irone	5	51	2636	3	iro_ne
krone	9	40	1873	3	kro_ne
kronur	10	41	531	3	kronur
langue	7	10	1217	3	langue
league	7	5	874	3	league
loge	5	68	3719	3	_log_e
mogul	8	3	1021	3	_mogul
morgues	10	3	827	3	morgues
moue	6	58	3557	3	_mo_ue
noogie	7	36	1231	3	noogie
ogee	5	76	2988	3	__ogee
ogle	5	63	2505	3	__ogle
ogre	5	63	2074	3	__ogre
orgone	7	11	1091	3	orgone
oroide	7	3	1170	3	oroide
pirogues	11	3	547	3	pirogues
piroque	18	4	435	3	piroque
plague	9	36	1085	3	plague
prevue	11	7	916	3	prevue
probe	9	43	2081	3	pro_be
procure	11	3	857	3	procure
produce	12	6	751	3	produce
profuse	12	3	715	3	profuse
prog	7	57	2900	3	prog__
progged	12	40	979	3	progged
progger	11	31	937	3	progger
progs	8	66	2415	3	prog_s
prole	7	45	2779	3	pro_le
prologue	11	4	683	3	prologue
prone	7	53	3262	3	pro_ne
prorogue	11	4	524	3	prorogue
prose	7	58	3512	3	pro_se
proud	8	46	1548	3	pro_ud
prove	10	48	2319	3	pro_ve
rage	5	57	4235	3	_rag_e
ragee	6	54	3266	3	_ragee
reglue	7	3	970	3	_reglue
revue	8	11	1445	3	_revue
robe	6	53	3564	3	_ro_be
roble	7	52	2302	3	_roble
rode	5	58	4430	3	_ro_de
roe	3	68	6107	3	_ro__e
roger	6	45	2141	3	_roger
roguery	11	3	489	3	_roguery
role	4	58	5182	3	_ro_le
roose	5	61	2709	3	_roose
rope	6	55	4291	3	_ro_pe
roques	15	49	1256	3	_roques
roquet	15	44	1589	3	_roquet
rose	4	61	4890	3	_ro_se
rote	4	62	4902	3	_ro_te
rotgut	7	3	879	3	_rotgut
rotte	5	46	2593	3	_rotte
rouen	5	49	2090	3	_ro_uen
roues	5	60	3935	3	_ro_ues
rouged	8	67	1732	3	_rouged
rouges	7	60	2238	3	_rouges
rough	9	78	1943	3	_rough
roup	6	66	2769	3	_ro_up
rouse	5	66	3470	3	_rouse
rout	4	61	5328	3	_ro_ut
route	5	51	3207	3	_route
roux	11	74	1936	3	_ro_ux
rove	7	51	3698	3	_ro_ve
rue	3	55	4926	3	_r__ue
rugae	6	51	1476	3	_rugae
scrouge	10	3	635	3	scrouge
segue	6	3	1441	3	_segue
shogun	10	4	570	3	shogun
stogie	7	3	1131	3	stogie
togae	6	70	2011	3	_togae
togues	7	60	1424	3	_togues
tongue	7	4	1009	3	tongue
toque	14	51	1309	3	_toque
torque	15	23	767	3	torque
tragus	7	4	922	3	tragus
troche	11	31	1251	3	troche
trode	6	53	2285	3	tro_de
trog	5	76	2821	3	trog__
trogon	7	36	1175	3	trogon
trogs	6	70	2260	3	trog_s
troke	9	48	2105	3	tro_ke
trompe	10	56	1126	3	trompe
trone	5	51	3186	3	tro_ne
trope	7	57	2580	3	tro_pe
trough	10	85	1202	3	trough
troupe	8	48	1243	3	troupe
trout	5	73	3257	3	tro_ut
trove	8	52	2192	3	tro_ve
true	4	67	2585	3	tr__ue
urge	5	47	2241	3	ur_g_e
vague	9	65	1311	3	_vague
vogie	9	51	1666	3	_vogie
vogued	11	45	763	3	_vogued
voguer	10	46	840	3	_voguer
vogues	10	40	1192	3	_vogues
vrouw	11	50	734	3	vro_uw
wrote	8	47	1748	3	wro_te
yogee	9	5	1806	3	_yogee

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.140	1276364.3
2	DLD Change Limit	112716	335	5.923	19030.2
3	Display Results	335	335	0.110	3045.5
	(SQL Overall)	178691	335	6.173	28947.2