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

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

317 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
bandogs	11	3	836	(None)
bandog	10	3	872	1	bandog_
abandons	11	4	535	2	abandons
bancos	10	47	1389	2	banco_s
bandage	11	3	1102	2	bandage
bandages	12	3	1063	2	bandages
bandas	9	51	2054	2	band_as
banders	10	43	2456	2	banders
bandies	10	41	2486	2	bandies
bandits	10	38	1479	2	bandits
bandora	10	3	881	2	bandora
bandoras	11	3	874	2	bandoras
bandore	10	6	1163	2	bandore
bandores	11	3	1160	2	bandores
bands	8	52	3343	2	band__s
bangs	8	56	2778	2	ban__gs
banjoes	16	31	731	2	banjoes
banjos	15	37	889	2	banjo_s
candors	10	42	1676	2	candors
cantdogs	12	4	404	2	cantdogs
fandoms	13	22	947	2	fandoms
gundogs	10	3	460	2	gundogs
hangdogs	14	4	360	2	hangdogs
lapdogs	11	3	407	2	lapdogs
randoms	10	21	1243	2	randoms
sandhogs	13	6	548	2	sandhogs
sundogs	9	4	710	2	sundogs
abandon	10	4	546	3	abando_n
ados	5	76	3351	3	_a_do_s
aldols	7	10	971	3	_aldols
analogs	8	28	1045	3	_analogs
andros	7	3	1330	3	_andros
ands	5	78	3362	3	_and__s
anions	6	41	2303	3	_anions
annoys	9	6	752	3	_annoys
anoas	5	72	2649	3	_an_oas
anodes	7	44	1876	3	_anodes
anyons	9	45	1350	3	_anyons
ardors	7	44	1687	3	_ardors
babools	11	31	945	3	babools
baboons	11	32	1108	3	baboons
baboos	10	35	1701	3	ba_boos
backlogs	17	4	663	3	backlogs
bacons	10	49	1758	3	ba_cons
badass	9	4	929	3	ba_dass
baddies	11	40	1787	3	baddies
badge	9	48	1969	3	ba_d_ge
badges	10	39	1737	3	ba_dges
badness	10	3	957	3	badness
bads	7	70	4887	3	ba_d__s
bagnios	10	3	607	3	bagnio_s
bags	7	66	4550	3	ba___gs
bagwigs	14	3	282	3	bagwigs
bailors	9	32	1241	3	bailors
bakings	14	43	1202	3	bakings
balboas	11	37	1007	3	balboas
baldies	10	53	1770	3	baldies
balds	8	55	2464	3	bald__s
ballons	9	39	1696	3	ballons
ballots	9	41	1603	3	ballots
bamboos	13	4	875	3	bamboos
bananas	9	33	1222	3	bananas
banco	9	40	1939	3	banco__
band	7	67	4092	3	band___
banda	8	52	2311	3	band__a
bandaged	13	3	731	3	bandaged
bandager	12	3	770	3	bandager
bandagers	13	3	588	3	bandagers
bandaid	11	3	1048	3	bandaid
bandana	10	17	946	3	bandana
bandanas	11	17	857	3	bandanas
bandbox	19	4	376	3	bandbox
bandboxes	21	4	379	3	bandboxes
bandeau	10	3	852	3	bandeau
bandeaus	11	4	650	3	bandeaus
banded	10	52	2317	3	band_ed
bander	9	39	2822	3	band_er
banderols	12	4	595	3	banderols
bandied	11	44	1430	3	bandied
banding	11	49	2141	3	banding
bandit	9	38	2113	3	band_it
bandito	10	37	1004	3	bandito
banditos	11	34	763	3	banditos
bandsaw	13	3	480	3	bandsaw
bandsaws	14	4	462	3	bandsaws
bandy	11	48	2419	3	band__y
banes	7	49	4558	3	ban__es
bang	7	48	3701	3	ban__g_
bangers	10	40	2035	3	bangers
bangkoks	14	4	184	3	bangkoks
bangles	10	36	1741	3	bangles
banians	9	3	1203	3	banians
baning	9	51	2783	3	baning_
banjo	14	38	1244	3	banjo__
banjoist	17	4	514	3	banjoist
bankers	13	39	1909	3	bankers
bankings	15	48	940	3	bankings
bankits	13	34	1015	3	bankits
banks	11	55	2790	3	ban__ks
banners	9	40	1871	3	banners
bannets	9	40	1384	3	bannets
bannock	15	4	504	3	bannock
bannocks	16	4	435	3	bannocks
banns	7	53	2123	3	ban__ns
bans	6	65	5514	3	ban___s
bantams	11	4	906	3	bantams
bantengs	11	3	459	3	bantengs
banters	9	46	2312	3	banters
banties	9	43	2476	3	banties
banyans	12	3	791	3	banyans
banzais	18	3	716	3	banzais
bardes	9	50	2693	3	bard_es
bards	8	71	3964	3	bard__s
barhops	14	28	811	3	barhops
barlows	12	25	998	3	barlows
barongs	10	53	1083	3	barongs
barons	8	50	2538	3	ba_rons
barrows	12	34	1169	3	barrows
baryons	12	10	1047	3	baryons
basions	9	42	1395	3	basions
bassos	8	53	1370	3	basso_s
batboys	14	6	583	3	batboys
bathos	11	62	1563	3	batho_s
batons	8	55	1942	3	ba_tons
baudrons	11	3	576	3	baudrons
bauds	8	58	2104	3	baud__s
bawdies	13	46	1339	3	bawdies
bawds	11	61	1549	3	bawd__s
bayous	11	4	1115	3	ba_yous
bazooms	20	28	538	3	bazooms
bazoos	17	32	1262	3	ba_zoos
beanbags	13	4	286	3	beanbags
beanos	8	55	1651	3	bean_o_s
beclogs	12	3	707	3	beclogs
befogs	12	4	645	3	b_efogs
bendays	13	32	751	3	bendays
bendees	10	39	1386	3	bendees
benders	10	40	2106	3	benders
bends	8	56	2897	3	bend__s
bendys	12	51	838	3	bend_ys
bentos	8	62	1830	3	bento_s
benzols	18	3	667	3	benzols
bhangs	12	44	966	3	bhan__gs
binders	10	39	2074	3	binders
bindings	12	38	1047	3	bindings
bindis	9	46	1458	3	bind_is
bindles	10	40	1645	3	bindles
binds	8	66	2748	3	bind__s
bingoes	10	40	1398	3	bingoes
bingos	9	55	1479	3	bingo_s
binocs	10	3	992	3	bin_ocs
biogs	8	50	1611	3	b__iogs
birddogs	13	8	243	3	birddogs
blogs	8	53	1923	3	b__logs
bogs	7	57	4275	3	b___ogs
bonbons	11	3	933	3	bonbons
bondage	11	3	825	3	bondage
bondages	12	3	789	3	bondages
bonders	10	41	2066	3	bonders
bondings	12	36	941	3	bondings
bonds	8	61	2684	3	bond__s
bonducs	12	3	555	3	bonducs
bongoes	10	43	1411	3	bongoes
bongos	9	53	1665	3	bongo_s
bongs	8	78	2842	3	bon__gs
branders	11	43	1309	3	branders
brandies	11	7	1456	3	brandies
brandings	13	27	748	3	brandings
brands	9	51	1894	3	brand__s
bulldogs	12	7	424	3	bulldogs
buncos	10	40	1159	3	bunco_s
bundles	10	35	1577	3	bundles
bunds	8	55	2354	3	bund__s
bundts	9	50	1084	3	bund_ts
bungs	8	53	2386	3	bun__gs
bunions	9	22	1047	3	bunions
bunkos	12	42	1032	3	bunko_s
candids	11	38	1269	3	candids
candies	10	41	2561	3	candies
candles	10	44	2234	3	candles
candor	9	45	1642	3	cando_r
candour	10	42	1024	3	candour
candours	11	40	864	3	candours
cannons	9	44	1288	3	cannons
canoes	8	47	2588	3	can_oes
canons	8	55	2206	3	can_ons
cansos	8	49	1538	3	canso_s
cantdog	11	3	457	3	cantdog_
cantons	9	52	2120	3	cantons
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	canto_s
canyons	12	45	1159	3	canyons
cardons	10	45	1994	3	cardons
condoes	10	43	1920	3	condoes
condoms	12	42	1408	3	condoms
condors	10	40	1857	3	condors
condos	9	43	2233	3	condo_s
coydogs	14	3	449	3	coydogs
crannogs	11	4	378	3	crannogs
dadoes	8	56	1653	3	da_does
dados	7	55	2243	3	da_do_s
danders	9	39	2118	3	danders
dandies	9	41	2144	3	dandies
dandles	9	42	1853	3	dandles
dangs	7	56	2321	3	dan__gs
danios	7	3	1460	3	danio_s
dogs	6	64	4015	3	___dogs
endows	10	46	1042	3	_endows
fados	9	56	2073	3	fa_do_s
fandom	12	21	1089	3	fando_m
fangs	9	62	2408	3	fan__gs
fanions	10	37	1307	3	fanions
fanons	9	61	1521	3	fan_ons
fanos	8	59	2650	3	fan_o_s
fantods	11	17	762	3	fantods
fantoms	12	18	915	3	fantoms
fogdogs	13	3	326	3	fogdogs
ganders	9	35	2170	3	ganders
gangs	7	62	2258	3	gan__gs
ganofs	10	40	1029	3	gan_ofs
gundog	9	3	579	3	gundog_
hagdons	12	5	852	3	hagdons
handbags	15	11	636	3	handbags
handers	11	42	2433	3	handers
handles	11	40	2065	3	handles
handoff	17	5	648	3	handoff
handoffs	18	4	473	3	handoffs
handout	11	3	1410	3	handout
handouts	12	3	823	3	handouts
hands	9	53	2738	3	hand__s
hangdog	13	4	313	3	hangdog_
hangs	9	57	2673	3	han__gs
hansoms	12	23	852	3	hansoms
hotdogs	12	3	445	3	hotdogs
incogs	9	3	790	3	_incogs
indols	7	47	1420	3	_indols
indows	10	42	1079	3	_indows
kendos	11	45	1066	3	kendo_s
landaus	8	3	1034	3	landaus
landers	8	40	2622	3	landers
landings	10	31	1007	3	landings
lands	6	54	2690	3	land__s
lanugos	8	3	445	3	lanugos
lapdog	10	3	444	3	lapdog_
lardons	8	39	1449	3	lardons
mandola	10	3	902	3	mandola
mandolas	11	3	913	3	mandolas
mangoes	10	43	1613	3	mangoes
mangos	9	43	1934	3	mango_s
maniocs	11	36	1144	3	maniocs
manors	8	44	2088	3	man_ors
manos	7	49	3362	3	man_o_s
mondos	9	52	1733	3	mondo_s
nandins	8	3	1200	3	nandins
nogs	5	65	3461	3	__n_ogs
padnags	11	3	508	3	padnags
pandas	9	55	2196	3	pand_as
panders	10	34	2374	3	panders
pandies	10	42	2450	3	pandies
pandits	10	39	1421	3	pandits
pandoor	10	35	858	3	pandoor
pandoors	11	25	898	3	pandoors
pandora	10	3	954	3	pandora
pandoras	11	3	1005	3	pandoras
pandore	10	4	1185	3	pandore
pandores	11	3	1245	3	pandores
pandour	10	40	821	3	pandour
pandours	11	31	799	3	pandours
pangs	8	46	2867	3	pan__gs
pantos	8	52	2274	3	panto_s
pardons	10	38	1762	3	pardons
quandongs	20	4	192	3	quandongs
radons	7	41	1853	3	ra_dons
rancors	9	8	1137	3	rancors
randans	8	3	1321	3	randans
randies	8	42	2566	3	randies
random	9	25	1355	3	rando_m
rands	6	59	3045	3	rand__s
ransoms	9	24	1016	3	ransoms
rondos	7	46	1673	3	rondo_s
sandals	8	27	1520	3	sandals
sandbags	12	9	637	3	sandbags
sanders	8	40	2594	3	sanders
sandhis	11	3	999	3	sandhis
sandhog	12	7	545	3	sandhog_
sandlots	9	3	829	3	sandlots
sands	6	52	2858	3	sand__s
sanious	7	5	1410	3	sanious
sannops	9	3	669	3	sannops
santols	7	35	1332	3	santols
santos	6	44	2183	3	santo_s
sawlogs	11	3	539	3	sawlogs
seadogs	9	5	864	3	seadogs
snogs	6	60	1749	3	_sn_ogs
sundog	8	3	761	3	sundog_
tandems	10	3	763	3	tandems
tandoor	8	27	856	3	tandoor
tandoors	9	25	805	3	tandoors
tangos	7	42	1632	3	tango_s
tangs	6	50	2836	3	tan__gs
tannoys	10	5	555	3	tannoys
tautogs	8	7	541	3	tautogs
tendons	8	3	1147	3	tendons
tondos	7	51	1592	3	tondo_s
undoes	7	39	1740	3	_undoes
vanadous	12	4	603	3	vanadous
vandals	11	32	1166	3	vandals
vandas	10	39	1599	3	vand_as
vangs	9	63	1960	3	van__gs
vendors	11	35	1022	3	vendors
wanders	11	42	2133	3	wanders
wands	9	64	2548	3	wand__s
wanions	10	40	1137	3	wanions
wantons	10	37	1301	3	wantons
windows	14	4	774	3	windows
yangs	9	56	1870	3	yan__gs
zanders	17	30	1579	3	zanders

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.406	440125.6
2	DLD Change Limit	134027	317	6.703	19995.1
3	Display Results	317	317	0.110	2881.8
	(SQL Overall)	178691	317	7.219	24752.9