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

Here are the results of your fuzzy-string dictionary search for “doodad” 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
doodad	9	3	642	(None)
doodads	10	3	509	1	doodads
aoudad	8	3	503	2	aoudad
deodand	10	3	571	2	deodand
deodar	8	3	771	2	deodar
doodle	8	32	1285	2	doodle
doodled	10	36	946	2	doodled
doodoo	8	10	889	2	doodoo
doody	10	55	1791	2	dood_y
doomed	10	41	1329	2	doomed
dorsad	8	40	897	2	dorsad
hodad	10	3	1135	2	_hodad
hooded	11	46	1674	2	hooded
wooded	11	42	1368	2	wooded
aboded	10	49	1251	3	aboded
alidad	8	3	887	3	alidad
anodal	7	25	1211	3	anodal
aoudads	9	7	375	3	aoudads
apodal	9	28	982	3	apodal
audad	7	15	1138	3	_audad
blooded	11	37	980	3	blooded
boded	9	51	2496	3	_boded
bonded	10	47	1995	3	bonded
boobed	11	45	1487	3	boobed
boodle	9	32	1503	3	boodle
boodled	11	34	1093	3	boodled
boody	11	54	2040	3	bood_y
booed	8	51	2727	3	boo_ed
booked	13	53	1950	3	booked
boomed	11	53	1813	3	boomed
booted	9	48	2273	3	booted
boozed	18	48	1383	3	boozed
broad	8	48	1769	3	bro_ad
brooded	11	35	1093	3	brooded
caudad	10	15	767	3	caudad
coda	7	70	2934	3	_coda_
codas	8	47	2424	3	_codas
codded	11	45	1530	3	codded
coded	9	54	3318	3	_coded
cohead	12	38	1112	3	cohead
colead	9	41	1464	3	colead
cooed	8	45	3434	3	coo_ed
cooeed	9	59	1786	3	cooeed
cooked	13	59	2136	3	cooked
cooled	9	52	2458	3	cooled
cooped	11	48	2160	3	cooped
corded	10	59	2335	3	corded
dad	5	84	5616	3	___dad
dada	6	64	2244	3	d_ada_
dadas	7	58	1986	3	d_adas
dadoed	9	44	989	3	dadoed
daedal	8	4	908	3	daedal
dead	6	54	3424	3	d__ead
decoded	12	32	1238	3	decoded
dedal	7	57	1902	3	d_edal
deeded	9	46	1554	3	deeded
delead	8	41	1234	3	delead
demoded	12	36	1112	3	demoded
deodands	11	4	460	3	deodands
deodara	9	4	524	3	deodara
deodars	9	3	762	3	deodars
dhoora	10	3	565	3	dhoora_
dhooras	11	3	594	3	dhooras
diode	7	47	1611	3	diod_e
diodes	8	39	1578	3	diodes
dioxan	14	6	577	3	dioxan
dioxid	15	6	839	3	dioxid
doat	5	69	4767	3	d_o_at
doated	8	41	1818	3	doated
dobla	8	49	1364	3	dobla_
doblas	9	38	1229	3	doblas
dobra	8	50	1310	3	dobra_
dobras	9	48	1191	3	dobras
docked	14	50	1833	3	docked
dodder	9	47	1291	3	dodder
dodge	8	66	1812	3	d_odge
dodged	10	75	1468	3	dodged
dodgy	11	66	1146	3	d_odgy
dodo	6	60	2491	3	d_od_o
dodoes	8	57	1610	3	dodoes
dodos	7	58	1939	3	d_odos
doffed	14	42	850	3	doffed
dogdom	11	8	636	3	dogdom
dogear	8	3	819	3	dogear
dogged	10	60	1770	3	dogged
dogma	9	61	1246	3	dogma_
dogmas	10	50	1124	3	dogmas
dognap	10	3	534	3	dognap
doiled	8	48	1729	3	doiled
doited	8	50	1663	3	doited
doled	7	54	3091	3	d_oled
dollar	7	41	1098	3	dollar
dolled	8	35	1807	3	dolled
dolma	8	62	1417	3	dolma_
dolman	9	53	1240	3	dolman
dolmas	9	52	1304	3	dolmas
domal	8	56	1920	3	d_omal
domed	9	54	2326	3	d_omed
dona	5	55	2963	3	d_ona_
donas	6	59	2647	3	d_onas
donga	7	67	1842	3	donga_
dongas	8	49	1461	3	dongas
donna	6	62	1503	3	donna_
donnas	7	55	1132	3	donnas
donned	8	50	1574	3	donned
doobie	9	47	1268	3	doobie
doodies	9	42	1877	3	doodies
doodler	9	33	1015	3	doodler
doodles	9	36	1416	3	doodles
doodoos	9	10	762	3	doodoos
doofus	10	3	616	3	doofus
doolee	7	30	1895	3	doolee
doolie	7	39	1683	3	doolie
dooly	9	48	2180	3	doo_ly
doom	7	64	3007	3	doo__m
dooms	8	53	2134	3	doo_ms
doomsday	15	4	200	3	doomsday
doomy	11	60	1826	3	doo_my
door	5	69	2851	3	doo__r
doorman	10	3	706	3	doorman
doormat	10	5	907	3	doormat
doors	6	50	2213	3	doo_rs
doorway	14	4	424	3	doorway
dooryard	13	4	337	3	dooryard
doowop	12	8	385	3	doowop
doozer	16	39	1046	3	doozer
doozie	16	39	1064	3	doozie
doozy	18	68	1371	3	doo_zy
dopa	7	72	2090	3	d_opa_
dopas	8	50	1906	3	d_opas
doped	9	53	2671	3	d_oped
dorado	8	3	881	3	dorado
dorsa	6	46	1728	3	dorsa_
dorsal	7	46	1394	3	dorsal
dosed	7	66	2691	3	d_osed
dossal	7	55	1030	3	dossal
dossed	8	45	1663	3	dossed
dotal	6	49	1962	3	d_otal
dotard	8	3	905	3	dotard
doted	7	52	2707	3	d_oted
dotted	8	47	1752	3	dotted
doula	6	57	1777	3	doula_
doulas	7	51	1499	3	doulas
douma	8	58	1770	3	douma_
doumas	9	53	1481	3	doumas
doura	6	65	1866	3	doura_
dourah	10	47	981	3	dourah
douras	7	50	1672	3	douras
doused	8	48	2116	3	doused
dowdy	13	61	1254	3	dowd_y
dowed	10	46	3261	3	d_owed
downed	11	53	1478	3	downed
dowsed	11	50	1501	3	dowsed
dozed	16	56	1935	3	d_ozed
dread	7	44	1902	3	d_read
droid	7	42	1853	3	dro_id
droned	8	46	1686	3	droned
drooled	9	36	920	3	drooled
drooped	11	36	843	3	drooped
droved	11	46	1164	3	droved
drownd	11	47	831	3	drownd
dryad	10	47	758	3	d_ryad
duad	6	65	2141	3	d__uad
duded	8	44	1713	3	d_uded
dyad	9	64	1545	3	d__yad
eroded	8	43	1358	3	eroded
flooded	12	30	793	3	flooded
folded	11	42	1279	3	folded
fonded	11	57	1704	3	fonded
food	8	68	3057	3	foo__d
foodie	10	44	1384	3	foodie
foods	9	59	2416	3	food_s
fooled	10	43	1782	3	fooled
footed	10	44	1862	3	footed
footpad	13	4	390	3	footpad
forbad	12	27	1050	3	forbad
forded	11	50	2039	3	forded
fordid	11	35	1205	3	fordid
goad	6	68	3098	3	_go_ad
goaded	9	49	1371	3	goaded
goddam	11	4	516	3	goddam
godded	10	48	1180	3	godded
gonad	7	52	1605	3	_gonad
good	6	65	3180	3	goo__d
goodby	13	40	628	3	goodby
goodie	8	36	1399	3	goodie
goodly	11	41	930	3	goodly
goodman	11	3	593	3	goodman
goods	7	51	2448	3	good_s
goody	10	56	2039	3	good_y
goofed	11	49	1138	3	goofed
gooral	7	3	1046	3	gooral
goosed	8	68	1703	3	goosed
hodads	11	4	796	3	_hodads
honda	9	4	1498	3	honda_
hondas	10	3	1335	3	hondas
hood	8	51	3233	3	hoo__d
hoodie	10	51	1613	3	hoodie
hoodoo	10	10	998	3	hoodoo
hoods	9	51	2408	3	hood_s
hoody	12	49	1972	3	hood_y
hoofed	13	46	1489	3	hoofed
hooka	12	55	1390	3	hooka_
hookah	16	48	824	3	hookah
hookas	13	53	1249	3	hookas
hooked	14	53	2055	3	hooked
hooped	12	55	1818	3	hooped
hoorah	12	44	1111	3	hoorah
hooray	12	30	1137	3	hooray
hooted	10	44	2265	3	hooted
hooved	13	47	1312	3	hooved
horded	11	54	2048	3	horded
houdah	13	3	517	3	houdah
howdah	16	3	472	3	howdah
iodid	7	43	1552	3	_iodid
ixodid	15	21	576	3	ixodid
jordan	14	6	806	3	jordan
koodoo	11	10	777	3	koodoo
load	5	67	3060	3	_lo_ad
loaded	8	46	1687	3	loaded
loided	8	34	1402	3	loided
looed	6	46	2613	3	loo_ed
loofa	8	59	1281	3	loofa_
loofah	12	37	581	3	loofah
loofas	9	42	983	3	loofas
looked	11	47	1707	3	looked
loomed	9	46	1676	3	loomed
looped	9	52	1717	3	looped
loosed	7	55	2089	3	loosed
looted	7	44	2111	3	looted
lorded	8	49	1673	3	lorded
modal	8	59	1923	3	_modal
molded	10	44	1408	3	molded
monad	8	55	1947	3	_monad
mood	7	63	3206	3	moo__d
moods	8	52	2462	3	mood_s
moody	11	50	1749	3	mood_y
mooed	8	51	2398	3	moo_ed
moola	7	51	1703	3	moola_
moolah	11	40	919	3	moolah
moolas	8	36	1559	3	moolas
mooned	9	42	1664	3	mooned
moored	9	38	1417	3	moored
mooted	9	41	2037	3	mooted
nodal	6	47	1779	3	_nodal
nodded	9	40	1212	3	nodded
nomad	8	60	1618	3	_nomad
noodge	8	33	757	3	noodge
noodged	10	29	592	3	noodged
noodle	7	32	1254	3	noodle
noodled	9	33	992	3	noodled
noonday	11	4	460	3	noonday
noosed	7	50	1801	3	noosed
octad	8	15	1065	3	_octad
oda	4	81	3304	3	__oda_
odah	8	70	1893	3	__odah
odas	5	72	3026	3	__odas
odd	5	77	2545	3	__od_d
odored	8	39	922	3	odored
ogdoad	9	4	351	3	_ogdoad
oohed	9	42	1421	3	_oohed
ootid	6	14	1669	3	_ootid
oozed	15	42	1426	3	_oozed
orad	5	60	3169	3	__orad
oread	6	46	1960	3	_oread
podded	11	50	1271	3	podded
ponded	10	52	1877	3	ponded
pood	7	59	3432	3	poo__d
poodle	9	31	1204	3	poodle
poods	8	51	2475	3	pood_s
pooed	8	52	2624	3	poo_ed
poohed	12	39	1252	3	poohed
pooled	9	46	1981	3	pooled
pooped	11	39	1594	3	pooped
road	5	63	3211	3	_ro_ad
rodded	9	37	1370	3	rodded
rood	5	67	3300	3	roo__d
roods	6	51	2528	3	rood_s
roofed	10	52	1474	3	roofed
rooked	11	49	1814	3	rooked
roomed	9	52	1854	3	roomed
roosed	7	56	2159	3	roosed
rooted	7	54	2400	3	rooted
snooded	9	41	1036	3	snooded
soda	5	63	2938	3	_soda_
sodas	6	41	2354	3	_sodas
sodded	9	41	1330	3	sodded
soldan	7	35	1185	3	soldan
sooted	7	39	2258	3	sooted
sordid	8	34	1115	3	sordid
soudan	7	32	1035	3	soudan
toad	5	58	3018	3	_to_ad
today	9	64	1695	3	_today
tooled	7	49	1890	3	tooled
tooted	7	46	2012	3	tooted
voided	11	40	1113	3	voided
voodoo	10	12	753	3	voodoo
woad	8	55	2394	3	_wo_ad
woaded	11	52	1160	3	woaded
wood	8	53	2938	3	woo__d
wooden	10	36	1030	3	wooden
woodie	10	35	1361	3	woodie
woodland	13	4	460	3	woodland
woodman	13	3	631	3	woodman
woods	9	57	2303	3	wood_s
woodsy	13	50	592	3	woodsy
woodwax	21	4	347	3	woodwax
woody	12	51	1688	3	wood_y
wooed	9	44	1987	3	woo_ed
woofed	13	45	1120	3	woofed
wooled	10	37	1550	3	wooled
worded	11	43	1662	3	worded
zooid	15	3	1210	3	zoo_id
zooidal	17	4	508	3	zooidal
zoomed	18	36	1036	3	zoomed
zoonal	15	5	808	3	zoonal
zooned	16	40	1108	3	zooned

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.140	1276364.3
2	DLD Change Limit	112716	317	8.063	13979.4
3	Display Results	317	317	0.203	1561.6
	(SQL Overall)	178691	317	8.406	21257.6