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

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

371 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
ribs	6	58	3302	(None)
bibs	8	48	3099	1	bibs
cribs	9	45	1675	1	cribs
dibs	7	62	3368	1	dibs
dribs	8	51	1506	1	dribs
fibs	9	63	2950	1	fibs
gibs	7	55	2927	1	gibs
jibs	13	67	2408	1	jibs
libs	6	67	3276	1	libs
mibs	8	53	3048	1	mibs
nibs	6	50	2831	1	nibs
rebs	6	57	3356	1	rebs
rias	4	55	4059	1	rias
rib	5	68	4803	1	rib_
ribes	7	55	3017	1	ribes
rids	5	65	3955	1	rids
rifs	7	49	2900	1	rifs
rigs	5	51	3759	1	rigs
rims	6	59	3630	1	rims
rins	4	61	5319	1	rins
rips	6	62	3743	1	rips
robs	6	58	3787	1	robs
rubs	6	61	3349	1	rubs
sibs	6	59	3354	1	sibs
abs	5	93	5607	2	_abs
aids	5	78	4636	2	aids
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
albs	6	86	2857	2	albs
arbs	6	68	3473	2	arbs
arias	5	54	3802	2	arias
arils	5	87	3220	2	arils
bias	6	47	3816	2	bias
bib	7	70	4594	2	bib_
bibb	7	58	1921	2	bibb
bibbs	8	49	1158	2	bibbs
bids	7	58	3845	2	bids
bigs	7	62	3502	2	bigs
bins	6	65	4825	2	bins
bios	6	63	3532	2	bios
bis	5	68	6066	2	bi_s
bits	6	61	4816	2	bits
bobs	8	63	4065	2	bobs
bribe	9	48	2078	2	bribe
bribes	10	59	1853	2	bribes
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	bri_s
briss	7	58	2427	2	briss
brits	7	64	3308	2	brits
bubs	8	62	3550	2	bubs
cabs	8	67	3942	2	cabs
cigs	7	56	2510	2	cigs
cis	5	77	4803	2	ci_s
cobs	8	70	4314	2	cobs
crabs	9	54	2139	2	crabs
crib	8	63	2358	2	crib_
cries	7	54	3840	2	cries
cris	6	62	3343	2	cri_s
crits	7	55	2757	2	crits
cubs	8	58	3238	2	cubs
dabs	7	71	3940	2	dabs
debs	7	65	3024	2	debs
dib	6	57	4694	2	dib_
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
drabs	8	51	1967	2	drabs
drib	7	68	2326	2	drib_
dries	6	47	3367	2	dries
drips	8	54	1723	2	drips
drubs	8	59	1383	2	drubs
dubs	7	84	3219	2	dubs
ebbs	8	24	1199	2	ebbs
fabs	9	86	3586	2	fabs
fib	8	63	4427	2	fib_
fids	8	70	3474	2	fids
figs	8	53	3264	2	figs
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
fobs	9	60	3427	2	fobs
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frits	8	61	2910	2	frits
fubs	9	63	2879	2	fubs
gabs	7	67	4042	2	gabs
gib	6	64	4353	2	gib_
gibe	7	59	2778	2	gibe
gibes	8	44	2252	2	gibes
gids	6	59	3374	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
gobs	7	69	3557	2	gobs
grabs	8	57	1969	2	grabs
grids	7	53	2139	2	grids
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
grips	8	55	2013	2	grips
grits	6	55	2958	2	grits
grubs	8	63	1260	2	grubs
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
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
hobs	9	70	3898	2	hobs
hubs	9	60	2714	2	hubs
ibis	6	65	1958	2	_ibis
ids	4	75	3547	2	_ids
ifs	6	71	2424	2	_ifs
ins	3	59	4560	2	_ins
ires	4	56	3928	2	ires
irids	6	64	1777	2	irids
iris	4	57	3255	2	iris
irks	8	62	2013	2	irks
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jabs	13	58	3009	2	jabs
jib	12	58	3597	2	jib_
jibb	15	58	1674	2	jibb
jibbs	16	60	974	2	jibbs
jibe	13	63	2339	2	jibe
jibes	14	55	2032	2	jibes
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
jobs	13	65	2943	2	jobs
kabs	10	71	3084	2	kabs
kibe	10	65	2345	2	kibe
kibes	11	55	2111	2	kibes
kids	9	60	2964	2	kids
kifs	11	60	2351	2	kifs
kins	8	57	4791	2	kins
kips	10	64	3052	2	kips
kirs	8	58	3174	2	kirs
kis	7	80	5148	2	ki_s
kiss	8	52	2740	2	kiss
kits	8	64	4177	2	kits
kobs	10	58	3108	2	kobs
kris	8	64	2360	2	kri_s
labs	6	71	4512	2	labs
lib	5	77	5027	2	lib_
lids	5	63	3646	2	lids
lies	4	64	5419	2	lies
limbs	9	61	1894	2	limbs
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
lobs	6	64	4108	2	lobs
mib	7	69	4612	2	mib_
mics	8	74	3515	2	mics
mids	7	65	4179	2	mids
migs	7	69	3532	2	migs
mils	6	60	4533	2	mils
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
mobs	8	57	3737	2	mobs
nabs	6	62	3619	2	nabs
nebs	6	61	2498	2	nebs
nib	5	67	4519	2	nib_
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
nobs	6	64	3690	2	nobs
nubs	6	59	2714	2	nubs
obis	6	62	2684	2	obis
oils	4	63	3797	2	oils
orbs	6	66	2625	2	orbs
oribi	7	3	1109	2	oribi
oribis	8	3	883	2	oribis
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
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
pubs	8	50	2921	2	pubs
qis	12	69	3438	2	qi_s
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rains	5	51	4023	2	rains
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
raps	6	62	4773	2	raps
ras	3	75	7539	2	r_as
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
reb	5	58	4496	2	reb_
rebus	7	57	2111	2	rebus
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reifs	8	48	1909	2	reifs
reins	5	62	3456	2	reins
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	r_es
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rhos	7	63	1906	2	rhos
rhus	7	51	1405	2	rhus
ria	3	67	4550	2	ri_a
rial	4	59	3809	2	rial
rials	5	50	2667	2	rials
ribby	12	41	968	2	ribby
ribose	8	3	989	2	ribose
rice	6	49	4291	2	rice
rices	7	55	3615	2	rices
rich	9	70	2554	2	rich
rick	10	73	3465	2	rick
ricks	11	51	2613	2	ricks
rid	4	67	5463	2	ri_d
ride	5	59	4513	2	ride
rides	6	61	4081	2	rides
riel	4	64	3238	2	riel
riels	5	51	2133	2	riels
rif	6	59	5156	2	ri_f
rife	7	46	3232	2	rife
riff	10	44	3010	2	riff
riffs	11	51	1461	2	riffs
rift	7	56	4233	2	rift
rifts	8	57	1864	2	rifts
rig	4	67	4812	2	ri_g
rile	4	56	5053	2	rile
riles	5	53	4364	2	riles
rill	4	51	4090	2	rill
rills	5	50	3271	2	rills
rim	5	60	5227	2	ri_m
rime	6	51	3888	2	rime
rimes	7	56	3454	2	rimes
rimy	9	66	2128	2	rimy
rin	3	66	6318	2	ri_n
rind	5	65	3560	2	rind
rinds	6	48	2614	2	rinds
ring	5	65	4115	2	ring
rings	6	50	2917	2	rings
rink	8	77	3699	2	rink
rinks	9	48	2710	2	rinks
rinse	5	48	2097	2	rinse
riot	4	59	4721	2	riot
riots	5	49	2201	2	riots
rip	5	68	5130	2	ri_p
ripe	6	60	3892	2	ripe
ripes	7	54	3577	2	ripes
rise	4	59	4523	2	rise
rises	5	52	4404	2	rises
risk	8	57	2410	2	risk
risks	9	49	1706	2	risks
risus	5	42	1639	2	risus
rite	4	58	4945	2	rite
rites	5	44	4255	2	rites
ritz	13	51	2998	2	ritz
rive	7	55	3772	2	rive
rives	8	53	3600	2	rives
rob	5	67	5430	2	rob_
robe	6	53	3564	2	robe
robes	7	51	3330	2	robes
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5414	2	roes
roils	5	48	2679	2	roils
roms	6	70	3896	2	roms
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
rub	5	63	4282	2	rub_
rube	6	55	3201	2	rube
rubes	7	49	2841	2	rubes
rubus	7	64	1506	2	rubus
ruby	9	78	1994	2	ruby
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
ruins	5	58	2203	2	ruins
rums	6	48	3347	2	rums
runs	4	64	3808	2	runs
ruts	4	45	4149	2	ruts
ryas	7	72	2461	2	ryas
ryes	7	55	2935	2	ryes
sabs	6	66	4374	2	sabs
sib	5	68	5031	2	sib_
sibb	8	59	2142	2	sibb
sibbs	9	62	1190	2	sibbs
sics	6	52	3409	2	sics
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
snibs	7	56	1376	2	snibs
sobs	6	49	4175	2	sobs
sris	4	54	3415	2	sri_s
subs	6	60	3712	2	subs
tabs	6	68	4298	2	tabs
tics	6	57	2963	2	tics
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
tribe	7	44	2027	2	tribe
tribes	8	51	1902	2	tribes
tries	5	57	4281	2	tries
trigs	6	54	2306	2	trigs
trims	7	50	2147	2	trims
trios	5	55	2809	2	trios
trips	7	49	2336	2	trips
tubs	6	54	3006	2	tubs
urbs	6	59	2206	2	urbs
vibe	9	51	2450	2	vibe
vibes	10	47	1995	2	vibes
vids	8	56	2754	2	vids
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
wabs	9	73	3723	2	wabs
webs	9	66	2212	2	webs
wigs	8	49	3125	2	wigs
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
wries	8	58	2774	2	wries
writs	8	66	2438	2	writs
xis	10	69	3533	2	xi_s
yids	8	52	2496	2	yids
yins	7	53	3512	2	yins
yips	9	52	2670	2	yips
yobs	9	60	2808	2	yobs
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 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	29872	1.266	141146.1
2	DLD Change Limit	29872	371	3.810	7840.4
3	Display Results	371	371	0.173	2144.5
	(SQL Overall)	178691	371	5.249	34042.9