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

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

277 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
brits	7	64	3308	(None)
baits	7	66	3058	1	baits
bits	6	61	4816	1	b_its
brats	7	53	3601	1	brats
bries	7	49	4215	1	bries
brigs	8	58	2322	1	brigs
brims	9	47	2162	1	brims
brins	7	55	3397	1	brins
brios	7	47	2572	1	brios
bris	6	55	3961	1	bri_s
briss	7	58	2427	1	briss
brit	6	63	5015	1	brit_
brith	10	49	2437	1	brith
briths	11	51	1386	1	briths
britt	7	57	3223	1	britt
britts	8	48	1344	1	britts
bruits	8	57	1445	1	bruits
bruts	7	59	2295	1	bruts
crits	7	55	2757	1	crits
frits	8	61	2910	1	frits
grits	6	55	2958	1	grits
writs	8	66	2438	1	writs
abris	7	57	2260	2	abri_s
adits	6	65	2371	2	adits
afrits	9	3	1190	2	afrits
airts	5	56	2634	2	airts
aits	4	63	5553	2	_aits
arias	5	54	3802	2	arias
arils	5	87	3220	2	arils
arts	4	96	5026	2	ar_ts
bahts	10	56	1780	2	bahts
bails	7	59	3352	2	bails
bait	6	65	5600	2	bait_
baith	10	80	2313	2	baith
barite	8	42	2481	2	barite
barites	9	43	2233	2	barites
basts	7	59	3693	2	basts
bats	6	69	6233	2	b_ats
batts	7	67	2756	2	batts
beats	7	60	4224	2	beats
beets	7	61	3144	2	beets
befits	11	47	1150	2	befits
belts	7	59	3116	2	belts
bents	7	60	3369	2	bents
berets	8	58	2252	2	berets
bests	7	59	3261	2	bests
bets	6	70	5144	2	b_ets
bhuts	10	58	1295	2	bhuts
bias	6	47	3816	2	b_ias
bibs	8	48	3099	2	b_ibs
bids	7	58	3843	2	b_ids
bigs	7	62	3502	2	b_igs
binits	8	57	1667	2	binits
bins	6	65	4825	2	b_ins
bints	7	61	3018	2	bints
bios	6	63	3532	2	b_ios
birds	8	54	2133	2	birds
birks	11	49	2030	2	birks
birls	7	40	2316	2	birls
biros	7	53	2513	2	biros
birrs	7	49	1710	2	birrs
birth	10	56	1987	2	birth
births	11	57	1360	2	births
bis	5	68	6066	2	b_i_s
bit	5	70	7090	2	b_it_
bite	6	65	4700	2	b_ite
bites	7	56	4117	2	b_ites
bitsy	10	45	1130	2	b_itsy
bitt	6	55	4581	2	b_itt
bitts	7	50	2259	2	bitts
blats	7	51	3250	2	blats
blets	7	53	2494	2	blets
blips	9	56	1578	2	blips
bliss	7	56	1691	2	bliss
blite	7	62	2535	2	blite
blites	8	47	2121	2	blites
blitz	16	53	1813	2	blitz
blots	7	56	2617	2	blots
boats	7	56	3515	2	boats
boils	7	54	2719	2	boils
boite	7	44	2632	2	boite
boites	8	43	2270	2	boites
bolts	7	62	3211	2	bolts
boots	7	58	3797	2	boots
borts	7	67	3545	2	borts
bots	6	64	5395	2	b_ots
botts	7	52	2486	2	botts
bouts	7	51	3131	2	bouts
bracts	10	56	1777	2	bracts
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
braids	9	50	1568	2	braids
brails	8	46	2129	2	brails
brains	8	51	2547	2	brains
brans	7	54	3743	2	brans
brants	8	57	2305	2	brants
bras	6	57	4645	2	br_as
brass	7	54	2802	2	brass
brat	6	60	5554	2	brat_
braws	10	64	2519	2	braws
brays	10	67	2311	2	brays
brees	7	56	3255	2	brees
brens	7	58	2336	2	brens
brents	8	47	1727	2	brents
brews	10	56	1707	2	brews
briar	7	57	1815	2	briar
briars	8	48	1482	2	briars
bribe	9	48	2078	2	bribe
bribes	10	59	1853	2	bribes
brick	13	46	1815	2	brick
bricks	14	46	1462	2	bricks
bride	8	64	2553	2	bride
brides	9	44	2351	2	brides
brie	6	58	3790	2	bri_e
brief	10	54	2260	2	brief
briefs	11	55	1007	2	briefs
brier	7	45	2740	2	brier
briers	8	53	1973	2	briers
brig	7	65	2803	2	bri_g
brights	13	37	1023	2	brights
brill	7	48	1995	2	brill
brills	8	49	1629	2	brills
brim	8	56	2937	2	bri_m
brin	6	70	3819	2	bri_n
brine	7	51	3227	2	brine
brines	8	50	2885	2	brines
bring	8	55	2850	2	bring
brings	9	46	1843	2	brings
brink	11	61	2200	2	brink
brinks	12	46	1631	2	brinks
briny	10	47	1966	2	briny
brio	6	54	3249	2	bri_o
brises	8	49	2761	2	brises
brisk	11	56	1598	2	brisk
brisks	12	46	1140	2	brisks
britska	13	13	288	2	britska
broils	8	41	1417	2	broils
broos	7	51	2641	2	broos
bros	6	56	3566	2	br_os
broth	10	65	2109	2	broth
broths	11	50	1392	2	broths
brows	10	54	2598	2	brows
bruins	8	60	1495	2	bruins
bruit	7	61	2672	2	bruit_
brunts	8	52	1545	2	brunts
brut	6	65	3796	2	brut_
brute	7	53	2178	2	brute
brutes	8	61	1868	2	brutes
bunts	7	57	2980	2	bunts
burets	8	43	2126	2	burets
buries	8	46	3327	2	buries
burins	8	42	2189	2	burins
bursts	8	51	1624	2	bursts
busts	7	52	2769	2	busts
buts	6	72	4769	2	b_uts
butts	7	58	2425	2	butts
chits	10	54	2457	2	chits
cribs	9	45	1675	2	cribs
cries	7	54	3840	2	cries
cris	6	62	3343	2	cri_s
crit	6	57	4371	2	crit_
dirts	6	68	2446	2	dirts
dits	5	64	5052	2	_dits
doits	6	62	2367	2	doits
drats	6	66	2837	2	drats
dribs	8	51	1506	2	dribs
dries	6	47	3367	2	dries
drifts	10	49	989	2	drifts
drips	8	54	1723	2	drips
droits	7	43	1431	2	droits
duits	6	50	2188	2	duits
edits	6	58	1903	2	edits
emits	7	54	2147	2	emits
exits	12	55	1591	2	exits
fits	7	60	4346	2	_fits
flits	8	56	2522	2	flits
frats	8	68	2967	2	frats
frets	8	55	2340	2	frets
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frit	7	70	4447	2	frit_
frites	9	49	2248	2	frites
frith	11	59	2203	2	frith
friths	12	43	1358	2	friths
fritt	8	61	2941	2	fritt
fritts	9	46	1319	2	fritts
fritz	17	60	2077	2	fritz
fruits	9	45	1249	2	fruits
gaits	6	57	2601	2	gaits
girts	6	54	2362	2	girts
gits	5	57	4459	2	_gits
grids	7	53	2139	2	grids
grifts	10	45	1168	2	grifts
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
griots	7	47	1364	2	griots
grips	8	55	2013	2	grips
grist	6	55	2987	2	grist
grists	7	47	1648	2	grists
grit	5	52	4724	2	grit_
grith	9	55	2037	2	grith
griths	10	52	1165	2	griths
grots	6	50	2585	2	grots
hits	7	55	4513	2	_hits
irids	6	64	1777	2	irids
iris	4	57	3255	2	iri_s
iritis	6	31	1373	2	iritis
its	3	55	3883	2	__its
kits	8	64	4176	2	_kits
knits	9	39	1474	2	knits
kraits	10	49	1220	2	kraits
kris	8	64	2360	2	kri_s
lits	4	62	5249	2	_lits
merits	8	3	2087	2	merits
nits	4	57	4164	2	_nits
obits	7	46	1755	2	obits
omits	7	50	1826	2	omits
orbits	8	42	1144	2	orbits
orts	4	65	3833	2	or_ts
pits	6	63	4874	2	_pits
prats	7	63	3339	2	prats
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
prims	9	54	2593	2	prims
prints	8	43	2010	2	prints
priss	7	46	2389	2	priss
quits	14	41	2235	2	quits
rats	4	62	6037	2	_rats
rets	4	53	5256	2	_rets
rias	4	55	4059	2	_rias
ribs	6	58	3302	2	_ribs
rids	5	65	3954	2	_rids
rifs	7	49	2900	2	_rifs
rifts	8	57	1864	2	_rifts
rigs	5	51	3759	2	_rigs
rims	6	59	3630	2	_rims
rins	4	61	5319	2	_rins
riots	5	49	2201	2	_riots
rips	6	62	3743	2	_rips
rite	4	58	4945	2	_rite
rites	5	44	4255	2	_rites
ritz	13	51	2998	2	_ritz
rots	4	64	5409	2	_rots
ruts	4	45	4149	2	_ruts
shits	8	47	3116	2	shits
sits	4	50	5020	2	_sits
skits	9	47	2185	2	skits
slits	5	61	2885	2	slits
snits	5	41	2483	2	snits
spits	7	44	2955	2	spits
sprits	8	51	2253	2	sprits
sris	4	54	3415	2	sri_s
suits	5	50	2805	2	suits
tits	4	61	4503	2	_tits
toits	5	53	2747	2	toits
traits	6	51	2198	2	traits
trets	5	59	2802	2	trets
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
trite	5	47	3003	2	trite
trots	5	66	2994	2	trots
twits	8	60	1579	2	twits
units	5	49	2343	2	units
waits	8	83	3352	2	waits
whits	11	59	2382	2	whits
wits	7	60	4487	2	_wits
wries	8	58	2774	2	wries
wrist	8	48	2756	2	wrist
wrists	9	54	1564	2	wrists
writ	7	55	3791	2	writ_
write	8	55	2283	2	write
writes	9	44	2033	2	writes
zits	13	60	3029	2	_zits

Search took 4 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	53800	0.080	2233637.5
2	DLD Change Limit	53800	277	3.046	17662.5
3	Display Results	277	277	0.156	1775.6
	(SQL Overall)	178691	277	3.282	54445.8