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

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

328 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
bollox	15	4	874	(None)
bollix	15	3	805	1	bollix
ballon	8	41	1749	2	ballon
ballot	8	46	2409	2	ballot
bellow	11	42	1335	2	bellow
billon	8	37	1383	2	billon
billow	11	41	1122	2	billow
boll	6	56	3475	2	boll__
bolled	9	47	2265	2	bolled
bolloxed	18	3	447	2	bolloxed
bolloxes	17	3	683	2	bolloxes
bolls	7	55	3131	2	boll_s
bolo	6	55	3595	2	bo_lo_
bolos	7	55	3137	2	bo_los
bolson	8	4	1068	2	bolson
collop	10	73	1231	2	collop
dollop	9	25	936	2	dollop
follow	12	40	1035	2	follow
hollo	8	48	2216	2	hollo_
holloa	9	49	1482	2	holloa
holloo	9	44	1525	2	holloo
hollos	9	53	2063	2	hollos
hollow	12	42	1266	2	hollow
lollop	8	23	878	2	lollop
pollex	15	37	1116	2	pollex
volvox	19	3	336	2	volvox
abolla	8	4	1019	3	aboll_a
abollae	9	3	694	3	abollae
allod	6	44	1838	3	_allod
allot	5	49	3387	3	_allot
allow	8	54	2066	3	_allow
alloy	8	55	1997	3	_alloy
apollo	8	3	718	3	apollo_
apollos	9	4	679	3	apollos
bailor	8	34	1260	3	bailor
balboa	10	38	996	3	balboa
ball	6	60	4332	3	ball__
ballad	9	43	1532	3	ballad
balled	9	49	2689	3	balled
baller	8	38	2520	3	baller
ballet	8	47	3397	3	ballet
ballons	9	39	1696	3	ballons
balloon	9	37	1143	3	balloon
ballots	9	41	1603	3	ballots
balls	7	62	3641	3	ball_s
ballsy	11	50	887	3	ballsy
bally	10	55	3010	3	ball_y
barlow	11	29	1142	3	barlow
beclog	11	3	686	3	beclog
bell	6	62	3718	3	bell__
bellboy	14	4	512	3	bellboy
belle	7	58	2783	3	bell_e
belled	9	46	2618	3	belled
belles	8	53	2599	3	belles
bellhop	14	4	505	3	bellhop
bellows	12	43	1330	3	bellows
bells	7	64	3216	3	bell_s
belly	10	46	2549	3	bell_y
belon	7	39	2411	3	b_elon
below	10	46	1719	3	b_elow
biflex	18	3	495	3	biflex
bilbo	9	55	1361	3	bilbo_
bilboa	10	36	784	3	bilboa
bilbos	10	50	1120	3	bilbos
bill	6	72	3994	3	bill__
billed	9	42	2490	3	billed
biller	8	49	2348	3	biller
billet	8	60	2972	3	billet
billie	8	50	1917	3	billie
billion	9	22	1217	3	billion
billons	9	30	1336	3	billons
billows	12	36	1129	3	billows
billowy	15	36	690	3	billowy
bills	7	56	3286	3	bill_s
billy	10	55	2536	3	bill_y
blob	8	60	2709	3	b__lob
bloc	8	50	2327	3	b__loc
blog	7	57	2382	3	b__log
blood	8	53	1952	3	b_lood
bloom	9	59	1897	3	b_loom
bloop	9	61	1615	3	b_loop
blot	6	58	4232	3	b__lot
blow	9	58	2719	3	b__low
boffo	13	60	1037	3	boffo_
boffos	14	56	819	3	boffos
bogle	8	58	2168	3	bogl_e
bogles	9	50	2083	3	bogles
boho	9	69	2332	3	bo_ho_
bohos	10	56	1825	3	bo_hos
boil	6	63	3518	3	boil__
boiled	9	50	2095	3	boiled
boiler	8	43	1927	3	boiler
boiloff	15	4	378	3	boiloff
boils	7	54	2719	3	boil_s
bola	6	60	3556	3	bo_l_a
bolar	7	51	2347	3	bo_lar
bolas	7	47	3376	3	bo_las
bold	7	54	3281	3	bo_l_d
bolder	9	48	2093	3	bolder
boldly	12	39	942	3	boldly
bolds	8	58	2528	3	bo_lds
bole	6	64	4869	3	bo_l_e
bolero	8	4	1209	3	bolero
boleros	9	3	1029	3	boleros
boles	7	54	4860	3	bo_les
bolete	8	5	1961	3	bolete
boleti	8	4	1340	3	boleti
bolide	9	5	1556	3	bolide
bollard	10	32	1050	3	bollard
bolling	10	38	2088	3	bolling
bollixed	18	3	448	3	bollixed
bollixes	17	4	720	3	bollixes
bollocks	16	3	650	3	bollocks
bolloxing	19	4	477	3	bollox~~ing~~
bollworm	15	4	480	3	bollworm
bolshy	14	4	488	3	bolshy
bolsons	9	6	948	3	bolsons
bolt	6	62	5417	3	bo_l_t
bolted	9	46	1780	3	bolted
bolter	8	39	2075	3	bolter
bolts	7	62	3211	3	bo_lts
bolus	7	91	2554	3	bo_lus
bombax	19	3	575	3	bombax
bombyx	22	3	269	3	bombyx
bonbon	10	3	1007	3	bonbon
bongo	8	57	2094	3	bongo_
bongos	9	53	1665	3	bongos
boo	5	81	6366	3	bo__o_
boob	8	59	3258	3	bo__ob
booboo	10	3	946	3	booboo
boocoo	10	3	900	3	boocoo
boohoo	11	4	883	3	boohoo
book	10	68	3633	3	bo__ok
bookoo	12	4	834	3	bookoo
boom	8	74	3567	3	bo__om
boombox	20	7	361	3	boombox
boon	6	71	4217	3	bo__on
boor	6	61	3068	3	bo__or
boos	6	79	5503	3	bo__os
boot	6	77	5937	3	bo__ot
borax	14	59	1872	3	bo_rax
boron	7	67	2714	3	bo_ron
borrow	11	43	1072	3	borrow
borzoi	17	3	662	3	borzoi
bosom	9	55	1692	3	bo_som
boson	7	60	1973	3	bo_son
boston	8	5	1304	3	boston
bottom	10	4	872	3	bottom
boubou	10	3	843	3	boubou
bouillon	10	4	378	3	bouillon
boule	7	48	2804	3	boul_e
boules	8	49	2597	3	boules
boulle	8	46	1461	3	boulle
boulles	9	31	1412	3	boulles
bouton	8	3	1153	3	bouton
bowl	9	68	2770	3	bowl__
bowled	12	50	1813	3	bowled
bowleg	12	36	917	3	bowleg
bowler	11	42	1731	3	bowler
bowls	10	61	2143	3	bowl_s
bowpot	13	4	1007	3	bowpot
bowwow	13	3	446	3	bowwow
box	12	101	4234	3	b___ox
boyla	10	29	1236	3	boyl_a
boylas	11	30	1172	3	boylas
boyo	9	69	2384	3	bo_yo_
boyos	10	54	1828	3	bo_yos
bozo	15	68	2141	3	bo_zo_
bozos	16	52	1686	3	bo_zos
brillo	8	42	1100	3	brillo_
brillos	9	36	918	3	brillos
brolly	11	45	1085	3	broll_y
brulot	8	9	1221	3	brulot
bull	6	56	3487	3	bull__
bulla	7	46	2056	3	bull_a
bullae	8	34	1616	3	bullae
bulldog	11	7	425	3	bulldog
bulled	9	46	2649	3	bulled
bullet	8	45	2861	3	bullet
bullion	9	19	1103	3	bullion
bullock	15	3	719	3	bullock
bullous	9	3	1166	3	bullous
bulls	7	56	2957	3	bull_s
bully	10	51	2481	3	bull_y
callow	11	47	1466	3	callow
cello	7	49	1958	3	cello_
cellos	8	45	1780	3	cellos
coalbox	18	4	411	3	coalbox
coelom	10	3	1042	3	coelom
collar	8	38	1617	3	collar
collet	8	40	3036	3	collet
collie	8	36	2199	3	collie
colloid	10	3	1288	3	colloid
collops	11	26	1175	3	collops
colly	10	49	2677	3	coll_y
colog	8	66	1993	3	co_log
colon	7	86	3019	3	co_lon
color	7	61	2374	3	co_lor
coplot	10	5	1827	3	coplot
cowpox	20	3	500	3	cowpox
doblon	9	3	801	3	doblon
doll	5	66	3249	3	doll__
dollar	7	41	1098	3	dollar
dolled	8	35	1807	3	dolled
dollops	10	28	796	3	dollops
dolls	6	61	2692	3	doll_s
dolly	9	61	2520	3	doll_y
dolor	6	76	1796	3	do_lor
fallow	12	47	1385	3	fallow
felloe	9	35	1392	3	felloe
fellow	12	37	1274	3	fellow
fillo	8	43	1978	3	fillo_
fillos	9	44	1508	3	fillos
folio	8	38	2088	3	folio_
folios	9	39	1546	3	folios
folles	9	38	2047	3	folles
follis	9	31	1390	3	follis
follows	13	40	992	3	follows
folly	11	50	2260	3	foll_y
fowlpox	22	4	178	3	fowlpox
gallon	7	37	1581	3	gallon
gallop	9	33	1138	3	gallop
golly	9	51	2110	3	goll_y
hallo	8	51	2755	3	hallo_
halloa	9	49	1812	3	halloa
halloo	9	51	1897	3	halloo
hallos	9	54	2510	3	hallos
hallot	9	54	2678	3	hallot
hallow	12	48	1832	3	hallow
hallux	16	3	736	3	hallux
hellbox	19	4	498	3	hellbox
hello	8	65	2298	3	hello_
hellos	9	53	2168	3	hellos
hillo	8	47	2165	3	hillo_
hilloa	9	47	1303	3	hilloa
hillos	9	46	1889	3	hillos
holla	8	49	1849	3	holl_a
hollas	9	46	1690	3	hollas
holler	9	35	2061	3	holler
holloas	10	38	1494	3	holloas
holloed	11	38	1275	3	holloed
holloes	10	38	1819	3	holloes
holloos	10	40	1358	3	holloos
hollows	13	44	1233	3	hollows
holly	11	48	2443	3	holl_y
hotbox	18	3	570	3	hotbox
hullo	8	44	1745	3	hullo_
hulloa	9	50	1118	3	hulloa
hulloo	9	45	1173	3	hulloo
hullos	9	49	1629	3	hullos
jello	12	67	1627	3	jello_
jellos	13	47	1428	3	jellos
jolly	15	45	1751	3	joll_y
kolhoz	22	6	477	3	kolhoz
kolkoz	18	6	428	3	kolkoz
kolo	8	70	2622	3	ko_lo_
kolos	9	49	2121	3	ko_los
loll	4	61	2838	3	loll__
lolled	7	43	1582	3	lolled
loller	6	33	1528	3	loller
lollops	9	22	744	3	lollops
lollopy	12	23	477	3	lollopy
lolls	5	121	2173	3	loll_s
lolly	8	51	2066	3	loll_y
lox	10	82	4096	3	___lox
mallow	11	40	1474	3	mallow
mellow	11	41	1222	3	mellow
moll	6	67	3570	3	moll__
mollah	11	31	945	3	mollah
mollie	8	35	1710	3	mollie
molls	7	51	2978	3	moll_s
molly	10	52	2249	3	moll_y
molto	7	56	1960	3	molto_
nolo	4	62	2931	3	no_lo_
nolos	5	44	2335	3	no_los
oleo	4	66	3048	3	_oleo_
oleos	5	54	1968	3	_oleos
olio	4	68	2967	3	_olio_
olios	5	45	2085	3	_olios
olla	4	48	2117	3	_oll_a
ollas	5	42	1828	3	_ollas
orlon	5	4	1500	3	_orlon
orlop	7	4	1090	3	_orlop
pallor	8	3	1367	3	pallor
phlox	17	3	733	3	_phlox
pillbox	18	4	341	3	pillbox
pillow	11	31	1057	3	pillow
poleax	15	4	799	3	poleax
polio	7	57	2255	3	polio_
polios	8	40	1972	3	polios
poll	6	63	3213	3	poll__
polled	9	40	2200	3	polled
pollee	8	36	2327	3	pollee
pollen	8	34	1645	3	pollen
poller	8	39	2185	3	poller
pollock	15	4	684	3	pollock
polls	7	46	2772	3	poll_s
polo	6	62	3663	3	po_lo_
polos	7	61	2991	3	po_los
polyol	11	3	871	3	polyol
roll	4	63	3165	3	roll__
rolled	7	42	2024	3	rolled
roller	6	39	1979	3	roller
rollmop	11	4	299	3	rollmop
rollout	7	8	1194	3	rollout
rolls	5	53	2623	3	roll_s
rolltop	9	4	404	3	rolltop
sallow	9	43	1575	3	sallow
scollop	11	27	543	3	scollop
soldo	6	71	1656	3	soldo_
solion	6	6	1638	3	solion
solo	4	55	3894	3	so_lo_
solon	5	50	2613	3	so_lon
solos	5	48	3079	3	so_los
tallol	6	36	1222	3	tallol
tallow	9	37	1420	3	tallow
toll	4	55	3526	3	toll__
tolled	7	38	1903	3	tolled
toller	6	38	1944	3	toller
tolls	5	47	2843	3	toll_s
toluol	6	3	690	3	toluol
toolbox	16	5	363	3	toolbox
trollop	9	4	479	3	trollop
volley	12	41	974	3	volley
wallop	11	33	1029	3	wallop
wallow	12	39	1351	3	wallow
willow	12	36	969	3	willow
yellow	12	42	988	3	yellow

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	328	5.656	19928.6
3	Display Results	328	328	0.093	3526.9
	(SQL Overall)	178691	328	5.889	30343.2