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

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

289 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
goer	5	68	2710	(None)
doer	5	77	3470	1	doer
goers	6	55	2025	1	goers
goes	5	56	4409	1	goes
gofer	9	48	1428	1	gofer
gomer	8	52	2065	1	gomer
goner	6	60	2516	1	goner
gor	4	78	4826	1	go_r
gore	5	57	4496	1	gore
hoer	7	65	3398	1	hoer
ager	5	59	3584	2	ager
agger	7	64	2089	2	agger
aper	6	63	3623	2	aper
aver	7	59	3188	2	aver
beer	6	56	3599	2	beer
bier	6	55	3183	2	bier
boar	6	61	3429	2	boar
boner	7	51	3308	2	boner
boor	6	61	3068	2	boor
bore	6	60	5133	2	bore
borer	7	51	3127	2	borer
bower	10	73	2818	2	bower
boxer	14	50	1652	2	boxer
coder	8	61	3422	2	coder
coed	7	71	4054	2	coed
coir	6	63	2724	2	coir
comer	9	58	3269	2	comer
cooer	7	48	3101	2	cooer
coper	9	53	3609	2	coper
cor	5	99	6094	2	co_r
core	6	72	6311	2	core
corer	7	55	3887	2	corer
cover	10	54	3077	2	cover
cower	10	45	3177	2	cower
coyer	10	52	2284	2	coyer
deer	5	67	3902	2	deer
doe	4	73	6195	2	doe_
doers	6	52	2571	2	doers
does	5	65	5447	2	does
door	5	69	2851	2	door
doper	8	61	2839	2	doper
dor	4	72	5392	2	do_r
dore	5	63	5330	2	dore
dorr	5	66	2772	2	dorr
doser	6	62	2856	2	doser
doter	6	54	2862	2	doter
dour	5	63	3043	2	dour
dower	9	50	2770	2	dower
dozer	15	84	1927	2	dozer
dyer	8	55	2211	2	dyer
eger	5	59	2357	2	eger
egger	7	44	1441	2	egger
er	2	83	4514	2	__er
ever	7	70	2769	2	ever
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fer	6	66	4612	2	_fer
foe	6	63	5081	2	foe_
foes	7	65	4344	2	foes
for	6	69	5207	2	fo_r
fore	7	83	5147	2	fore
four	7	62	2686	2	four
foyer	11	64	1655	2	foyer
gae	4	64	5770	2	gae_
gaed	6	60	3151	2	gaed
gaen	5	73	2960	2	gaen
gaes	5	63	4803	2	gaes
gager	7	47	2629	2	gager
gamer	8	49	2894	2	gamer
gaoler	7	39	1357	2	gaoler
gaper	8	61	2512	2	gaper
gar	4	72	5990	2	g_ar
gater	6	45	3365	2	gater
gaur	5	67	2335	2	gaur
gayer	9	45	1919	2	gayer
gazer	15	57	2007	2	gazer
gear	5	59	3497	2	gear
ged	5	70	4453	2	g_ed
gee	4	53	5920	2	g_ee
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
gel	4	56	4243	2	g_el
gem	6	68	4022	2	g_em
gen	4	59	5051	2	g_en
germ	7	54	2896	2	g_erm
get	4	74	6746	2	g_et
gey	7	57	3830	2	g_ey
ghee	8	57	2611	2	ghee
giber	8	54	1770	2	giber
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
giver	9	49	2120	2	giver
gled	6	56	3114	2	gled
glee	5	52	3906	2	glee
gleg	6	62	1980	2	gleg
glen	5	60	2720	2	glen
gley	8	57	2465	2	gley
glover	10	45	1353	2	glover
glower	10	51	1493	2	glower
gluer	6	51	1677	2	gluer
gnar	5	60	2138	2	gnar
go	3	87	4874	2	go__
goa	4	73	4380	2	go_a
goad	6	68	3098	2	goad
goal	5	58	2930	2	goal
goas	5	52	3994	2	goas
goat	5	62	5083	2	goat
gob	6	89	5089	2	go_b
gobo	7	61	2690	2	gobo
gobs	7	69	3557	2	gobs
goby	10	60	2108	2	goby
god	5	74	4979	2	go_d
godet	7	5	3004	2	godet
gods	6	54	3804	2	gods
gofers	10	47	1151	2	gofers
goffer	13	40	951	2	goffer
gogo	6	97	2283	2	gogo
goiter	7	41	1620	2	goiter
gold	6	54	3016	2	gold
golder	8	44	1760	2	golder
golem	8	4	1611	2	golem
golf	8	57	3118	2	golf
golfer	10	44	1118	2	golfer
gomers	9	41	1688	2	gomers
gone	5	56	3904	2	gone
gonef	9	52	2129	2	gonef
goners	7	44	2017	2	goners
gong	6	68	2719	2	gong
goo	4	77	5477	2	go_o
goober	9	39	1174	2	goober
good	6	65	3180	2	good
gooey	9	55	2286	2	gooey
goof	8	54	3687	2	goof
gooier	7	35	1621	2	gooier
gook	9	64	2960	2	gook
goon	5	72	3617	2	goon
goop	7	58	2948	2	goop
goos	5	76	4491	2	goos
gopher	12	3	918	2	gopher
gored	7	52	2708	2	gored
gores	6	57	4037	2	gores
gorger	8	61	1698	2	gorger
gorier	7	37	1937	2	gorier
gorm	7	55	2939	2	gorm
gorp	7	56	2590	2	gorp
gory	8	61	2966	2	gory
gos	4	71	5513	2	go_s
gosh	8	61	2342	2	gosh
got	4	98	7044	2	go_t
goth	8	68	2508	2	goth
gouger	8	60	1436	2	gouger
gourd	7	10	1190	2	gourd
gout	5	66	4600	2	gout
govern	10	3	682	2	govern
gowd	9	65	1998	2	gowd
gowk	12	55	1647	2	gowk
gown	8	57	2407	2	gown
gox	11	71	3718	2	go_x
goxes	13	50	1826	2	goxes
goy	7	78	4455	2	go_y
goys	8	63	2841	2	goys
gree	5	66	4156	2	gree
grew	8	56	2026	2	grew
grey	8	56	2404	2	grey
grocer	9	42	1214	2	grocer
groper	9	45	1725	2	groper
grower	10	46	1493	2	grower
guar	5	69	2329	2	guar
gyre	8	47	2276	2	gyre
her	6	65	4781	2	_her
hoar	7	67	2916	2	hoar
hoe	6	75	6272	2	hoe_
hoed	8	78	3798	2	hoed
hoers	8	57	2492	2	hoers
hoes	7	57	5573	2	hoes
homer	10	58	2845	2	homer
honer	8	53	3209	2	honer
hoper	10	58	2914	2	hoper
hoser	8	115	2976	2	hoser
hour	7	58	2731	2	hour
hover	11	55	2413	2	hover
jeer	11	54	2646	2	jeer
joe	10	66	4235	2	joe_
joes	11	66	3589	2	joes
joey	14	57	1933	2	joey
joker	16	57	1589	2	joker
kier	8	65	2681	2	kier
koel	8	45	1994	2	koel
kor	7	65	3889	2	ko_r
kore	8	58	3416	2	kore
leer	4	62	3935	2	leer
lier	4	59	4246	2	lier
loner	5	54	3104	2	loner
loper	7	51	2923	2	loper
lore	4	58	5035	2	lore
loser	5	47	2867	2	loser
lour	4	54	3068	2	lour
lover	8	55	2645	2	lover
lower	8	58	3041	2	lower
moor	6	66	2855	2	moor
moper	9	49	2592	2	moper
mor	5	68	5500	2	mo_r
more	6	71	5452	2	more
mover	10	42	2086	2	mover
mower	10	45	2345	2	mower
noel	4	52	2655	2	noel
noes	4	58	4539	2	noes
noir	4	67	2243	2	noir
nor	3	80	4882	2	no_r
noter	5	50	2564	2	noter
oar	3	70	5795	2	_oar
oe	2	84	7306	2	_oe_
oes	3	58	6619	2	_oes
ogee	5	76	2988	2	ogee
ogler	6	59	1744	2	ogler
ogre	5	63	2074	2	ogre
omer	6	70	2839	2	omer
or	2	73	5473	2	_o_r
ore	3	66	6183	2	_ore
our	3	60	4289	2	_our
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
peer	6	62	3835	2	peer
per	5	63	5309	2	_per
pier	6	60	3529	2	pier
poem	8	62	2577	2	poem
poet	6	55	5290	2	poet
poker	11	51	2288	2	poker
poler	7	44	3179	2	poler
poor	6	56	3022	2	poor
pore	6	64	5126	2	pore
poser	7	51	2877	2	poser
pour	6	115	2747	2	pour
power	10	53	2595	2	power
roar	4	63	2857	2	roar
roe	3	68	6108	2	roe_
roes	4	59	5414	2	roes
roger	6	45	2141	2	roger
roper	7	54	3191	2	roper
rover	8	55	2737	2	rover
rower	8	54	3049	2	rower
ruer	4	61	2756	2	ruer
seer	4	55	4704	2	seer
ser	3	67	5240	2	_ser
shoer	8	47	2216	2	shoer
soar	4	68	3867	2	soar
sober	7	48	2241	2	sober
sore	4	70	5953	2	sore
sorer	5	62	3659	2	sorer
sour	4	59	3589	2	sour
sower	8	52	2931	2	sower
suer	4	53	3403	2	suer
tier	4	49	3614	2	tier
toe	3	101	6685	2	toe_
toea	4	67	3233	2	toea
toed	5	61	3704	2	toed
toes	4	69	5644	2	toes
toker	9	59	2491	2	toker
toner	5	53	3624	2	toner
toper	7	52	3102	2	toper
tor	3	92	6168	2	to_r
tore	4	73	5932	2	tore
torr	4	56	3090	2	torr
toter	5	59	3213	2	toter
tour	4	55	3038	2	tour
tower	8	57	2920	2	tower
toyer	8	45	2155	2	toyer
tyer	7	53	2339	2	tyer
user	4	50	2300	2	user
veer	7	62	2957	2	veer
vier	7	54	2815	2	vier
voe	6	77	3905	2	voe_
voes	7	54	3282	2	voes
vomer	10	55	1738	2	vomer
voter	8	51	2105	2	voter
vower	11	52	2079	2	vower
weer	7	55	3509	2	weer
woe	6	66	5124	2	woe_
woes	7	64	4066	2	woes
wooer	8	43	1669	2	wooer
wore	7	71	4467	2	wore
yore	7	63	3594	2	yore
your	7	86	2343	2	your
zoea	13	71	1842	2	zoea
zoner	14	45	2034	2	zoner

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	289	0.923	32364.0
3	Display Results	289	289	0.060	4816.7
	(SQL Overall)	178691	289	1.263	141481.4