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

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

298 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
seadog	8	3	874	(None)
seadogs	9	5	864	1	seadogs
meadow	12	3	740	2	meadow
seabag	9	3	847	2	seabag
season	6	27	1490	2	season
seldom	9	3	941	2	seldom
shadow	13	3	725	2	shadow
spado	8	37	1370	2	spado_
sundog	8	3	761	2	sundog
ado	4	91	4688	3	__ado_
ados	5	76	3351	3	__ados
agog	6	80	1900	3	__agog
amadou	9	7	761	3	amadou
analog	7	15	997	3	analog
bandog	10	3	872	3	bandog
beacon	10	5	1137	3	beacon
bead	7	59	3792	3	bead__
beaded	10	49	2242	3	beaded
beader	9	46	2379	3	beader
beading	11	32	2186	3	beading
beadle	9	33	1468	3	beadle
beads	8	54	2950	3	bead_s
beady	11	47	1992	3	bead_y
beano	7	54	2155	3	beano_
beanos	8	55	1651	3	beanos
beclog	11	3	686	3	beclog
befog	11	5	901	3	be_fog
celadon	10	3	691	3	celadon
chador	12	3	867	3	chador
coydog	13	3	513	3	coydog
dado	6	71	2634	3	_dado_
dados	7	55	2243	3	_dados
deacon	9	5	1042	3	deacon
dead	6	54	3424	3	dead__
deaden	8	37	1432	3	deaden
deader	8	42	2047	3	deader
deadly	11	38	1147	3	deadly
deads	7	57	2691	3	dead_s
decalog	11	3	600	3	decalog
defog	10	4	852	3	de_fog
demagog	12	4	385	3	demagog
dialog	8	3	797	3	dialog
dog	5	74	4975	3	___dog
eddo	6	34	1181	3	_eddo_
eidos	6	58	1776	3	_eidos
endow	9	45	1098	3	_endow
fado	8	72	2647	3	_fado_
fados	9	56	2073	3	_fados
fogdog	12	3	422	3	fogdog
gundog	9	3	579	3	gundog
head	8	71	3717	3	head__
headed	11	40	2047	3	headed
header	10	44	2254	3	header
heading	12	29	1911	3	heading
headlong	13	3	412	3	headlong
heads	9	51	2711	3	head_s
heady	12	51	1726	3	head_y
hemagog	14	4	407	3	hemagog
hotdog	11	3	480	3	hotdog
kendo	10	51	1323	3	kendo_
kendos	11	45	1066	3	kendos
lapdog	10	3	444	3	lapdog
lead	5	60	3885	3	lead__
leaded	8	42	2154	3	leaded
leaden	7	45	1522	3	leaden
leader	7	48	2465	3	leader
leading	9	34	1955	3	leading
leadoff	14	4	390	3	leadoff
leads	6	60	2849	3	lead_s
leady	9	56	1860	3	lead_y
mead	7	55	3160	3	mead__
meadows	13	3	733	3	meadows
meadowy	16	4	404	3	meadowy
meads	8	54	2532	3	mead_s
overdog	12	10	652	3	overdog
peag	7	54	3134	3	pea__g
pedagog	12	11	376	3	pedagog
pseudo	9	3	471	3	pseudo_
pseudos	10	4	483	3	pseudos
quahog	19	4	410	3	quahog
radon	6	46	2050	3	_radon
read	5	59	4253	3	read__
readd	7	46	1713	3	read_d
readds	8	41	1164	3	readds
reader	7	36	2829	3	reader
reading	9	33	2721	3	reading
readopt	10	4	1084	3	readopt
readorn	8	3	1048	3	readorn
readout	8	6	1551	3	readout
reads	6	48	3527	3	read_s
ready	9	48	2150	3	read_y
reason	6	26	1633	3	reason
reavow	12	3	572	3	reavow
redo	5	60	2937	3	re_do_
redon	6	54	2488	3	re_don
redos	6	51	2676	3	re_dos
redox	13	47	1423	3	re_dox
sabot	7	9	3178	3	s_abot
sad	4	74	5921	3	s_ad__
sade	5	55	4448	3	s_ad_e
sades	6	52	3989	3	s_ades
sadhe	9	48	1513	3	s_adhe
sadhu	9	45	996	3	s_adhu
sadi	5	58	3465	3	s_ad_i
sadis	6	49	3085	3	s_adis
sadly	9	45	1912	3	s_adly
sag	4	61	6340	3	s_a__g
sago	5	63	3267	3	s_ago_
sagos	6	61	2387	3	s_agos
sajou	12	3	1169	3	s_ajou
salol	5	52	2214	3	s_alol
salon	5	52	2855	3	s_alon
sandhog	12	7	545	3	sandhog
sang	5	54	4124	3	s_a_ng
sapor	7	51	1925	3	s_apor
sargo	6	54	2441	3	s_argo
sarod	6	53	2587	3	s_arod
sarong	7	39	1487	3	s_arong
saros	5	52	3806	3	s_aros
savor	8	54	1794	3	s_avor
savoy	11	47	1388	3	s_avoy
sawlog	10	3	579	3	sawlog
scad	7	57	2577	3	scad__
scads	8	54	1996	3	scad_s
scag	7	66	2689	3	sca__g
scudo	8	54	1221	3	scudo_
sea	3	61	6129	3	sea___
seabags	10	3	748	3	seabags
seabed	9	50	1769	3	seabed
seaboot	9	5	1233	3	seaboot
seacock	15	4	557	3	seacock
seadrome	11	4	652	3	seadrome
seafood	11	4	615	3	seafood
seafowl	13	4	391	3	seafowl
seagoing	10	3	819	3	seagoing
seal	4	56	5437	3	sea__l
sealed	7	43	2836	3	sealed
sealer	6	39	2896	3	sealer
sealing	8	35	2856	3	sealing
seals	5	48	3970	3	sea_ls
seam	6	66	4597	3	sea__m
seaman	8	40	1590	3	seaman
seamed	9	48	2388	3	seamed
seamen	8	45	1856	3	seamen
seamer	8	42	2361	3	seamer
seaming	10	32	2211	3	seaming
seams	7	57	3166	3	sea_ms
seamy	10	59	2127	3	sea_my
seance	8	37	1669	3	seance
seaport	9	3	1560	3	seaport
sear	4	73	5384	3	sea__r
search	11	33	1242	3	search
seared	7	52	3284	3	seared
searer	6	54	3202	3	searer
searing	8	33	3092	3	searing
sears	5	47	4491	3	sea_rs
seas	4	57	5527	3	sea__s
seasons	7	26	1423	3	seasons
seat	4	75	7556	3	sea__t
seated	7	51	3106	3	seated
seater	6	45	3416	3	seater
seating	8	41	3068	3	seating
seats	5	48	4434	3	sea_ts
seawan	9	41	1122	3	seawan
seaway	12	30	999	3	seaway
secco	9	3	1242	3	secco_
seccos	10	3	992	3	seccos
sector	8	34	1593	3	sector
sedan	6	56	2042	3	se_dan
sedans	7	48	1609	3	sedans
sedate	7	30	1981	3	sedate
seder	6	48	2676	3	se_der
sedge	7	50	1997	3	se_dge
sedgy	10	45	1279	3	se_dgy
sedum	8	41	1557	3	se_dum
seed	5	55	4948	3	seed__
seeded	8	45	2046	3	seeded
seeder	7	43	2077	3	seeder
seeding	9	37	1948	3	seeding
seedpod	11	4	401	3	seedpod
seeds	6	43	3006	3	seed_s
seedy	9	48	2153	3	seed_y
seeing	7	42	2214	3	seeing
seg	4	55	4488	3	se___g
segno	6	48	1474	3	segno_
segnos	7	36	1044	3	segnos
sego	5	65	2518	3	se_go_
segos	6	49	1948	3	se_gos
seidel	7	3	1108	3	seidel
seisor	6	37	1234	3	seisor
seizor	15	42	853	3	seizor
seladang	10	4	340	3	seladang
selfdom	13	4	373	3	selfdom
semilog	10	4	600	3	semilog
senator	7	3	1307	3	senator
send	5	52	3729	3	send__
sendal	7	33	1499	3	sendal
sended	8	51	2123	3	sended
sender	7	38	2441	3	sender
sending	9	42	2137	3	sending
sendoff	14	4	623	3	sendoff
sends	6	55	2824	3	send_s
sendup	9	10	634	3	sendup
senhor	9	30	1081	3	senhor
senior	6	32	1405	3	senior
senor	5	38	2280	3	se_nor
sensor	6	38	1384	3	sensor
sepoy	10	3	1430	3	se_poy
serdab	9	3	783	3	serdab
serfdom	13	4	421	3	serfdom
sering	7	47	3181	3	sering
sermon	8	4	1355	3	sermon
serow	8	67	2044	3	se_row
servo	8	45	1668	3	servo_
servos	9	38	1272	3	servos
seton	5	52	2354	3	se_ton
sewing	10	38	1962	3	sewing
sexing	14	43	1389	3	sexing
sexpot	15	3	954	3	sexpot
sexto	12	44	1545	3	sexto_
sexton	13	36	1079	3	sexton
sextos	13	40	1216	3	sextos
shad	8	62	3091	3	shad__
shade	9	51	2558	3	shad_e
shaded	11	45	1887	3	shaded
shader	10	42	1876	3	shader
shades	10	59	2453	3	shades
shading	12	31	1556	3	shading
shadoof	14	4	613	3	shadoof
shadows	14	3	719	3	shadows
shadowy	17	4	472	3	shadowy
shads	9	51	2448	3	shad_s
shaduf	13	3	706	3	shaduf
shady	12	54	1651	3	shad_y
shag	8	64	3056	3	sha__g
shahdom	16	4	397	3	shahdom
shako	12	55	1609	3	shako_
shakos	13	49	1219	3	shakos
shalom	11	8	1092	3	shalom
shamos	11	42	1698	3	shamos
shamoy	14	37	991	3	shamoy
sheepdog	15	4	236	3	sheepdog
shog	8	60	2514	3	s__hog
skag	9	63	2151	3	ska__g
skatol	10	3	572	3	skatol
skidoo	11	3	610	3	skidoo
slag	5	59	3435	3	sla__g
slalom	8	8	817	3	slalom
slang	6	63	2402	3	sla_ng
sleazo	15	25	752	3	sleazo_
slog	5	67	2827	3	s__log
smog	7	63	1741	3	s__mog
snag	5	58	2787	3	sna__g
snog	5	56	2363	3	s__nog
sodom	8	8	1491	3	s_odom
soldo	6	71	1656	3	soldo_
sordor	7	3	1022	3	sordor
spade	8	44	2332	3	spad_e
spaded	10	38	1675	3	spaded
spader	9	43	1713	3	spader
spades	9	42	2258	3	spades
spading	11	31	1438	3	spading
spadix	16	3	611	3	spadix
spang	8	49	1973	3	spa_ng
speedo	9	40	1199	3	speedo_
speedos	10	29	826	3	speedos
sradha	10	8	533	3	sradha
stade	6	48	2530	3	stad_e
stades	7	46	2624	3	stades
stadia	7	3	1214	3	stadia
stag	5	73	3200	3	sta__g
staig	6	55	1964	3	sta_ig
stalag	7	3	1002	3	stalag
stang	6	64	2469	3	sta_ng
stanol	6	3	1072	3	stanol
stardom	10	3	776	3	stardom
stator	6	40	1548	3	stator
stead	6	55	2027	3	stead__
steaded	9	28	1167	3	steaded
steading	10	36	1359	3	steading
steads	7	41	1622	3	stead_s
steady	10	35	1020	3	stead_y
sudor	6	3	1262	3	s_udor
sundogs	9	4	710	3	sundogs
swag	8	75	2673	3	swa__g
swang	9	55	1972	3	swa_ng
synagog	12	4	362	3	synagog
teabox	15	3	601	3	teabox
teapot	8	4	1676	3	teapot
teapoy	11	3	811	3	teapoy
tendon	7	3	1203	3	tendon
vendor	10	35	980	3	vendor
weakon	13	35	762	3	weakon
weapon	11	28	811	3	weapon
weason	9	32	1082	3	weason
weblog	12	3	422	3	weblog
weldor	10	31	765	3	weldor
zealot	15	3	1347	3	zealot

Search took 6 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.373	479064.3
2	DLD Change Limit	112716	298	5.376	20966.5
3	Display Results	298	298	0.093	3204.3
	(SQL Overall)	178691	298	5.842	30587.3