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

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

243 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
biners	8	50	2363	(None)
biders	9	48	2280	1	biders
biers	7	62	2522	1	bi_ers
bikers	12	45	1755	1	bikers
binders	10	39	2074	1	binders
biner	7	59	3069	1	biner_
bines	7	69	4679	1	bine_s
bingers	10	45	1999	1	bingers
biters	8	39	2524	1	biters
boners	8	48	2543	1	boners
briners	9	43	1563	1	briners
diners	7	55	2595	1	diners
liners	6	54	2885	1	liners
miners	8	41	2663	1	miners
abiders	10	40	1108	2	abiders
aiders	7	45	2463	2	aiders
aimers	8	46	2191	2	aimers
airers	6	49	2231	2	airers
aivers	9	48	2232	2	aivers
aliners	7	47	1772	2	aliners
bailers	9	42	2135	2	bailers
baiters	9	46	1930	2	baiters
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
banders	10	43	2456	2	banders
banes	7	49	4558	2	bane_s
bangers	10	40	2035	2	bangers
bankers	13	39	1909	2	bankers
banners	9	40	1871	2	banners
banters	9	46	2311	2	banters
beers	7	56	2839	2	b_eers
benders	10	40	2106	2	benders
benes	7	55	3623	2	bene_s
bibbers	10	39	1135	2	bibbers
biceps	12	44	771	2	biceps
bices	9	50	2996	2	bice_s
bickers	15	43	1655	2	bickers
bidders	11	40	1231	2	bidders
bider	8	57	2837	2	bider_
bides	8	55	3677	2	bide_s
bidets	9	52	1553	2	bidets
bier	6	55	3183	2	bi_er_
bigness	10	3	819	2	bigness
biker	11	60	2256	2	biker_
bikes	11	75	2947	2	bike_s
biles	7	55	4214	2	bile_s
bilkers	13	47	1186	2	bilkers
billers	9	47	2083	2	billers
binary	11	3	1222	2	binary
binder	9	44	2287	2	binder_
bindery	13	45	983	2	bindery
bindis	9	46	1458	2	bindis
binds	8	66	2747	2	bin_ds
bine	6	66	5086	2	bine__
binger	9	49	2345	2	binger_
binges	9	39	2312	2	binges
bingos	9	55	1479	2	bingos
binits	8	57	1667	2	binits
binocs	10	3	992	2	binocs
bins	6	65	4825	2	bin__s
bints	7	61	3018	2	bin_ts
bipeds	11	45	805	2	bipeds
birders	10	39	1326	2	birders
birlers	9	38	1300	2	birlers
birrs	7	49	1710	2	bi_rrs
bises	7	54	3562	2	bise_s
bisters	9	39	2261	2	bisters
biter	7	50	3003	2	biter_
bites	7	56	4117	2	bite_s
bitters	9	49	2036	2	bitters
bizes	16	59	2366	2	bize_s
blinders	11	39	1114	2	blinders
blinkers	14	38	850	2	blinkers
boilers	9	34	1706	2	boilers
bonders	10	41	2066	2	bonders
boner	7	51	3308	2	boner_
bones	7	64	4653	2	bone_s
bonkers	13	40	1530	2	bonkers
borers	8	51	2268	2	borers
bowers	11	55	2370	2	bowers
boxers	15	50	1348	2	boxers
bribers	11	41	1150	2	bribers
briers	8	53	1973	2	briers
briner	8	45	1904	2	briner_
brines	8	50	2885	2	brine_s
bringers	11	28	1107	2	bringers
bunkers	13	37	1595	2	bunkers
bunters	9	47	1712	2	bunters
burners	9	41	1567	2	burners
buyers	11	45	1100	2	buyers
byliners	13	3	475	2	byliners
caners	8	46	2920	2	caners
ciders	9	46	2009	2	ciders
cinders	10	46	1776	2	cinders
cines	7	52	3968	2	cine_s
citers	8	50	2298	2	citers
coiners	9	36	2075	2	coiners
dicers	9	47	2074	2	dicers
dikers	11	44	1879	2	dikers
dimers	9	43	2109	2	dimers
dinars	7	54	1756	2	dinars
diner	6	56	3290	2	diner_
dinero	7	56	1264	2	dinero
dineros	8	38	1233	2	dineros
dines	6	64	4915	2	dine_s
dingers	9	43	2138	2	dingers
dinners	8	39	1544	2	dinners
divers	10	50	2496	2	divers
eiders	7	43	2136	2	eiders
fibers	11	47	1752	2	fibers
fifers	12	54	1492	2	fifers
filers	9	46	2372	2	filers
finders	11	37	1787	2	finders
finer	8	54	3156	2	finer_
finery	12	45	1289	2	finery
fines	8	66	4426	2	fine_s
fingers	11	34	1843	2	fingers
firers	9	49	2268	2	firers
fivers	12	44	2092	2	fivers
fixers	16	51	1298	2	fixers
gainers	8	42	1459	2	gainers
gibers	9	51	1466	2	gibers
gingers	9	41	1864	2	gingers
ginners	8	43	1422	2	ginners
givers	10	48	1771	2	givers
goners	7	44	2017	2	goners
hiders	10	49	1965	2	hiders
hikers	13	50	1435	2	hikers
hinders	11	37	1850	2	hinders
hingers	11	34	2021	2	hingers
hinters	10	37	1958	2	hinters
hirers	9	45	1806	2	hirers
honers	9	43	2497	2	honers
inert	5	32	3437	2	_inert
inerts	6	45	1702	2	_inerts
infers	9	36	1544	2	_infers
inkers	10	40	1883	2	_inkers
inners	6	39	1935	2	inners
inters	6	43	2805	2	_inters
jibers	15	59	1288	2	jibers
jinkers	18	35	1181	2	jinkers
jivers	16	45	1564	2	jivers
joiners	14	42	1157	2	joiners
kiers	9	53	2009	2	ki_ers
kines	9	50	3913	2	kine_s
kiters	10	52	1859	2	kiters
libers	8	47	2144	2	libers
liers	5	51	3040	2	li_ers
lifers	9	56	1784	2	lifers
ligers	7	50	2204	2	ligers
likers	10	46	2091	2	likers
limners	9	33	1156	2	limners
linens	6	48	1839	2	linens
liner	5	59	3892	2	liner_
lines	5	70	5457	2	line_s
lingers	8	42	2330	2	lingers
linkers	11	43	1771	2	linkers
linters	7	38	2263	2	linters
liters	6	54	2988	2	liters
livers	9	49	2782	2	livers
loners	6	42	2581	2	loners
milers	8	46	2516	2	milers
mimers	10	55	2018	2	mimers
mincers	11	37	1485	2	mincers
minders	10	37	2012	2	minders
miner	7	69	3354	2	miner_
mines	7	56	5195	2	mine_s
minors	8	51	1710	2	minors
minters	9	38	2247	2	minters
misers	8	50	2570	2	misers
miters	8	43	2878	2	miters
mixers	15	45	1356	2	mixers
nines	5	59	3734	2	nine_s
niters	6	46	2421	2	niters
oilers	6	47	2119	2	oilers
owners	9	42	1070	2	owners
piers	7	59	2633	2	pi_ers
pikers	12	47	1739	2	pikers
pincers	11	39	1650	2	pincers
pinders	10	37	2047	2	pinders
pinery	11	52	1429	2	pinery
pines	7	60	4886	2	pine_s
pingers	10	40	2074	2	pingers
pinkers	13	41	1860	2	pinkers
pinners	9	35	1860	2	pinners
pipers	10	43	1866	2	pipers
ricers	8	41	2099	2	ricers
riders	7	41	2390	2	riders
rimers	8	45	2255	2	rimers
ringers	8	39	2295	2	ringers
rinsers	7	38	1574	2	rinsers
risers	6	46	2478	2	risers
rivers	9	46	2654	2	rivers
ruiners	7	42	1302	2	ruiners
seiners	7	42	1927	2	seiners
shiners	10	40	1594	2	shiners
signers	8	47	1444	2	signers
sines	5	59	5482	2	sine_s
sinews	9	42	1062	2	sinews
singers	8	38	2470	2	singers
sinkers	11	36	1854	2	sinkers
sinners	7	40	1902	2	sinners
sinters	7	40	2408	2	sinters
sivers	9	53	2415	2	sivers
sizers	15	52	1581	2	sizers
tiers	5	55	2652	2	ti_ers
tigers	7	56	1651	2	tigers
tilers	6	35	2350	2	tilers
timers	8	44	2099	2	timers
tinders	8	42	1917	2	tinders
tineas	6	46	1648	2	tineas
tines	5	48	4842	2	tine_s
tinkers	11	35	1714	2	tinkers
tinners	7	37	1731	2	tinners
tinters	7	42	2111	2	tinters
titers	6	45	2641	2	titers
toners	6	41	2800	2	toners
tuners	6	44	1734	2	tuners
twiners	10	45	963	2	twiners
veiners	10	41	1252	2	veiners
viers	8	56	2195	2	vi_ers
vinery	12	49	1260	2	vinery
vines	8	51	3764	2	vine_s
vipers	11	49	1453	2	vipers
vivers	12	47	1736	2	vivers
weiners	10	39	1306	2	weiners
whiners	13	40	1157	2	whiners
wieners	10	32	1248	2	wieners
wincers	12	34	1536	2	wincers
winders	11	37	2126	2	winders
winery	12	50	1428	2	winery
wines	8	55	4686	2	wine_s
wingers	11	39	2148	2	wingers
winkers	14	35	1711	2	winkers
winners	10	43	1691	2	winners
winters	10	37	2048	2	winters
wipers	11	54	1608	2	wipers
wirers	9	46	1789	2	wirers
wivers	12	53	2080	2	wivers
zinebs	17	60	680	2	zinebs
zines	14	52	3265	2	zine_s
zingers	17	35	1485	2	zingers
zoners	15	51	1599	2	zoners

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	82551	0.330	541487.9
2	DLD Change Limit	82551	243	2.576	32046.2
3	Display Results	243	243	0.080	3037.5
	(SQL Overall)	178691	243	2.986	59842.9