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

Here are the results of your fuzzy-string dictionary search for “riband” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

339 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
riband	9	23	962	(None)
ribald	9	20	929	1	ribald
ribands	10	20	839	1	ribands
ribband	12	4	558	1	ribband
roband	9	23	1072	1	roband
armband	12	6	598	2	armband
band	7	67	4091	2	__band
brigand	11	3	664	2	brigand
disband	11	3	824	2	disband
ligand	8	50	1129	2	ligand
proband	12	27	1024	2	proband
rainband	11	4	466	2	rainband
rand	5	58	3957	2	r__and
rebind	9	44	1693	2	rebind
reland	7	59	2043	2	reland
remand	9	56	1896	2	remand
repand	9	53	1606	2	repand
riant	5	58	3315	2	ri_ant
ribalds	10	23	667	2	ribalds
ribbands	13	4	456	2	ribbands
ribbed	11	40	1437	2	ribbed
rimland	10	3	566	2	rimland
rind	5	65	3560	2	ri__nd
ritard	7	48	1208	2	ritard
robands	10	21	986	2	robands
viand	9	5	1107	2	vi_and
aland	6	55	2641	3	_aland
and	4	72	4417	3	___and
armbands	13	5	514	3	armbands
bad	6	77	6315	3	__ba_d
bald	7	64	3290	3	__bald
ban	5	83	6684	3	__ban_
banda	8	52	2310	3	__banda
bands	8	52	3342	3	__bands
bandy	11	48	2418	3	__bandy
bane	6	52	5043	3	__bane
baned	8	54	3635	3	__baned
bang	7	48	3700	3	__bang
bani	6	53	3496	3	__bani
bank	10	58	3575	3	__bank
bans	6	65	5514	3	__bans
bard	7	56	4886	3	__bard
baud	7	49	2842	3	__baud
bawd	10	55	2084	3	__bawd
bend	7	64	3526	3	__bend
bibbed	10	47	1234	3	bibbed
bind	7	62	3451	3	__bind
bland	8	53	2045	3	_bland
bond	7	53	3436	3	__bond
brand	8	51	2449	3	_brand
briard	9	43	1129	3	bri_ard
bribed	11	53	1284	3	brib_ed
bribing	12	31	1104	3	bribing
brigands	12	4	562	3	brigands
brisant	9	3	1268	3	brisant
browband	16	4	388	3	browband
bund	7	55	3066	3	__bund
cabana	10	39	1356	3	cabana
cribbed	14	40	766	3	cribbed
demand	10	43	1425	3	demand
desand	8	48	1263	3	desand
dibbed	12	47	1347	3	dibbed
disbands	12	3	735	3	disbands
divan	9	61	1484	3	divan_
divans	10	46	1239	3	divans
diwan	9	57	1255	3	diwan_
diwans	10	51	1037	3	diwans
dribbed	13	32	675	3	dribbed
dryland	12	5	430	3	dryland
eland	6	58	2039	3	_eland
embank	14	34	655	3	embank
errand	7	5	879	3	errand
expand	16	23	657	3	expand
fibbed	14	40	1155	3	fibbed
fiend	9	53	1298	3	fi_end
find	8	75	3260	3	fi__nd
fricando	14	4	321	3	fricando
friend	10	38	893	3	fri_end
furibund	14	4	204	3	furibund
giant	6	54	3059	3	gi_ant
gibbed	12	45	1235	3	gibbed
gibed	9	62	1596	3	gib_ed
gibing	10	37	1235	3	gibing
gitano	7	3	804	3	gitano
gland	7	52	1771	3	_gland
goban	8	44	1407	3	goban_
gobang	10	37	670	3	gobang
gobans	9	44	1204	3	gobans
grand	7	51	2269	3	_grand
grind	7	59	1756	3	gri__nd
hairband	14	4	457	3	hairband
hand	8	68	3371	3	__hand
hatband	13	4	682	3	hatband
hind	8	55	2975	3	hi__nd
husband	13	4	565	3	husband
inane	5	28	2034	3	_inane
inland	7	3	1031	3	inland
island	7	3	853	3	island
jibbed	18	48	1056	3	jibbed
jibed	15	51	1416	3	jib_ed
jibing	16	37	962	3	jibing
jihad	16	3	591	3	jiha_d
kiang	10	48	1135	3	ki_ang
kind	9	61	2855	3	ki__nd
land	5	63	3731	3	__land
liana	5	39	1589	3	li_ana
liane	5	47	2066	3	li_ane
liang	6	49	1441	3	li_ang
liard	6	54	1859	3	li_ard
ligan	6	79	2028	3	ligan_
ligands	9	43	898	3	ligands
ligans	7	68	1773	3	ligans
liman	7	59	2160	3	liman_
limans	8	48	1630	3	limans
litany	9	3	905	3	litany
lizard	16	36	923	3	lizard
midland	11	3	661	3	midland
mind	7	54	3438	3	mi__nd
misadd	10	3	716	3	misadd
misbind	12	5	827	3	misbind
misbrand	13	4	641	3	misbrand
moribund	13	4	253	3	moribund
nibbed	11	43	1190	3	nibbed
nicad	8	3	1261	3	nica_d
ordinand	10	4	410	3	ordinand
oribatid	11	4	546	3	oribatid
origan	7	3	1069	3	origan_
origans	8	3	997	3	origans
pian	6	61	3609	3	pi_an_
piano	7	61	1871	3	pi_ano
pians	7	51	2696	3	pi_ans
pibal	9	52	1732	3	piba_l
pibals	10	38	1308	3	pibals
piebald	12	4	550	3	piebald
pinang	9	26	1159	3	pinang
pirana	8	7	1326	3	pirana
prebend	12	31	944	3	prebend
prebind	12	38	1064	3	prebind
probands	13	22	839	3	probands
probang	12	27	838	3	probang
rabat	7	28	3222	3	raba_t
rabato	8	34	1326	3	rabato
rabats	8	31	1622	3	rabats
rabid	8	45	2078	3	rab_id
rad	4	76	6200	3	r__a_d
radicand	12	11	528	3	radicand
raid	5	52	4307	3	r__aid
rainbands	12	4	419	3	rainbands
ran	3	82	6662	3	r__an_
rands	6	59	3045	3	r__ands
randy	9	50	2208	3	r__andy
rang	5	69	3916	3	r__ang
rani	4	66	4011	3	r__ani
ranid	6	64	2933	3	r__anid
rank	8	51	3553	3	r__ank
rant	4	58	6468	3	r__ant
ratan	5	37	2266	3	ratan_
ratans	6	38	1937	3	ratans
ratany	9	34	1187	3	ratany
read	5	59	4253	3	r_ea_d
readd	7	46	1713	3	r_eadd
rebait	8	3	2040	3	rebait
rebar	7	54	2019	3	reba_r
rebars	8	40	1983	3	rebars
rebate	8	44	2411	3	rebate
rebated	10	36	1970	3	rebated
rebato	8	37	1468	3	rebato
rebid	8	51	2136	3	reb_id
rebinds	10	45	1187	3	rebinds
reblend	10	3	665	3	reblend
reboant	9	3	1509	3	reboant
reboard	10	3	1076	3	reboard
rebound	10	5	858	3	rebound
rebred	9	58	1635	3	rebred
recane	8	30	2287	3	recane
recaned	10	28	1720	3	recaned
recant	8	32	2868	3	recant
redan	6	61	2501	3	redan_
redans	7	54	2102	3	redans
refind	10	47	1707	3	refind
refund	10	48	1030	3	refund
regard	8	52	1577	3	regard
rehang	10	3	982	3	rehang
relaid	7	55	1844	3	relaid
relands	8	52	1488	3	relands
relend	7	61	1645	3	relend
reman	7	57	3015	3	reman_
remands	10	49	1488	3	remands
remans	8	48	2300	3	remans
remend	9	52	1655	3	remend
remind	9	48	1979	3	remind
rend	5	61	3657	3	r__end
repaid	9	47	1632	3	repaid
reran	5	73	2910	3	reran_
resaid	7	45	1708	3	resaid
resend	7	50	1677	3	resend
retard	7	50	1893	3	retard
rewan	8	56	2366	3	rewan_
reward	10	60	1763	3	reward
rewind	10	47	1588	3	rewind
ria	3	67	4550	3	ri_a__
rial	4	59	3809	3	ri_a_l
rials	5	50	2667	3	ri_als
rias	4	55	4059	3	ri_a_s
riata	5	46	1802	3	ri_ata
rib	5	68	4803	3	rib___
ribaldly	14	4	281	3	ribaldly
ribaldry	14	4	170	3	ribaldry
ribber	10	35	1549	3	ribber
ribbing	12	31	1195	3	ribbing
ribbon	10	3	653	3	ribbon
ribboned	13	4	397	3	ribboned
ribbons	11	3	625	3	ribbons
ribbony	14	4	354	3	ribbony
ribby	12	41	968	3	rib_by
ribes	7	55	3017	3	rib_es
ribier	8	44	1423	3	ribier
riblet	8	42	2244	3	riblet
ribose	8	3	989	3	ribose
ribs	6	58	3302	3	rib__s
riced	8	58	2554	3	ri_ced
ricin	7	46	2021	3	ricin_
ricing	9	48	2276	3	ricing
ricins	8	36	1870	3	ricins
ricked	13	65	2362	3	ricked
rid	4	67	5462	3	ri___d
ridded	9	36	1512	3	ridded
rident	7	5	2019	3	rident
ridged	9	40	1421	3	ridged
riding	8	43	2596	3	riding
riffed	13	38	1156	3	riffed
rifled	10	41	1500	3	rifled
rifted	10	41	1531	3	rifted
rigged	9	45	1740	3	rigged
rigid	7	9	1389	3	ri_gid
riled	6	58	3325	3	ri_led
riling	7	42	2797	3	riling
rilled	7	45	2565	3	rilled
rimed	8	48	2637	3	ri_med
riming	9	33	2222	3	riming
rimlands	11	4	524	3	rimlands
rimmed	11	48	1230	3	rimmed
rin	3	66	6318	3	ri__n_
rinded	8	44	1898	3	rinded
rinds	6	48	2614	3	ri__nds
rindy	9	57	1739	3	ri__ndy
ring	5	65	4115	3	ri__ng
ringed	8	46	2384	3	ringed
rink	8	77	3699	3	ri__nk
rins	4	61	5319	3	ri__ns
rinsed	7	50	1635	3	rinsed
rioted	7	34	1637	3	rioted
riped	8	52	2643	3	ri_ped
ripen	7	56	1926	3	ripen_
ripened	10	3	820	3	ripened
ripens	8	50	1217	3	ripens
riping	9	38	2161	3	riping
ripped	11	44	1901	3	ripped
risen	5	46	2188	3	risen_
rising	7	40	2588	3	rising
risked	11	55	1463	3	risked
ritards	8	43	994	3	ritards
rivage	10	3	884	3	rivage
rival	8	52	1650	3	riva_l
rivaled	11	3	893	3	rivaled
rivals	9	42	1318	3	rivals
rived	9	48	2561	3	ri_ved
riven	8	51	2162	3	riven_
riving	10	45	2142	3	riving
riyal	8	44	1343	3	riya_l
riyals	9	41	1108	3	riyals
road	5	63	3211	3	r_oa_d
roan	4	72	3420	3	r_oan_
roans	5	49	2644	3	r_oans
robalo	8	3	893	3	robalo
robbed	11	34	1519	3	robbed
robed	8	53	2373	3	rob_ed
robin	7	48	2028	3	robin_
robing	9	36	1800	3	robing
robins	8	36	1745	3	robins
roman	7	54	2482	3	roman_
romano	8	49	1294	3	romano
romans	8	46	2024	3	romans
rotund	7	3	729	3	rotund
round	6	43	1843	3	r_ound
rowan	8	54	1873	3	rowan_
rowans	9	57	1534	3	rowans
ruana	5	3	1242	3	r_uana
rubace	10	3	1017	3	rubace
rubati	8	29	969	3	rubati
rubato	8	31	968	3	rubato
rubbed	11	45	1508	3	rubbed
rubied	9	43	1241	3	rubied
rumbaed	12	28	749	3	rumbaed
rurban	8	4	904	3	rurban_
rynd	8	64	1410	3	r__ynd
sand	5	53	3847	3	__sand
saraband	11	4	619	3	saraband
sideband	12	4	502	3	sideband
siganid	9	4	720	3	siganid
silane	6	27	1805	3	silane
soland	7	51	1504	3	soland
stand	6	59	2328	3	_stand
strand	7	45	1482	3	strand
tabanid	10	4	733	3	tabanid
tabard	9	3	1333	3	tabard
tisane	6	3	1157	3	tisane
titan	5	33	1817	3	titan_
titans	6	34	1491	3	titans
trainband	12	4	312	3	trainband
triad	6	52	1772	3	tri_a_d
tribade	10	3	729	3	tribade
tribal	8	6	1113	3	triba_l
tribals	9	6	1075	3	tribals
tribune	9	4	557	3	tribune
troland	8	3	754	3	troland
unban	7	21	1433	3	unban_
unbans	8	19	1262	3	unbans
unbend	9	26	977	3	unbend
unbind	9	30	1143	3	unbind
unhand	10	4	1038	3	unhand
upbind	11	24	631	3	upbind
upland	9	3	886	3	upland
urban	7	20	1386	3	urban_
urbane	8	22	1138	3	urbane
viands	10	4	781	3	vi_ands
vibrant	12	4	1039	3	vibrant
visaed	10	41	1050	3	visaed
visard	10	39	1012	3	visard
vizard	19	45	885	3	vizard
wand	8	58	3388	3	__wand
wideband	15	4	445	3	wideband
wigan	9	51	1439	3	wigan_
wigans	10	45	1170	3	wigans
wind	8	55	3385	3	wi__nd
witan	8	38	1650	3	witan_
witans	9	34	1293	3	witans
wizard	19	37	771	3	wizard
wristband	15	4	210	3	wristband

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	339	4.843	23274.0
3	Display Results	339	339	0.110	3081.8
	(SQL Overall)	178691	339	5.093	35085.6