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

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

421 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
bids	7	58	3843	(None)
aids	5	78	4635	1	aids
bads	7	70	4886	1	bads
beds	7	59	3778	1	beds
bias	6	47	3816	1	bias
bibs	8	48	3099	1	bibs
bid	6	77	5179	1	bid_
bide	7	60	4148	1	bide
bides	8	55	3677	1	bides
bidi	7	82	2657	1	bidi
bidis	8	67	2114	1	bidis
bigs	7	62	3502	1	bigs
binds	8	66	2747	1	binds
bins	6	65	4825	1	bins
bios	6	63	3532	1	bios
birds	8	54	2133	1	birds
bis	5	68	6066	1	bi_s
bits	6	61	4816	1	bits
bods	7	62	4471	1	bods
buds	7	52	3517	1	buds
fids	8	70	3473	1	fids
gids	6	59	3373	1	gids
ids	4	75	3546	1	_ids
kids	9	60	2963	1	kids
lids	5	63	3645	1	lids
mids	7	65	4178	1	mids
rids	5	65	3954	1	rids
vids	8	56	2753	1	vids
yids	8	52	2495	1	yids
abide	8	62	2371	2	abide
abides	9	47	1989	2	abides
acids	8	71	2100	2	acids
adds	6	76	2245	2	adds
ads	4	97	5573	2	_ads
aid	4	92	6907	2	aid_
aide	5	60	4499	2	aide
aides	6	53	3660	2	aides
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	ai_s
aits	4	63	5553	2	aits
amids	8	56	2751	2	amids
ands	5	78	3361	2	ands
baas	6	68	4467	2	baas
bad	6	77	6315	2	bad_
bade	7	51	4088	2	bade
bags	7	66	4550	2	bags
bails	7	59	3352	2	bails
baits	7	66	3058	2	baits
balds	8	55	2464	2	balds
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bands	8	52	3342	2	bands
bans	6	65	5514	2	bans
baps	8	60	4084	2	baps
bards	8	71	3964	2	bards
bars	6	65	6409	2	bars
bas	5	86	8175	2	b_as
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bauds	8	58	2104	2	bauds
bawds	11	61	1549	2	bawds
bays	9	71	4391	2	bays
beads	8	54	2950	2	beads
bed	6	79	5062	2	bed_
bedu	7	59	2369	2	bedu
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bends	8	56	2897	2	bends
bens	6	59	4570	2	bens
bes	5	65	5743	2	b_es
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bi	4	80	4647	2	bi__
bib	7	70	4594	2	bi_b
bibb	7	58	1921	2	bibb
bibbs	8	49	1158	2	bibbs
bice	8	62	3556	2	bice
bices	9	50	2996	2	bices
biddy	12	46	1269	2	biddy
bided	9	54	2496	2	bided
bider	8	57	2837	2	bider
biders	9	48	2280	2	biders
bidet	8	49	3562	2	bidet
bidets	9	52	1553	2	bidets
bields	9	41	1000	2	bields
bier	6	55	3183	2	bier
biers	7	62	2522	2	biers
biff	12	50	2689	2	biff
biffs	13	48	1441	2	biffs
big	6	73	4572	2	bi_g
bigos	8	50	2001	2	bigos
bike	10	65	3260	2	bike
bikes	11	75	2947	2	bikes
bile	6	61	4718	2	bile
biles	7	55	4214	2	biles
bilk	10	58	2442	2	bilk
bilks	11	51	1789	2	bilks
bill	6	72	3994	2	bill
bills	7	56	3286	2	bills
bima	8	67	2383	2	bima
bimas	9	55	2174	2	bimas
bin	5	66	5864	2	bi_n
bind	7	62	3451	2	bind
bindi	8	56	1701	2	bindi
bindis	9	46	1458	2	bindis
bine	6	66	5086	2	bine
bines	7	69	4679	2	bines
bint	6	73	5504	2	bint
bints	7	61	3018	2	bints
bio	5	78	4608	2	bi_o
biog	7	61	2232	2	biog
biogs	8	50	1611	2	biogs
bipeds	11	45	805	2	bipeds
bipods	11	40	859	2	bipods
bird	7	61	2832	2	bird
birk	10	63	2686	2	birk
birks	11	49	2030	2	birks
birl	6	58	3047	2	birl
birls	7	40	2316	2	birls
biro	6	61	3121	2	biro
biros	7	53	2513	2	biros
birr	6	60	2236	2	birr
birrs	7	49	1710	2	birrs
birse	7	45	1740	2	birse
bise	6	64	3710	2	bise
bises	7	54	3562	2	bises
bisk	10	65	2335	2	bisk
bisks	11	54	1680	2	bisks
bit	5	70	7090	2	bi_t
bite	6	65	4700	2	bite
bites	7	56	4117	2	bites
bitsy	10	45	1130	2	bitsy
bitt	6	55	4581	2	bitt
bitts	7	50	2259	2	bitts
biz	14	79	3936	2	bi_z
bize	15	59	2629	2	bize
bizes	16	59	2366	2	bizes
blinds	9	51	1161	2	blinds
blips	9	56	1578	2	blips
bliss	7	56	1691	2	bliss
boas	6	61	5083	2	boas
bobs	8	63	4065	2	bobs
bod	6	70	5554	2	bod_
bode	7	58	3875	2	bode
bodes	8	49	3510	2	bodes
body	10	74	2567	2	body
bogs	7	57	4275	2	bogs
boils	7	54	2719	2	boils
bolds	8	58	2528	2	bolds
bonds	8	61	2684	2	bonds
boos	6	79	5503	2	boos
bops	8	60	3798	2	bops
bos	5	79	6681	2	b_os
boss	6	59	3834	2	boss
bots	6	64	5395	2	bots
bovids	12	8	797	2	bovids
bows	9	62	4286	2	bows
boys	9	67	3733	2	boys
brads	8	55	2829	2	brads
braids	9	50	1569	2	braids
bras	6	57	4645	2	bras
bride	8	64	2553	2	bride
brides	9	44	2351	2	brides
bries	7	49	4215	2	bries
brigs	8	58	2322	2	brigs
brims	9	47	2162	2	brims
brins	7	55	3397	2	brins
brios	7	47	2572	2	brios
bris	6	55	3961	2	bris
briss	7	58	2427	2	briss
brits	7	64	3308	2	brits
bros	6	56	3566	2	bros
bubs	8	62	3550	2	bubs
bud	6	70	4127	2	bud_
bugs	7	60	3591	2	bugs
builds	9	37	849	2	builds
bums	8	59	3459	2	bums
bunds	8	55	2354	2	bunds
buns	6	62	4372	2	buns
burds	8	46	2606	2	burds
burs	6	58	4742	2	burs
bus	5	69	5097	2	b_us
buss	6	51	3491	2	buss
buts	6	72	4769	2	buts
buys	9	57	2679	2	buys
byes	9	52	3053	2	byes
bys	8	52	2946	2	b_ys
cads	7	61	4452	2	cads
caids	8	52	2642	2	caids
cebids	11	43	917	2	cebids
cigs	7	56	2510	2	cigs
cis	5	77	4803	2	ci_s
cods	7	68	4810	2	cods
cuds	7	67	3047	2	cuds
dads	6	74	4277	2	dads
dibs	7	62	3368	2	dibs
did	5	68	5051	2	did_
dido	6	65	2819	2	dido
didos	7	68	2081	2	didos
didst	7	46	1961	2	didst
didy	9	91	2150	2	didy
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dims	7	54	3502	2	dims
dins	5	66	5204	2	dins
dips	7	55	3691	2	dips
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
duds	6	55	3014	2	duds
eds	4	66	3892	2	_eds
eide	5	58	3223	2	eide
eidos	6	58	1775	2	eidos
elds	5	63	2485	2	elds
ends	5	65	2852	2	ends
fads	8	69	3987	2	fads
feds	8	52	3431	2	feds
fibs	9	63	2950	2	fibs
fid	7	68	4768	2	fid_
fido	8	77	2639	2	fido
fidos	9	58	1905	2	fidos
figs	8	53	3264	2	figs
fils	7	58	3869	2	fils
finds	9	54	2482	2	finds
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
fuds	8	65	2856	2	fuds
gads	6	78	4338	2	gads
geds	6	67	3081	2	geds
gibs	7	55	2927	2	gibs
gid	5	70	4726	2	gid_
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gilds	7	54	1752	2	gilds
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
girds	7	48	1699	2	girds
gits	5	57	4459	2	gits
gods	6	54	3804	2	gods
grids	7	53	2139	2	grids
guids	7	55	1615	2	guids
hid	7	62	4837	2	hid_
hide	8	51	3463	2	hide
hides	9	51	2942	2	hides
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
hinds	9	67	2147	2	hinds
hins	7	64	4799	2	hins
hips	9	64	3370	2	hips
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hods	8	72	3986	2	hods
ibis	6	65	1958	2	ibis
id	3	89	4183	2	_id_
ides	5	77	3423	2	_ides
ifs	6	71	2424	2	_ifs
imids	8	60	1514	2	imids
ins	3	59	4560	2	_ins
irids	6	64	1777	2	irids
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jibs	13	67	2408	2	jibs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
kid	8	65	4061	2	kid_
kifs	11	60	2350	2	kifs
kinds	10	62	2181	2	kinds
kins	8	57	4790	2	kins
kips	10	64	3051	2	kips
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
lads	5	65	4913	2	lads
libs	6	67	3276	2	libs
lid	4	74	5351	2	lid_
lido	5	60	2815	2	lido
lidos	6	52	1988	2	lidos
lies	4	64	5419	2	lies
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	li_s
lits	4	62	5249	2	lits
loids	6	62	2070	2	loids
mads	7	68	4537	2	mads
maids	8	63	2714	2	maids
meds	7	57	3536	2	meds
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mid	6	73	5446	2	mid_
midi	7	56	2847	2	midi
midis	8	59	2341	2	midis
midst	8	59	2255	2	midst
migs	7	69	3532	2	migs
milds	8	64	2205	2	milds
mils	6	60	4533	2	mils
minds	8	54	2712	2	minds
mips	8	55	3408	2	mips
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	mi_s
miss	6	53	3942	2	miss
mods	7	79	4505	2	mods
muds	7	55	3065	2	muds
nibs	6	50	2831	2	nibs
nide	5	55	3578	2	nide
nides	6	52	2913	2	nides
nidi	5	65	2439	2	nidi
nidus	6	59	1357	2	nidus
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
nods	5	58	3822	2	nods
obias	7	61	1686	2	obias
obis	6	62	2684	2	obi_s
obits	7	46	1755	2	obits
odds	6	89	1992	2	odds
ods	4	75	4621	2	_ods
oils	4	63	3797	2	oils
olds	5	59	2657	2	olds
ouds	5	64	3010	2	ouds
oxids	13	12	896	2	oxids
pads	7	67	4295	2	pads
peds	7	58	3524	2	peds
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pins	6	55	5845	2	pins
pips	8	58	3713	2	pips
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
pods	7	65	4015	2	pods
puds	7	56	3051	2	puds
qaids	15	61	1631	2	qaids
qis	12	69	3438	2	qi_s
quids	15	49	1746	2	quids
rads	5	60	4660	2	rads
raids	6	58	2751	2	raids
rebids	9	40	1553	2	rebids
reds	5	60	4286	2	reds
rias	4	55	4059	2	rias
ribs	6	58	3302	2	ribs
rid	4	67	5462	2	rid_
ride	5	59	4512	2	ride
rides	6	61	4081	2	rides
rifs	7	49	2900	2	rifs
rigs	5	51	3759	2	rigs
rims	6	59	3630	2	rims
rinds	6	48	2614	2	rinds
rins	4	61	5319	2	rins
rips	6	62	3743	2	rips
rods	5	64	4206	2	rods
saids	6	53	2885	2	saids
sibs	6	59	3354	2	sibs
sics	6	52	3409	2	sics
side	5	54	4448	2	side
sides	6	58	3836	2	sides
sidh	8	62	2298	2	sidh
silds	6	55	2052	2	silds
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
skids	10	46	1532	2	skids
sods	5	49	4021	2	sods
suds	5	61	3529	2	suds
tads	5	71	4394	2	tads
teds	5	49	3257	2	teds
tics	6	57	2963	2	tics
tide	5	52	3737	2	tide
tides	6	48	3015	2	tides
tidy	8	68	2241	2	tidy
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tins	4	52	5130	2	tins
tips	6	64	3676	2	tips
tis	3	70	5664	2	ti_s
tits	4	61	4504	2	tits
tods	5	61	4184	2	tods
urds	5	59	2242	2	urds
vid	7	72	4180	2	vid_
vide	8	54	3275	2	vide
vies	7	52	3862	2	vies
vigs	8	54	2727	2	vigs
vims	9	54	2331	2	vims
vis	6	67	4761	2	vi_s
voids	9	54	1467	2	voids
wads	8	73	4314	2	wads
weds	8	66	2893	2	weds
whids	12	54	1398	2	whids
wide	8	52	3540	2	wide
wides	9	48	3282	2	wides
wigs	8	49	3125	2	wigs
wilds	9	48	1820	2	wilds
winds	9	54	2560	2	winds
wins	7	59	4917	2	wins
wis	6	65	5233	2	wi_s
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
xis	10	69	3533	2	xi_s
yid	7	66	4082	2	yid_
yins	7	53	3512	2	yins
yips	9	52	2670	2	yips
yirds	9	66	1251	2	yirds
yods	8	65	3118	2	yods
zeds	14	58	2180	2	zeds
zigs	14	54	2279	2	zigs
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	2	zits

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.080	2233637.5
2	DLD Change Limit	29872	421	0.860	34734.9
3	Display Results	421	421	0.093	4526.9
	(SQL Overall)	178691	421	1.033	172982.6