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

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

310 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
brie	6	58	3790	(None)
brae	6	56	3911	1	brae
bree	6	72	4126	1	bree
bribe	9	48	2078	1	bribe
bride	8	64	2553	1	bride
brief	10	54	2260	1	brief
brier	7	45	2740	1	brier
bries	7	49	4215	1	bries
brig	7	65	2803	1	brig
brim	8	56	2937	1	brim
brin	6	70	3819	1	brin
brine	7	51	3227	1	brine
brio	6	54	3249	1	brio
bris	6	55	3961	1	bris
brit	6	63	5015	1	brit
abri	6	55	2221	2	abri_
abris	7	57	2260	2	abris
aerie	5	46	3460	2	aerie
amie	6	63	3985	2	amie
are	3	78	7457	2	ar_e
aria	4	62	4542	2	aria
arid	5	76	4271	2	arid
ariel	5	52	2897	2	ariel
aril	4	58	4302	2	aril
arise	5	64	3643	2	arise
arse	4	65	3927	2	arse
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bail	6	50	4280	2	bail
bait	6	65	5600	2	bait
baize	16	47	1739	2	baize
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
barbe	9	53	2828	2	barbe
barbie	10	50	1835	2	barbie
barde	8	53	3077	2	barde
bare	6	54	6052	2	bare
barge	8	56	3102	2	barge
baric	9	61	2569	2	baric
barite	8	42	2481	2	barite
barmie	10	38	1639	2	barmie
barre	7	59	2954	2	barre
barye	10	50	2149	2	barye
base	6	48	4702	2	base
bate	6	65	5242	2	bate
be	4	79	4894	2	b__e
bee	5	62	6240	2	b_ee
beige	8	15	1538	2	beige
belie	7	56	3038	2	belie
bene	6	64	3949	2	bene
berime	10	53	1733	2	berime
berme	9	60	2294	2	berme
bi	4	80	4647	2	b_i_
bib	7	70	4594	2	b_ib
bice	8	62	3556	2	bice
bid	6	77	5181	2	b_id
bide	7	60	4150	2	bide
bier	6	55	3183	2	b_ier
big	6	73	4572	2	b_ig
bike	10	65	3260	2	bike
bikie	11	39	1588	2	bikie
bile	6	61	4718	2	bile
bin	5	66	5864	2	b_in
bine	6	66	5086	2	bine
bio	5	78	4608	2	b_io
bird	7	61	2832	2	bird
birdie	9	40	1378	2	birdie
birk	10	63	2686	2	birk
birkie	12	41	1013	2	birkie
birl	6	58	3047	2	birl
birle	7	50	2363	2	birle
biro	6	61	3121	2	biro
birr	6	60	2236	2	birr
birse	7	45	1740	2	birse
bis	5	68	6066	2	b_is
bise	6	64	3710	2	bise
bit	5	70	7090	2	b_it
bite	6	65	4700	2	bite
biz	14	79	3936	2	b_iz
bize	15	59	2629	2	bize
blae	6	61	3464	2	blae
blin	6	72	2817	2	blin
blip	8	83	2277	2	blip
blite	7	62	2535	2	blite
blue	6	53	2846	2	blue
bode	7	58	3875	2	bode
bogie	8	95	2410	2	bogie
boil	6	63	3518	2	boil
boite	7	44	2632	2	boite
bole	6	64	4869	2	bole
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
boric	9	80	2422	2	boric
boride	9	4	1590	2	boride
borne	7	79	2679	2	borne
bra	5	63	3946	2	br_a
brace	9	56	2927	2	brace
brad	7	52	3434	2	brad
braes	7	57	3505	2	braes
brag	7	52	2972	2	brag
braid	8	58	2226	2	braid
brail	7	55	2555	2	brail
brain	7	62	2938	2	brain
braise	8	43	1875	2	braise
braize	17	41	1311	2	braize
brake	11	60	2534	2	brake
bran	6	57	4038	2	bran
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
brave	10	49	2550	2	brave
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
braze	16	54	2345	2	braze
bred	7	51	3097	2	bred
brede	8	55	2050	2	brede
breed	8	55	2669	2	breed
brees	7	56	3255	2	brees
bren	6	56	2956	2	bren
breve	10	53	1705	2	breve
brew	9	50	2356	2	brew
briar	7	57	1815	2	briar
bribed	11	53	1284	2	bribed
bribee	10	43	1636	2	bribee
briber	10	47	1405	2	briber
bribes	10	59	1853	2	bribes
brick	13	46	1815	2	brick
brides	9	44	2351	2	brides
bridge	10	37	1188	2	bridge
bridle	9	41	1546	2	bridle
briefs	11	55	1007	2	briefs
briers	8	53	1973	2	briers
briery	11	45	1077	2	briery
brigs	8	58	2322	2	brigs
brill	7	48	1995	2	brill
brims	9	47	2162	2	brims
brined	9	51	1841	2	brined
briner	8	45	1904	2	briner
brines	8	50	2885	2	brines
bring	8	55	2850	2	bring
brink	11	61	2200	2	brink
brins	7	55	3397	2	brins
briny	10	47	1966	2	briny
brios	7	47	2572	2	brios
brises	8	49	2761	2	brises
brisk	11	56	1598	2	brisk
briss	7	58	2427	2	briss
brith	10	49	2437	2	brith
brits	7	64	3308	2	brits
britt	7	57	3223	2	britt
bro	5	62	3660	2	br_o
broil	7	49	1822	2	broil
broke	11	60	1978	2	broke
brome	9	44	2197	2	brome
broo	6	51	2982	2	broo
bros	6	56	3566	2	bros
brose	7	52	2703	2	brose
brow	9	72	2844	2	brow
brr	5	69	2192	2	br_r
brrr	6	53	1229	2	brrr
bruin	7	58	1833	2	bruin
bruise	8	34	1287	2	bruise
bruit	7	61	2672	2	bruit
brume	9	58	1798	2	brume
brut	6	65	3796	2	brut
brute	7	53	2178	2	brute
brux	13	63	1527	2	brux
burdie	9	36	1502	2	burdie
buried	9	48	2237	2	buried
burier	8	43	2465	2	burier
buries	8	46	3327	2	buries
burin	7	56	2606	2	burin
burke	11	51	2276	2	burke
burnie	8	37	1541	2	burnie
burse	7	55	2725	2	burse
bute	6	67	3967	2	bute
bye	8	61	3459	2	b_ye
byre	9	50	2385	2	byre
byrnie	11	34	857	2	byrnie
byte	9	65	2181	2	byte
cire	6	58	3637	2	cire
crib	8	63	2358	2	crib
cried	8	46	2429	2	cried
crier	7	47	2446	2	crier
cries	7	54	3840	2	cries
crime	9	48	2269	2	crime
cripe	9	55	2114	2	cripe
cris	6	62	3343	2	cris
crit	6	57	4371	2	crit
curie	7	45	3304	2	curie
die	4	67	5965	2	_die
dire	5	66	4414	2	dire
dree	5	66	3832	2	dree
drib	7	68	2326	2	drib
dried	7	53	2138	2	dried
drier	6	44	2396	2	drier
dries	6	47	3367	2	dries
drip	7	62	2395	2	drip
drive	9	53	1800	2	drive
eerie	5	52	2853	2	eerie
ere	3	63	5277	2	er_e
erne	4	67	2743	2	erne
eyrie	8	81	1783	2	eyrie
fie	6	71	5244	2	_fie
fire	7	62	4559	2	fire
frae	7	53	3047	2	frae
free	7	59	4018	2	free
fried	9	53	2291	2	fried
frier	8	52	2584	2	frier
fries	8	55	3560	2	fries
frig	8	54	2450	2	frig
frise	8	53	2245	2	frise
frit	7	70	4447	2	frit
friz	16	63	2434	2	friz
froe	7	53	2999	2	froe
gie	4	71	4954	2	_gie
gree	5	66	4156	2	gree
grid	6	58	2961	2	grid
gride	7	52	2358	2	gride
grief	9	53	1978	2	grief
grig	6	54	2477	2	grig
grim	7	69	2942	2	grim
grime	8	50	2132	2	grime
grin	5	57	3372	2	grin
grip	7	61	2702	2	grip
gripe	8	46	2296	2	gripe
grit	5	52	4724	2	grit
grue	5	58	2571	2	grue
hie	6	76	5270	2	_hie
hire	7	55	3896	2	hire
ire	3	69	4317	2	ir_e
irid	5	59	2717	2	irid
iris	4	57	3255	2	iris
kris	8	64	2360	2	kris
kyrie	12	37	1290	2	kyrie
lie	3	82	6452	2	_lie
lire	4	78	4529	2	lire
mire	6	67	4823	2	mire
oorie	5	30	2636	2	oorie
ore	3	66	6183	2	or_e
oriel	5	49	2042	2	oriel
orle	4	56	3046	2	orle
ourie	5	40	2730	2	ourie
pie	5	54	5740	2	_pie
plie	6	51	2739	2	plie
pree	6	70	4473	2	pree
price	9	37	2541	2	price
pride	8	47	2473	2	pride
pried	8	44	2686	2	pried
prier	7	50	2776	2	prier
pries	7	43	3953	2	pries
prig	7	59	2487	2	prig
prim	8	51	3220	2	prim
prime	9	65	2560	2	prime
prise	7	46	3261	2	prise
prize	16	47	1894	2	prize
re	2	61	5374	2	_r_e
ree	3	79	7407	2	_ree
rei	3	56	4725	2	_rei
ria	3	67	4550	2	_ria
rib	5	68	4803	2	_rib
rice	6	49	4291	2	_rice
rid	4	67	5463	2	_rid
ride	5	59	4513	2	_ride
riel	4	64	3238	2	_riel
rif	6	59	5156	2	_rif
rife	7	46	3232	2	_rife
rig	4	67	4812	2	_rig
rile	4	56	5053	2	_rile
rim	5	60	5227	2	_rim
rime	6	51	3888	2	_rime
rin	3	66	6318	2	_rin
rip	5	68	5130	2	_rip
ripe	6	60	3892	2	_ripe
rise	4	59	4523	2	_rise
rite	4	58	4945	2	_rite
rive	7	55	3772	2	_rive
roe	3	68	6108	2	_roe
rue	3	55	4926	2	_rue
rye	6	60	3254	2	_rye
sire	4	61	5041	2	sire
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
tie	3	65	5753	2	_tie
tire	4	61	4335	2	tire
tree	4	77	4581	2	tree
tribe	7	44	2027	2	tribe
trice	7	51	2749	2	trice
tried	6	50	2691	2	tried
trier	5	43	2853	2	trier
tries	5	57	4281	2	tries
trig	5	55	2816	2	trig
trike	9	53	2016	2	trike
trim	6	53	2952	2	trim
trine	5	47	3460	2	trine
trio	4	52	3334	2	trio
trip	6	68	3039	2	trip
tripe	7	54	2538	2	tripe
trite	5	47	3003	2	trite
true	4	67	2585	2	true
urge	5	47	2242	2	urge
uric	6	36	2494	2	uric
urine	5	50	2660	2	urine
vie	6	54	4763	2	_vie
wire	7	58	3981	2	wire
wried	9	55	1856	2	wried
wrier	8	45	2175	2	wrier
wries	8	58	2774	2	wries
writ	7	55	3791	2	writ
write	8	55	2283	2	write

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	29872	0.593	301333.9
2	DLD Change Limit	29872	310	2.236	13359.6
3	Display Results	310	310	0.483	641.8
	(SQL Overall)	178691	310	3.312	53952.6