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

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

349 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
gips	7	56	3293	(None)
dips	7	55	3692	1	dips
gaps	7	60	4297	1	gaps
gibs	7	55	2928	1	gibs
gids	6	59	3375	1	gids
gies	5	56	4143	1	gies
gigs	6	66	3119	1	gigs
gimps	10	59	1520	1	gimps
gins	5	55	4396	1	gins
gip	6	76	4537	1	gip_
gipsy	11	57	954	1	gipsy
gits	5	57	4460	1	gits
grips	8	55	2013	1	grips
gyps	10	51	1502	1	gyps
hips	9	64	3371	1	hips
kips	10	64	3053	1	kips
lips	6	71	4145	1	lips
mips	8	55	3409	1	mips
nips	6	58	3093	1	nips
pips	8	58	3714	1	pips
rips	6	62	3744	1	rips
sips	6	57	4011	1	sips
tips	6	64	3677	1	tips
yips	9	52	2671	1	yips
zips	15	57	2380	1	zips
agios	6	59	1986	2	agios
aids	5	78	4637	2	aids
ails	4	56	5472	2	ails
aims	6	77	3819	2	aims
ains	4	61	5889	2	ains
airs	4	64	4743	2	airs
ais	3	90	8358	2	ai_s
aits	4	63	5554	2	aits
alps	6	55	2924	2	alps
amps	8	62	3034	2	amps
apps	8	63	1969	2	apps
asps	6	56	2209	2	asps
baps	8	60	4084	2	baps
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bids	7	58	3846	2	bids
bigs	7	62	3503	2	bigs
bins	6	65	4826	2	bins
bios	6	63	3533	2	bios
bis	5	68	6067	2	bi_s
bits	6	61	4817	2	bits
blips	9	56	1578	2	blips
bops	8	60	3798	2	bops
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
chips	12	57	2125	2	chips
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
clips	9	60	1830	2	clips
cops	8	67	5137	2	cops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dims	7	54	3503	2	dims
dins	5	66	5205	2	dins
dip	6	78	4899	2	dip_
dipso	8	51	1155	2	dipso
dipt	7	73	3933	2	dipt
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
drips	8	54	1723	2	drips
dups	7	59	2951	2	dups
egis	5	65	2065	2	egi_s
fibs	9	63	2951	2	fibs
fids	8	70	3475	2	fids
figs	8	53	3265	2	figs
fils	7	58	3870	2	fils
fins	7	58	4910	2	fins
firs	7	66	3772	2	firs
fits	7	60	4347	2	fits
flips	10	51	1774	2	flips
fops	9	65	3268	2	fops
gabs	7	67	4042	2	gabs
gads	6	78	4339	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gains	6	57	2951	2	gains
gaits	6	57	2601	2	gaits
gals	5	79	4650	2	gals
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	gams
gap	6	70	5561	2	gap_
gape	7	51	3451	2	gape
gapes	8	60	3082	2	gapes
gapy	10	63	2091	2	gapy
gars	5	57	5074	2	gars
gas	4	88	7025	2	g_as
gasp	7	62	2733	2	gasp
gasps	8	54	1548	2	gasps
gats	5	67	5344	2	gats
gawps	11	59	1101	2	gawps
gays	8	73	3802	2	gays
geds	6	67	3082	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gems	7	53	2911	2	gems
genips	9	46	994	2	genips
gens	5	57	4007	2	gens
gets	5	54	4248	2	gets
ghis	8	50	2016	2	ghis
gib	6	64	4354	2	gi_b
gibe	7	59	2779	2	gibe
gibes	8	44	2252	2	gibes
gid	5	70	4728	2	gi_d
gie	4	71	4955	2	gi_e
gied	6	46	3199	2	gied
gien	5	63	3003	2	gien
gift	8	67	3580	2	gift
gifts	9	62	1496	2	gifts
gig	5	60	4076	2	gi_g
giga	6	67	2095	2	giga
gigas	7	54	1558	2	gigas
gild	6	55	2652	2	gild
gilds	7	54	1753	2	gilds
gill	5	63	3619	2	gill
gills	6	47	2819	2	gills
gilt	5	63	4855	2	gilt
gilts	6	49	2426	2	gilts
gimp	9	61	2405	2	gimp
gimpy	13	52	1223	2	gimpy
gin	4	60	5576	2	gi_n
gink	9	71	2953	2	gink
ginks	10	43	1956	2	ginks
gipon	8	42	1241	2	gipon
gipons	9	38	960	2	gipons
gird	6	54	2500	2	gird
girds	7	48	1700	2	girds
girl	5	62	2656	2	girl
girls	6	45	1839	2	girls
girn	5	60	2687	2	girn
girns	6	45	1680	2	girns
giro	5	58	2864	2	giro
giros	6	57	2265	2	giros
girsh	9	53	1002	2	girsh
girt	5	66	4643	2	girt
girts	6	54	2362	2	girts
gist	5	60	4677	2	gist
gists	6	60	2619	2	gists
git	4	62	6606	2	gi_t
gite	5	54	3862	2	gite
gites	6	56	3018	2	gites
give	8	58	2936	2	give
gives	9	53	2487	2	gives
glias	6	46	1849	2	glias
glims	8	74	1767	2	glims
glops	8	56	1955	2	glops
gnus	5	65	1800	2	gnus
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3805	2	gods
goes	5	56	4409	2	goes
goops	8	66	2096	2	goops
goos	5	76	4491	2	goos
gorps	8	53	1699	2	gorps
gos	4	71	5513	2	g_os
goys	8	63	2841	2	goys
grids	7	53	2140	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
guids	7	55	1616	2	guids
gulps	8	47	1507	2	gulps
guls	5	59	3085	2	guls
gums	7	50	3094	2	gums
guns	5	55	3348	2	guns
guts	5	66	3725	2	guts
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
gyms	10	75	1459	2	gyms
gyp	9	83	1901	2	gyp_
gypsy	14	63	699	2	gypsy
haps	9	64	4346	2	haps
hies	7	48	4284	2	hies
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hip	8	67	5044	2	hip_
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
hops	9	79	4263	2	hops
hyps	12	54	1841	2	hyps
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
iggs	6	66	1267	2	iggs
imps	8	62	2112	2	imps
ins	3	59	4561	2	_ins
is	2	70	4822	2	_i_s
its	3	55	3884	2	_its
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jins	11	56	3502	2	jins
keps	10	60	2731	2	keps
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kins	8	57	4792	2	kins
kip	9	70	4215	2	kip_
kirs	8	58	3175	2	kirs
kis	7	80	5149	2	ki_s
kiss	8	52	2741	2	kiss
kits	8	64	4178	2	kits
kops	10	70	3130	2	kops
laps	6	68	4887	2	laps
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
limps	9	55	2267	2	limps
lins	4	70	5906	2	lins
lip	5	147	5581	2	lip_
lipa	6	84	2593	2	lipa
lipe	6	68	3974	2	lipe
lis	3	71	6228	2	li_s
lisp	6	89	2689	2	lisp
lisps	7	69	1391	2	lisps
lits	4	62	5250	2	lits
lops	6	60	4335	2	lops
maps	8	61	4105	2	maps
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
mops	8	59	4013	2	mops
naps	6	62	3858	2	naps
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nims	6	62	2689	2	nims
nip	5	69	4599	2	nip_
nipa	6	94	2164	2	nipa
nipas	7	71	1667	2	nipas
nits	4	57	4165	2	nits
oils	4	63	3798	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	4256	2	pias
pics	8	56	3392	2	pics
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pimps	11	46	1698	2	pimps
pins	6	55	5846	2	pins
pip	7	80	5105	2	pip_
pipe	8	64	3444	2	pipe
pipes	9	60	3014	2	pipes
pipy	11	54	2152	2	pipy
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pits	6	63	4875	2	pits
pops	8	63	4095	2	pops
pups	8	60	3223	2	pups
qis	12	69	3439	2	qi_s
quips	16	47	1337	2	quips
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rids	5	65	3956	2	rids
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
rip	5	68	5131	2	rip_
ripe	6	60	3893	2	ripe
ripes	7	54	3577	2	ripes
saps	6	53	4637	2	saps
ships	10	51	2377	2	ships
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
simps	9	47	1976	2	simps
sims	6	57	3718	2	sims
sins	4	67	5528	2	sins
sip	5	76	5602	2	sip_
sipe	6	73	4105	2	sipe
sipes	7	60	3695	2	sipes
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
skips	11	56	1661	2	skips
slips	7	60	2372	2	slips
snips	7	58	1801	2	snips
sops	6	52	4456	2	sops
sups	6	48	3443	2	sups
taps	6	60	5068	2	taps
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
tins	4	52	5131	2	tins
tip	5	65	5123	2	tip_
tipi	6	99	2444	2	tipi
tipis	7	60	1992	2	tipis
tipsy	10	60	1050	2	tipsy
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
tops	6	62	4812	2	tops
trips	7	49	2336	2	trips
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
ups	5	56	2905	2	_ups
urps	6	69	2048	2	urps
vids	8	56	2755	2	vids
vies	7	52	3863	2	vies
vigs	8	54	2728	2	vigs
vims	9	54	2332	2	vims
vis	6	67	4762	2	vi_s
waps	9	66	4208	2	waps
whips	13	49	1708	2	whips
wigs	8	49	3126	2	wigs
wimps	12	52	1380	2	wimps
wins	7	59	4918	2	wins
wipe	9	48	3029	2	wipe
wipes	10	48	2708	2	wipes
wis	6	65	5234	2	wi_s
wisp	9	71	2408	2	wisp
wisps	10	52	1418	2	wisps
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
wops	9	66	3415	2	wops
xis	10	69	3534	2	xi_s
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yip	8	72	4119	2	yip_
yipe	9	67	2219	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	2280	2	zigs
zins	13	57	3501	2	zins
zip	14	66	3623	2	zip_
zits	13	60	3030	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.266	671770.7
2	DLD Change Limit	29872	349	0.763	39150.7
3	Display Results	349	349	0.080	4362.5
	(SQL Overall)	178691	349	1.109	161128.0