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

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

431 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
rips	6	62	3743	(None)
dips	7	55	3691	1	dips
drips	8	54	1723	1	drips
gips	7	56	3292	1	gips
grips	8	55	2013	1	grips
hips	9	64	3370	1	hips
kips	10	64	3051	1	kips
lips	6	71	4144	1	lips
mips	8	55	3407	1	mips
nips	6	58	3092	1	nips
pips	8	58	3713	1	pips
raps	6	62	4773	1	raps
reps	6	59	3795	1	reps
rias	4	55	4059	1	rias
ribs	6	58	3301	1	ribs
rids	5	65	3954	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
rip	5	68	5130	1	rip_
ripe	6	60	3892	1	ripe
ripes	7	54	3577	1	ripes
sips	6	57	4010	1	sips
tips	6	64	3676	1	tips
trips	7	49	2336	1	trips
yips	9	52	2669	1	yips
zips	15	57	2379	1	zips
aids	5	78	4635	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
alps	6	55	2924	2	alps
amps	8	62	3034	2	amps
apps	8	63	1969	2	apps
arias	5	54	3802	2	arias
arils	5	87	3220	2	arils
asps	6	56	2209	2	asps
baps	8	60	4084	2	baps
bias	6	47	3815	2	bias
bibs	8	48	3097	2	bibs
bids	7	58	3842	2	bids
bigs	7	62	3501	2	bigs
bins	6	65	4824	2	bins
bios	6	63	3531	2	bios
bis	5	68	6065	2	bi_s
bits	6	61	4815	2	bits
blips	9	56	1578	2	blips
bops	8	60	3798	2	bops
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
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
chips	12	57	2125	2	chips
cigs	7	56	2510	2	cigs
cis	5	77	4803	2	ci_s
clips	9	60	1830	2	clips
cops	8	67	5137	2	cops
craps	9	53	2864	2	craps
cribs	9	45	1674	2	cribs
cries	7	54	3840	2	cries
crimps	12	46	1345	2	crimps
cripe	9	55	2114	2	cripe
cripes	10	51	2087	2	cripes
cris	6	62	3343	2	cri_s
crisp	9	50	1462	2	crisp
crisps	10	44	1151	2	crisps
crits	7	55	2757	2	crits
crops	9	61	2523	2	crops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dibs	7	62	3367	2	dibs
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
dip	6	78	4898	2	dip_
dipso	8	51	1155	2	dipso
dipt	7	73	3932	2	dipt
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
dribs	8	51	1505	2	dribs
dries	6	47	3367	2	dries
drip	7	62	2395	2	drip_
dript	8	69	2387	2	dript
drops	8	57	1950	2	drops
dups	7	59	2951	2	dups
fibs	9	63	2949	2	fibs
fids	8	70	3473	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
flips	10	51	1774	2	flips
fops	9	65	3268	2	fops
fraps	10	56	2055	2	fraps
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frits	8	61	2910	2	frits
gaps	7	60	4297	2	gaps
gibs	7	55	2926	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gimps	10	59	1520	2	gimps
gins	5	55	4395	2	gins
gip	6	76	4536	2	gip_
gipsy	11	57	954	2	gipsy
gits	5	57	4459	2	gits
grids	7	53	2139	2	grids
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
grip	7	61	2702	2	grip_
gripe	8	46	2296	2	gripe
gripes	9	46	1987	2	gripes
gript	8	51	2617	2	gript
gripy	11	51	1525	2	gripy
grits	6	55	2958	2	grits
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hip	8	67	5043	2	hip_
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hops	9	79	4263	2	hops
hyps	12	54	1841	2	hyps
ids	4	75	3546	2	_ids
ifs	6	71	2424	2	_ifs
imps	8	62	2111	2	imps
ins	3	59	4560	2	_ins
ires	4	56	3928	2	ires
irids	6	64	1776	2	irids
iris	4	57	3254	2	iris
irks	8	62	2013	2	irks
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jibs	13	67	2407	2	jibs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
keps	10	60	2730	2	keps
kids	9	60	2963	2	kids
kifs	11	60	2350	2	kifs
kins	8	57	4790	2	kins
kip	9	70	4213	2	kip_
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
kops	10	70	3129	2	kops
kris	8	64	2360	2	kri_s
laps	6	68	4887	2	laps
libs	6	67	3275	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
limps	9	55	2267	2	limps
lins	4	70	5905	2	lins
lip	5	147	5580	2	lip_
lipa	6	84	2592	2	lipa
lipe	6	68	3973	2	lipe
lis	3	71	6227	2	li_s
lisp	6	89	2687	2	lisp
lisps	7	69	1390	2	lisps
lits	4	62	5249	2	lits
lops	6	60	4335	2	lops
maps	8	61	4104	2	maps
mibs	8	53	3046	2	mibs
mics	8	74	3514	2	mics
mids	7	65	4177	2	mids
migs	7	69	3531	2	migs
mils	6	60	4532	2	mils
mirs	6	69	4056	2	mirs
mis	5	81	6261	2	mi_s
miss	6	53	3941	2	miss
mops	8	59	4013	2	mops
naps	6	62	3858	2	naps
nibs	6	50	2830	2	nibs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nip	5	69	4598	2	nip_
nipa	6	94	2163	2	nipa
nipas	7	71	1667	2	nipas
nits	4	57	4164	2	nits
oils	4	63	3797	2	oils
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
paps	8	64	4345	2	paps
peps	8	51	3451	2	peps
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pimps	11	46	1698	2	pimps
pins	6	55	5845	2	pins
pip	7	80	5104	2	pip_
pipe	8	64	3443	2	pipe
pipes	9	60	3014	2	pipes
pipy	11	54	2151	2	pipy
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
pops	8	63	4095	2	pops
preps	9	62	2069	2	preps
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
primps	12	47	1182	2	primps
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
props	9	57	2688	2	props
pups	8	60	3223	2	pups
qis	12	69	3438	2	qi_s
quips	16	47	1337	2	quips
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
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	rams
rap	5	62	6196	2	rap_
rape	6	50	4163	2	rape
rapes	7	57	4072	2	rapes
rapt	6	72	4531	2	rapt
ras	3	75	7539	2	r_as
rasp	6	60	2916	2	rasp
rasps	7	43	1666	2	rasps
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
reaps	7	56	2619	2	reaps
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
redips	9	37	1384	2	redips
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
rep	5	58	4780	2	rep_
repo	6	60	2754	2	repo
repos	7	47	2579	2	repos
repp	8	54	1874	2	repp
repps	9	51	1434	2	repps
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
rib	5	68	4802	2	ri_b
ribes	7	55	3017	2	ribes
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	5462	2	ri_d
ride	5	59	4512	2	ride
rides	6	61	4081	2	rides
riel	4	64	3238	2	riel
riels	5	51	2133	2	riels
rif	6	59	5155	2	ri_f
rife	7	46	3232	2	rife
riff	10	44	3009	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
riped	8	52	2643	2	riped
ripen	7	56	1926	2	ripen
ripens	8	50	1217	2	ripens
riper	7	43	2840	2	riper
ripest	8	43	1793	2	ripest
ripost	8	36	1500	2	ripost
ripsaw	11	3	428	2	ripsaw
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
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
roils	5	48	2679	2	roils
romps	9	46	1754	2	romps
roms	6	70	3896	2	roms
rope	6	55	4291	2	rope
ropes	7	59	4006	2	ropes
ropy	9	63	2341	2	ropy
rots	4	64	5409	2	rots
roups	7	51	1890	2	roups
rows	7	59	4175	2	rows
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
ruins	5	58	2203	2	ruins
rumps	9	59	2229	2	rumps
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
ryas	7	72	2461	2	ryas
ryes	7	55	2935	2	ryes
saps	6	53	4637	2	saps
scrips	10	53	1603	2	scrips
ships	10	51	2377	2	ships
sibs	6	59	3353	2	sibs
sics	6	52	3409	2	sics
simps	9	47	1976	2	simps
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sip	5	76	5601	2	sip_
sipe	6	73	4104	2	sipe
sipes	7	60	3695	2	sipes
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
skips	11	56	1660	2	skips
slips	7	60	2372	2	slips
snips	7	58	1801	2	snips
sops	6	52	4456	2	sops
sris	4	54	3415	2	sri_s
strips	8	57	1965	2	strips
sups	6	48	3443	2	sups
taps	6	60	5067	2	taps
thrips	11	29	901	2	thrips
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tins	4	52	5130	2	tins
tip	5	65	5122	2	tip_
tipi	6	99	2443	2	tipi
tipis	7	60	1992	2	tipis
tipsy	10	60	1050	2	tipsy
tis	3	70	5664	2	ti_s
tits	4	61	4503	2	tits
tops	6	62	4812	2	tops
traps	7	57	2748	2	traps
tries	5	57	4281	2	tries
trigs	6	54	2306	2	trigs
trims	7	50	2147	2	trims
trios	5	55	2809	2	trios
trip	6	68	3039	2	trip_
tripe	7	54	2538	2	tripe
tripes	8	53	2487	2	tripes
tripos	8	40	1492	2	tripos
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
unrips	8	19	945	2	unrips
ups	5	56	2905	2	_ups
urps	6	69	2047	2	urps
vids	8	56	2753	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
waps	9	66	4208	2	waps
whips	13	49	1708	2	whips
wigs	8	49	3125	2	wigs
wimps	12	52	1380	2	wimps
wins	7	59	4917	2	wins
wipe	9	48	3028	2	wipe
wipes	10	48	2708	2	wipes
wis	6	65	5233	2	wi_s
wisp	9	71	2407	2	wisp
wisps	10	52	1418	2	wisps
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
wops	9	66	3415	2	wops
wraps	10	56	1715	2	wraps
wries	8	58	2774	2	wries
writs	8	66	2438	2	writs
xis	10	69	3533	2	xi_s
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yids	8	52	2495	2	yids
yins	7	53	3512	2	yins
yip	8	72	4117	2	yip_
yipe	9	67	2217	2	yipe
yipes	10	60	1784	2	yipes
yups	9	61	2160	2	yups
zaps	15	68	2689	2	zaps
zeps	15	60	1934	2	zeps
zigs	14	54	2279	2	zigs
zins	13	57	3500	2	zins
zip	14	66	3622	2	zip_
zits	13	60	3029	2	zits

Search took 1 second 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.063	2836365.1
2	DLD Change Limit	29872	431	0.783	38150.7
3	Display Results	431	431	0.106	4066.0
	(SQL Overall)	178691	431	0.952	187700.6