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

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

465 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
dogear	8	3	819	(None)
dogears	9	3	751	1	dogears
dear	5	53	4360	2	d__ear
dodger	9	58	1705	2	dodge_r
doer	5	77	3470	2	do_e_r
dogcart	11	4	804	2	dogcart
doge	6	62	3380	2	doge__
dogeared	11	4	579	2	dogeared
doges	7	56	3016	2	doge_s
dogey	10	57	1951	2	doge_y
dogeys	11	55	1066	2	dogeys
dogger	9	52	1678	2	dogger
dogma	9	61	1246	2	dogma_
dogmas	10	50	1124	2	dogmas
dognap	10	3	534	2	dognap
dollar	7	41	1098	2	dollar
doper	8	61	2839	2	dope_r
doser	6	62	2856	2	dose_r
doter	6	54	2862	2	dote_r
dower	9	50	2770	2	dowe_r
dozer	15	84	1927	2	doze_r
drear	6	50	1690	2	d_rear
gear	5	59	3497	2	__gear
regear	7	35	1274	2	regear
roger	6	45	2141	2	roge_r
adorer	7	47	1345	3	adore_r
agar	5	87	2641	3	_ag_ar
ager	5	59	3584	3	_age_r
agger	7	64	2089	3	agge_r
alegar	7	3	928	3	alegar
anear	5	54	2032	3	_anear
anger	6	62	2588	3	ange_r
apogeal	10	4	562	3	apogeal
apogean	10	4	544	3	apogean
appear	10	37	934	3	appear
arrear	6	3	1025	3	arrear
auger	6	49	2247	3	auge_r
bear	6	68	4464	3	__bear
beggar	10	32	822	3	beggar
blear	7	59	1868	3	_blear
boar	6	61	3429	3	bo__ar
bogan	8	75	1900	3	bog_an
bogart	9	6	1719	3	bog_art
bogbean	12	4	464	3	bogbean
bogey	11	52	2023	3	boge_y
bogeys	12	45	1091	3	bogeys
bohea	10	50	1373	3	bohea_
boheas	11	40	1321	3	boheas
bolar	7	51	2347	3	bo_lar
boner	7	51	3308	3	bone_r
booger	9	48	1655	3	booge_r
boreal	8	48	1721	3	boreal
boreas	8	54	2174	3	boreas
borer	7	51	3127	3	bore_r
bower	10	73	2818	3	bowe_r
boxcar	17	3	475	3	boxcar
boxer	14	50	1652	3	boxe_r
boyar	10	60	1376	3	bo_yar
bugbear	12	3	395	3	bugbear
cager	8	52	2922	3	cage_r
cigar	8	9	1180	3	cig_ar
clear	7	62	1905	3	_clear
coder	8	61	3422	3	code_r
codger	10	58	1487	3	codge_r
cogent	9	3	2100	3	cogent
cognac	11	5	727	3	cognac
cogway	15	6	618	3	cogway
cohead	12	38	1112	3	cohead
coheir	11	3	758	3	coheir
colead	9	41	1464	3	colead
collar	8	38	1617	3	collar
comer	9	58	3269	3	come_r
congeal	10	40	1168	3	congeal
conger	9	50	2427	3	conge_r
cooer	7	48	3101	3	cooe_r
coper	9	53	3609	3	cope_r
corer	7	55	3887	3	core_r
costar	8	55	1861	3	costar
coteau	8	3	1108	3	coteau
cottar	8	46	1381	3	cottar
cougar	9	5	878	3	cougar
cover	10	54	3077	3	cove_r
cower	10	45	3177	3	cowe_r
coyer	10	52	2284	3	coye_r
dagga	8	3	954	3	dagga_
daggas	9	3	797	3	daggas
dagger	9	50	1730	3	dagger
damar	8	41	1775	3	d_amar
dammar	11	43	891	3	dammar
danger	8	37	2283	3	dange_r
darbar	9	5	996	3	darbar
darer	6	52	3079	3	dare_r
dater	6	53	3231	3	date_r
dead	6	54	3424	3	d__ead
deaf	8	58	3840	3	d__eaf
deair	6	58	1719	3	d__eair
deal	5	63	4741	3	d__eal
dean	5	60	3948	3	d__ean
dears	6	57	3688	3	d__ears
deary	9	58	2684	3	d__eary
debar	8	55	1786	3	d_ebar
debeak	13	3	676	3	debeak
debeard	11	3	735	3	debeard
deer	5	67	3902	3	d__eer
defeat	10	38	1716	3	defeat
defer	9	46	1975	3	defe_r
degas	7	51	1916	3	deg_as
degerm	10	3	789	3	degerm
delead	8	41	1234	3	delead
demean	9	5	1056	3	demean
denar	6	52	2329	3	d_enar
deodar	8	3	771	3	deodar
deter	6	50	2804	3	dete_r
dewar	9	58	1773	3	d_ewar
dicer	8	54	2642	3	dice_r
digest	8	40	1962	3	digest
digger	9	46	1608	3	digger
diker	10	55	2455	3	dike_r
dimer	8	56	2560	3	dime_r
dinar	6	63	1989	3	d_inar
diner	6	56	3290	3	dine_r
dinger	8	53	2367	3	dinge_r
direr	6	49	2707	3	dire_r
disbar	9	3	851	3	disbar
diseur	7	3	884	3	diseur
diver	9	48	2780	3	dive_r
doat	5	69	4767	3	do__at
dobber	11	40	1542	3	dobber
dobla	8	49	1364	3	dobla_
doblas	9	38	1229	3	doblas
dobra	8	50	1310	3	dobra_
dobras	9	48	1191	3	dobras
docent	9	29	1868	3	docent
docker	13	44	1765	3	docker
doctor	9	3	899	3	doctor
dodder	9	47	1291	3	dodder
dodge	8	66	1813	3	dodge__
dodged	10	75	1469	3	dodge_d
dodgem	11	67	1004	3	dodge_m
dodgems	12	57	644	3	dodgems
dodgers	10	52	1382	3	dodgers
dodgery	13	62	778	3	dodgery
dodges	9	61	1908	3	dodge_s
dodgier	10	38	824	3	dodgier
doe	4	73	6195	3	do_e__
doers	6	52	2571	3	do_ers
does	5	65	5447	3	do_e_s
doest	6	58	2952	3	do_est
doeth	9	4	1198	3	do_eth
doffer	13	39	1135	3	doffer
dog	5	74	4975	3	dog___
dogbane	11	3	565	3	dogbane
dogberry	15	4	286	3	dogberry
dogcarts	12	4	388	3	dogcarts
dogdom	11	8	636	3	dogdom
dogearing	12	3	576	3	dogear~~ing~~
dogedom	12	4	466	3	dogedom
dogface	14	5	405	3	dogface
dogged	10	60	1770	3	dogged
doggers	10	44	1343	3	doggers
doggery	13	44	826	3	doggery
doggie	9	39	1089	3	doggie
doggier	10	38	1094	3	doggier
doggo	8	44	1070	3	dog_go
doggy	11	52	1487	3	dog_gy
dogie	7	52	2279	3	dog_ie
dogies	8	50	2225	3	dogies
dogleg	9	3	632	3	dogleg
doglegs	10	3	478	3	doglegs
dogmata	11	4	514	3	dogmata
dognaper	12	4	369	3	dognaper
dognaps	11	3	439	3	dognaps
dogs	6	64	4015	3	dog__s
dogvane	12	4	385	3	dogvane
dogy	9	61	2649	3	dog__y
dole	5	65	5000	3	dole__
doled	7	54	3091	3	dole_d
doles	6	78	4375	3	dole_s
dollars	8	33	1102	3	dollars
dolma	8	62	1417	3	dolma_
dolman	9	53	1240	3	dolman
dolmas	9	52	1304	3	dolmas
dolor	6	76	1796	3	do_lor
dolour	7	57	1013	3	dolour
domal	8	56	1920	3	do_mal
dome	7	72	4073	3	dome__
domed	9	54	2326	3	dome_d
domes	8	57	3556	3	dome_s
dona	5	55	2963	3	do_na_
donas	6	59	2647	3	do_nas
done	5	57	4791	3	done__
donee	6	69	3101	3	done_e
donees	7	45	1949	3	donees
donga	7	67	1842	3	donga_
dongas	8	49	1461	3	dongas
donna	6	62	1503	3	donna_
donnas	7	55	1132	3	donnas
donor	6	44	1819	3	do_nor
doodad	9	3	642	3	doodad
door	5	69	2851	3	do__or
doozer	16	39	1046	3	doozer
dopa	7	72	2090	3	do_pa_
dopas	8	50	1906	3	do_pas
dope	7	60	3889	3	dope__
doped	9	53	2671	3	dope_d
dopers	9	55	2248	3	dopers
dopes	8	49	3504	3	dope_s
dopey	11	60	2035	3	dope_y
dopier	9	35	1592	3	dopier
dor	4	72	5392	3	do___r
dore	5	63	5330	3	dore__
dormer	9	44	1590	3	dormer
dorper	9	43	1457	3	dorper
dorr	5	66	2772	3	do__rr
dorsa	6	46	1728	3	dorsa_
dorsad	8	40	897	3	dorsad
dorsal	7	46	1394	3	dorsal
dorser	7	48	1918	3	dorser
dose	5	64	4243	3	dose__
dosed	7	66	2691	3	dose_d
dosers	7	57	2363	3	dosers
doses	6	59	3850	3	dose_s
dossal	7	55	1030	3	dossal
dosser	7	44	1797	3	dosser
dotal	6	49	1962	3	do_tal
dotard	8	3	905	3	do_tard
dote	5	54	4288	3	dote__
doted	7	52	2707	3	dote_d
doters	7	44	2391	3	doters
dotes	6	58	3669	3	dote_s
dotier	7	39	1703	3	dotier
dotter	7	44	1934	3	dotter
douceur	10	4	311	3	douceur
doula	6	57	1777	3	doula_
doulas	7	51	1499	3	doulas
douma	8	58	1770	3	douma_
doumas	9	53	1481	3	doumas
dour	5	63	3043	3	do__ur
doura	6	65	1866	3	doura_
dourah	10	47	981	3	dourah
douras	7	50	1672	3	douras
dourer	7	42	1527	3	dourer
douser	7	56	2163	3	douser
dove	8	51	3156	3	dove__
doven	9	47	1855	3	dove_n
dovens	10	44	1390	3	dovens
doves	9	47	2815	3	dove_s
dowager	12	4	580	3	dowage_r
dowed	10	46	3261	3	dowe_d
dowel	9	56	1819	3	dowe_l
dowels	10	48	1334	3	dowels
dowers	10	45	2329	3	dowers
dowery	13	43	1166	3	dowery
downer	10	44	1492	3	downer
dowser	10	47	1608	3	dowser
doyen	9	50	1441	3	doye_n
doyens	10	48	1022	3	doyens
doze	14	58	2908	3	doze__
dozed	16	56	1935	3	doze_d
dozen	15	50	1747	3	doze_n
dozens	16	46	1246	3	dozens
dozers	16	48	1542	3	dozers
dozes	15	52	2630	3	doze_s
dozier	16	36	1163	3	dozier
dread	7	44	1902	3	d_read
dream	8	51	2039	3	d_ream
drears	7	46	1425	3	d_rears
dreary	10	46	1167	3	d_reary
drier	6	44	2396	3	drie_r
droner	7	47	1767	3	drone_r
drosera	8	3	620	3	drosera
drover	10	46	1459	3	drove_r
dryer	9	51	1146	3	drye_r
duper	8	55	1900	3	dupe_r
durbar	9	6	872	3	durbar
dyer	8	55	2211	3	d_ye_r
eager	6	55	2697	3	eage_r
ear	3	68	6788	3	___ear
edger	7	52	1595	3	edge_r
eger	5	59	2357	3	_ege_r
eggar	7	45	888	3	_eggar
egger	7	44	1441	3	egge_r
endear	7	41	1001	3	endear
fear	7	53	3779	3	__fear
fogey	12	56	1787	3	foge_y
fogeys	13	50	926	3	fogeys
fogger	11	44	1478	3	fogger
foliar	9	32	1097	3	foliar
footgear	12	11	306	3	footgear
forbear	12	3	752	3	forbear
forearm	12	3	870	3	forearm
forger	10	48	2077	3	forge_r
fovea	11	3	1048	3	fovea_
foveae	12	3	756	3	foveae
foveal	12	3	770	3	foveal
foveas	12	3	862	3	foveas
foyer	11	64	1655	3	foye_r
gager	7	47	2629	3	gage_r
gar	4	72	5990	3	__g_ar
gears	6	46	2869	3	__gears
gnar	5	60	2138	3	__gnar
goer	5	68	2710	3	go_e_r
gofer	9	48	1428	3	gofe_r
gomer	8	52	2065	3	gome_r
goner	6	60	2516	3	gone_r
gorger	8	61	1698	3	gorge_r
gouger	8	60	1436	3	gouge_r
guar	5	69	2329	3	__guar
hear	7	61	4388	3	__hear
hoar	7	67	2916	3	ho__ar
hoer	7	65	3398	3	ho_e_r
hogan	9	78	1770	3	hog_an
hogger	11	46	1508	3	hogger
homer	10	58	2845	3	home_r
honer	8	53	3209	3	hone_r
hoper	10	58	2914	3	hope_r
hoser	8	115	2976	3	hose_r
hover	11	55	2413	3	hove_r
huger	9	49	1487	3	huge_r
jager	13	43	1813	3	jage_r
jaguar	14	3	528	3	jaguar
jogger	15	47	1316	3	jogger
joker	16	57	1589	3	joke_r
jowar	15	52	1143	3	jo_war
lager	6	51	3286	3	lage_r
lear	4	70	4595	3	__lear
leger	6	57	2151	3	lege_r
liger	6	50	2447	3	lige_r
linear	6	51	1334	3	linear
lobar	7	3	1301	3	lo_bar
lodger	8	65	1769	3	lodge_r
logan	6	81	2328	3	log_an
loge	5	68	3719	3	loge__
loges	6	65	3420	3	loge_s
logger	8	64	2000	3	logger
logia	6	81	1660	3	logia_
logier	7	50	1573	3	logier
logjam	16	3	536	3	logjam
logway	13	3	591	3	logway
loner	5	54	3104	3	lone_r
longer	7	58	2320	3	longe_r
loper	7	51	2923	3	lope_r
loreal	6	38	1431	3	loreal
loser	5	47	2867	3	lose_r
lover	8	55	2645	3	love_r
lower	8	58	3041	3	lowe_r
luger	6	53	2208	3	luge_r
molar	7	52	2309	3	mo_lar
monger	9	44	1833	3	monge_r
moper	9	49	2592	3	mope_r
mortar	8	38	1204	3	mortar
mover	10	42	2086	3	move_r
mower	10	45	2345	3	mowe_r
muggar	10	31	644	3	muggar
near	4	52	3650	3	__near
nonpar	8	16	899	3	nonpar
nonwar	9	15	942	3	nonwar
noter	5	50	2564	3	note_r
oar	3	70	5795	3	_o__ar
obeah	10	3	899	3	_obeah
ocean	7	12	1296	3	_ocean
odder	7	45	1539	3	odde_r
odea	5	62	2457	3	_odea_
ogam	7	51	2003	3	_og_am
ogee	5	76	2988	3	_oge_e
ogees	6	51	1914	3	_ogees
ogham	11	3	825	3	_ogham
ogler	6	59	1744	3	_ogler
olea	4	65	3272	3	_olea_
omer	6	70	2839	3	_ome_r
oogeny	10	11	792	3	oogeny
opera	7	3	1357	3	_opera
oread	6	46	1960	3	_oread
orgeat	7	5	1503	3	orgeat
osar	4	68	2095	3	_o_sar
ottar	5	43	1399	3	_ottar
over	7	72	2734	3	_ove_r
oyer	7	59	2765	3	_oye_r
pager	8	47	2820	3	page_r
pear	6	97	4523	3	__pear
pogey	11	60	1789	3	poge_y
pogeys	12	41	1035	3	pogeys
poker	11	51	2288	3	poke_r
polar	7	56	2345	3	po_lar
poleax	15	4	799	3	poleax
poler	7	44	3179	3	pole_r
poplar	10	36	1111	3	poplar
poser	7	51	2877	3	pose_r
poseur	8	41	940	3	poseur
power	10	53	2595	3	powe_r
rear	4	56	4455	3	__rear
redear	7	35	1517	3	redear
regears	8	30	1246	3	regears
rehear	9	37	1322	3	rehear
retear	6	31	1548	3	retear
rewear	9	30	1200	3	rewear
roar	4	63	2857	3	ro__ar
rogers	7	45	1791	3	rogers
roper	7	54	3191	3	rope_r
rover	8	55	2737	3	rove_r
rower	8	54	3049	3	rowe_r
sager	6	54	3205	3	sage_r
saggar	8	40	1085	3	saggar
sear	4	73	5384	3	__sear
seggar	8	35	781	3	seggar
shear	8	54	2483	3	_shear
shmear	11	7	693	3	shmear
smear	7	44	1639	3	_smear
soar	4	68	3867	3	so__ar
sober	7	48	2241	3	sobe_r
sofar	8	61	1549	3	so_far
solar	5	59	2734	3	so_lar
sonar	5	65	2342	3	so_nar
sorer	5	62	3659	3	sore_r
soucar	8	3	932	3	soucar
sowar	8	58	2134	3	so_war
sowcar	11	3	586	3	sowcar
sower	8	52	2931	3	sowe_r
spear	7	58	2106	3	_spear
sugar	6	3	1291	3	sug_ar
swear	8	53	1685	3	_swear
tear	4	52	4288	3	__tear
tiger	6	57	1863	3	tige_r
toea	4	67	3233	3	to_ea_
toeas	5	57	2642	3	to_eas
toga	5	70	2741	3	tog_a_
togae	6	70	2011	3	tog_ae
togaed	8	47	1134	3	togaed
togas	6	78	2300	3	tog_as
toker	9	59	2491	3	toke_r
tolar	5	55	2411	3	to_lar
tonearm	9	3	744	3	tonearm
toner	5	53	3624	3	tone_r
tonger	7	47	1969	3	tonge_r
toper	7	52	3102	3	tope_r
toter	5	59	3213	3	tote_r
tower	8	57	2920	3	towe_r
toyer	8	45	2155	3	toye_r
unbear	8	8	916	3	unbear
upbear	10	9	649	3	upbear
uprear	8	16	879	3	uprear
uptear	8	9	678	3	uptear
urger	6	41	1647	3	urge_r
voguer	10	46	840	3	voguer
volar	8	69	1741	3	vo_lar
vomer	10	55	1738	3	vome_r
voter	8	51	2105	3	vote_r
vower	11	52	2079	3	vowe_r
voyeur	12	3	286	3	voyeur
wager	9	59	2506	3	wage_r
wear	7	58	3672	3	__wear
womera	11	13	759	3	womera
wooer	8	43	1669	3	wooe_r
wormgear	14	4	188	3	wormgear
yager	9	56	1675	3	yage_r
year	7	65	3425	3	__year
yoga	8	74	1805	3	yog_a_
yogas	9	66	1560	3	yog_as
yogee	9	5	1806	3	yoge_e
yogees	10	5	1063	3	yogees
zoea	13	71	1842	3	zo_ea_
zoeae	14	44	1248	3	zo_eae
zoeal	14	48	1378	3	zo_eal
zoeas	14	58	1561	3	zo_eas
zoner	14	45	2034	3	zone_r

Search took 9 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.750	238254.7
2	DLD Change Limit	112716	465	7.346	15343.9
3	Display Results	465	465	0.140	3321.4
	(SQL Overall)	178691	465	8.236	21696.3