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

Here are the results of your fuzzy-string dictionary search for “pood” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

274 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
pood	7	59	3432	(None)
food	8	68	3057	1	food
good	6	65	3180	1	good
hood	8	51	3233	1	hood
mood	7	63	3206	1	mood
plod	7	67	2327	1	plod
pod	6	63	5148	1	p_od
pond	7	55	3049	1	pond
poo	5	77	5711	1	poo_
poods	8	51	2475	1	poods
pooed	8	52	2624	1	pooed
poof	9	55	4166	1	poof
pooh	9	60	2738	1	pooh
pool	6	58	3595	1	pool
poon	6	73	4126	1	poon
poop	8	65	3281	1	poop
poor	6	56	3022	1	poor
poos	6	59	4911	1	poos
prod	7	61	2950	1	prod
rood	5	67	3300	1	rood
wood	8	53	2938	1	wood
apod	7	81	2318	2	apod
blood	8	53	1952	2	blood
bod	6	70	5554	2	_bod
bold	7	54	3281	2	bold
bond	7	53	3436	2	bond
boo	5	81	6366	2	boo_
boob	8	59	3258	2	boob
boody	11	54	2040	2	boody
booed	8	51	2727	2	booed
book	10	68	3633	2	book
boom	8	74	3567	2	boom
boon	6	71	4217	2	boon
boor	6	61	3068	2	boor
boos	6	79	5503	2	boos
boot	6	77	5937	2	boot
brood	8	46	2024	2	brood
clod	7	61	2461	2	clod
cod	6	96	6012	2	_cod
coed	7	71	4054	2	coed
cold	7	73	3877	2	cold
coo	5	95	6636	2	coo_
cooed	8	45	3434	2	cooed
coof	9	66	4327	2	coof
cook	10	72	3693	2	cook
cool	6	69	4049	2	cool
coon	6	72	4894	2	coon
coop	8	72	3865	2	coop
coos	6	74	5649	2	coos
coot	6	78	6038	2	coot
cord	7	67	4092	2	cord
dodo	6	60	2491	2	dodo
doody	10	55	1791	2	doody
doom	7	64	3007	2	doom
door	5	69	2851	2	door
ephod	11	3	912	2	ephod
feod	8	155	2300	2	feod
flood	9	52	1560	2	flood
fold	8	65	2894	2	fold
fond	8	63	3095	2	fond
foods	9	59	2416	2	foods
fool	7	53	3059	2	fool
foot	7	62	4801	2	foot
ford	8	68	3549	2	ford
goad	6	68	3098	2	goad
god	5	74	4979	2	_god
gold	6	54	3016	2	gold
goo	4	77	5477	2	goo_
goods	7	51	2448	2	goods
goody	10	56	2039	2	goody
goof	8	54	3687	2	goof
gook	9	64	2960	2	gook
goon	5	72	3617	2	goon
goop	7	58	2948	2	goop
goos	5	76	4491	2	goos
gowd	9	65	1998	2	gowd
hod	7	68	5246	2	_hod
hoed	8	78	3798	2	hoed
hold	8	62	3506	2	hold
hoods	9	51	2408	2	hoods
hoody	12	49	1972	2	hoody
hoof	10	60	3658	2	hoof
hook	11	61	3328	2	hook
hoop	9	61	2998	2	hoop
hoot	7	57	5210	2	hoot
kook	7	58	2260	2	kook
load	5	67	3060	2	load
loid	5	55	3149	2	loid
loo	3	83	5982	2	loo_
looed	6	46	2613	2	looed
loof	7	81	4105	2	loof
look	8	73	3347	2	look
loom	6	70	3505	2	loom
loon	4	73	4479	2	loon
loop	6	78	3501	2	loop
loos	4	90	5112	2	loos
loot	4	69	5582	2	loot
lord	5	50	3208	2	lord
loud	5	52	2804	2	loud
mod	6	90	5440	2	_mod
mold	7	60	3433	2	mold
moo	5	84	6051	2	moo_
moods	8	52	2462	2	moods
moody	11	50	1749	2	moody
mooed	8	51	2398	2	mooed
mool	6	75	3386	2	mool
moon	6	71	4081	2	moon
moor	6	66	2855	2	moor
moos	6	60	5130	2	moos
moot	6	76	5362	2	moot
nod	4	75	4956	2	_nod
noo	3	71	5404	2	noo_
nook	8	57	2849	2	nook
noon	4	71	3462	2	noon
od	3	92	5524	2	__od
odd	5	77	2545	2	_odd
old	4	70	3346	2	_old
ooh	6	76	3709	2	_ooh
oot	3	112	7469	2	_oot
oped	7	62	3015	2	oped
oud	4	74	3907	2	_oud
pad	6	80	5732	2	p_ad
pagod	9	50	1368	2	pagod
paid	7	57	3748	2	paid
pard	7	64	4132	2	pard
ped	6	67	5152	2	p_ed
peed	7	62	3918	2	peed
pend	7	59	3453	2	pend
peon	6	56	3524	2	peon
phon	9	59	2538	2	phon
phot	9	55	3436	2	phot
pied	7	50	3536	2	pied
pion	6	72	3529	2	pion
pled	7	52	3143	2	pled
plods	8	57	1929	2	plods
plop	8	66	2574	2	plop
plot	6	61	4123	2	plot
plow	9	59	2323	2	plow
ploy	9	61	2360	2	ploy
poboy	12	16	1222	2	poboy
pock	12	61	2929	2	pock
poco	8	68	2615	2	poco
pods	7	65	4015	2	pods
poem	8	62	2577	2	poem
poet	6	55	5290	2	poet
pogy	10	56	2355	2	pogy
poh	8	67	4053	2	p_oh
poi	5	72	4466	2	p_oi
poind	8	42	1791	2	poind
pois	6	65	3904	2	pois
poke	10	53	3536	2	poke
poked	12	54	2539	2	poked
poky	13	59	2215	2	poky
pol	5	64	4938	2	p_ol
pole	6	59	5130	2	pole
poled	8	49	3484	2	poled
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
polos	7	61	2991	2	polos
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pom	7	82	4991	2	p_om
pome	8	56	3669	2	pome
pomo	8	58	2845	2	pomo
pomos	9	53	2158	2	pomos
pomp	10	62	2546	2	pomp
poms	8	70	3774	2	poms
ponds	8	53	2340	2	ponds
pone	6	57	4753	2	pone
pong	7	62	3114	2	pong
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
pooch	12	48	1530	2	pooch
poodle	9	31	1204	2	poodle
poofs	10	52	2279	2	poofs
poofy	13	62	1327	2	poofy
poohed	12	39	1252	2	poohed
poohs	10	39	1571	2	poohs
pooled	9	46	1981	2	pooled
pools	7	44	2770	2	pools
poons	7	54	3097	2	poons
pooped	11	39	1594	2	pooped
poops	9	44	2241	2	poops
poori	7	48	1623	2	poori
poove	10	45	1430	2	poove
pop	7	62	5225	2	p_op
pope	8	55	3561	2	pope
pops	8	63	4095	2	pops
pore	6	64	5126	2	pore
pored	8	52	3451	2	pored
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
port	6	60	5963	2	port
pose	6	64	4173	2	pose
posed	8	58	2841	2	posed
posh	9	54	2732	2	posh
post	6	79	5336	2	post
posy	9	60	2842	2	posy
pot	5	80	7843	2	p_ot
pots	6	64	5236	2	pots
pouf	9	57	3264	2	pouf
pound	8	44	1786	2	pound
pour	6	115	2747	2	pour
pout	6	57	5255	2	pout
pow	8	71	4728	2	p_ow
pows	9	55	3766	2	pows
pox	12	61	4069	2	p_ox
poxed	15	48	1786	2	poxed
poxy	16	68	2089	2	poxy
poyou	10	26	1152	2	poyou
pro	5	58	3726	2	pro_
proa	6	62	2996	2	proa
prods	8	55	2355	2	prods
prof	9	61	3466	2	prof
prog	7	57	2900	2	prog
prom	8	76	3170	2	prom
proof	10	52	2153	2	proof
prop	8	59	3281	2	prop
pros	6	57	4278	2	pros
proud	8	46	1548	2	proud
prow	9	70	3038	2	prow
pud	6	58	3665	2	p_ud
pyoid	11	5	1376	2	pyoid
quod	14	54	1362	2	quod
road	5	63	3211	2	road
rod	4	79	5389	2	_rod
roods	6	51	2528	2	roods
roof	7	57	3883	2	roof
rook	8	55	3203	2	rook
room	6	62	3508	2	room
root	4	56	5592	2	root
shod	8	62	2506	2	shod
snood	6	46	1616	2	snood
sod	4	60	5370	2	_sod
sold	5	48	3741	2	sold
sook	8	49	3339	2	sook
soon	4	62	4050	2	soon
soot	4	57	6106	2	soot
sord	5	62	3720	2	sord
spoof	10	50	1901	2	spoof
spook	11	54	1604	2	spook
spool	7	52	1904	2	spool
spoon	7	47	1944	2	spoon
spoor	7	50	1635	2	spoor
stood	6	55	1771	2	stood
toad	5	58	3018	2	toad
tod	4	94	5707	2	_tod
toed	5	61	3704	2	toed
told	5	61	3220	2	told
too	3	89	6542	2	too_
took	8	65	3107	2	took
tool	4	67	3568	2	tool
toom	6	65	3293	2	toom
toon	4	77	4063	2	toon
toot	4	59	5888	2	toot
trod	5	76	2795	2	trod
void	8	62	2056	2	void
woad	8	55	2394	2	woad
wold	8	54	2907	2	wold
woo	6	69	4980	2	woo_
woods	9	57	2303	2	woods
woody	12	51	1688	2	woody
wooed	9	44	1987	2	wooed
woof	10	65	3242	2	woof
wool	7	64	2737	2	wool
woos	7	62	3880	2	woos
word	8	98	3200	2	word
yod	7	75	4550	2	_yod
yond	8	61	2231	2	yond
zoo	12	62	3891	2	zoo_
zooid	15	3	1210	2	zooid
zoom	15	67	2210	2	zoom
zoon	13	73	2698	2	zoon
zoos	13	58	2880	2	zoos

Search took 2 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	29872	0.280	638182.1
2	DLD Change Limit	29872	274	0.843	35435.3
3	Display Results	274	274	0.063	4349.2
	(SQL Overall)	178691	274	1.186	150666.9