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

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

320 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
clubber	13	31	959	(None)
blubber	10	39	929	1	blubber
clabber	13	42	1011	1	clabber
clobber	13	37	816	1	clobber
clubbed	14	30	745	1	clubbed
clubbers	14	37	858	1	clubbers
clubbier	14	3	483	1	clubbier
clumber	13	40	1144	1	clumber
flubber	14	28	771	1	flubber
lubber	10	42	1462	1	_lubber
slubber	11	30	1076	1	slubber
blabber	10	41	892	2	blabber
blubbed	11	33	839	2	blubbed
blubbers	11	40	814	2	blubbers
blubbery	14	29	478	2	blubbery
chubbier	17	3	389	2	chubbier
clabbers	14	35	990	2	clabbers
clamber	13	33	1174	2	clamber
climber	13	44	913	2	climber
clobbers	14	39	751	2	clobbers
clubby	15	3	468	2	clubb_y
clubmen	13	3	425	2	clubmen
clumbers	14	39	1041	2	clumbers
clunker	13	41	945	2	clunker
cluster	9	40	1333	2	cluster
clutter	9	42	1166	2	clutter
cobber	12	41	1684	2	c_obber
crabber	13	38	1073	2	crabber
cribber	13	36	766	2	cribber
crumber	13	33	964	2	crumber
cuber	9	52	2253	2	c_u_ber
cumber	12	40	1670	2	c_umber
curber	10	45	1705	2	c_urber
drubber	12	35	786	2	drubber
dubber	11	38	1455	2	_dubber
flubbed	15	30	663	2	flubbed
flubbers	15	34	689	2	flubbers
glibber	12	3	516	2	glibber
grubber	12	41	791	2	grubber
libber	10	44	1401	2	_libber
lobber	10	40	1660	2	_lobber
lubbers	11	39	1372	2	_lubbers
lumber	10	38	1777	2	_lumber
plumber	13	33	998	2	plumber
rubber	10	47	1579	2	_rubber
scrubber	14	3	412	2	scrubber
slabber	11	33	1139	2	slabber
slobber	11	38	890	2	slobber
slubbed	12	33	928	2	slubbed
slubbers	12	34	994	2	slubbers
slumber	11	38	1100	2	slumber
snubber	11	27	773	2	snubber
tubber	10	43	1320	2	_tubber
bibber	9	46	1357	3	_bibber
blabbed	11	35	781	3	blabbed
blabbers	11	30	815	3	blabbers
blobbed	11	36	656	3	blobbed
blubbered	13	16	411	3	blubbered
blubberer	12	17	345	3	blubberer
blucher	14	33	1022	3	blucher
bludger	11	41	956	3	bludger
bluer	7	49	1849	3	blu__er
bluffer	15	39	688	3	bluffer
blunder	10	38	1315	3	blunder
blunger	10	41	1201	3	blunger
blunter	9	45	1203	3	blunter
blurbed	12	33	761	3	blurbed
blurter	9	41	983	3	blurter
blusher	12	41	1311	3	blusher
bluster	9	42	1531	3	bluster
bobber	9	50	1674	3	_bobber
bubbler	10	36	1178	3	_bubbler
cabbed	13	54	1626	3	c_abbed
caber	9	51	2683	3	c__aber
cabler	10	45	1917	3	c_abler
caliber	11	3	973	3	caliber
camber	12	44	1848	3	c_amber
caulker	13	45	689	3	caulker
causer	8	41	1778	3	cau_ser
chamber	16	40	1106	3	chamber
chubby	18	4	412	3	chubb_y
chudder	14	24	594	3	chudder
chuffer	18	33	714	3	chuffer
chugger	14	4	537	3	chugger
chukker	15	4	383	3	chukker
chunter	12	39	1148	3	chunter
churner	12	29	834	3	churner
clabbered	16	18	476	3	clabbered
clacker	15	38	1377	3	clacker
claimer	11	27	988	3	claimer
clambers	14	42	1129	3	clambers
clammer	13	42	1179	3	clammer
clamper	13	40	1299	3	clamper
clanger	10	41	1349	3	clanger
clapper	13	40	1186	3	clapper
claquer	18	28	735	3	claquer
clasher	12	46	1551	3	clasher
clasper	11	38	1186	3	clasper
classer	9	36	1461	3	classer
clatter	9	40	1497	3	clatter
claver	11	38	1697	3	cl_aver
clavier	12	3	917	3	clavier
clawer	11	45	1278	3	cl_awer
clayier	12	4	832	3	clayier
cleaner	9	37	1230	3	cleaner
clearer	9	37	1082	3	clearer
cleaver	12	41	1080	3	cleaver
clever	11	46	1153	3	cl_ever
clicker	15	41	1188	3	clicker
climbed	14	33	698	3	climbed
climbers	14	31	841	3	climbers
clinger	10	38	1215	3	clinger
clinker	13	38	1166	3	clinker
clipper	13	37	1032	3	clipper
clobbered	16	16	410	3	clobbered
clocker	15	39	1087	3	clocker
clogger	11	43	880	3	clogger
cloner	8	44	1809	3	cl_oner
closer	8	49	1820	3	cl_oser
cloudier	11	3	505	3	cloudier
clouter	9	35	1169	3	clouter
clover	11	46	1712	3	cl_over
clowder	13	36	794	3	clowder
club	8	58	1947	3	clu_b__
clubable	14	3	609	3	clubable
clubbiest	15	3	427	3	clubbiest
clubbing	15	26	651	3	clubbing
clubbish	17	4	381	3	clubbish
clubfeet	15	4	379	3	clubfeet
clubhead	16	6	277	3	clubhead
clubman	13	4	402	3	clubman
clubs	9	54	1510	3	clu_b_s
clucked	16	38	1013	3	clucked
clue	6	53	2453	3	clu__e_
clued	8	49	1768	3	clu__ed
clues	7	46	2303	3	clu__es
clumped	14	36	1066	3	clumped
clumpier	14	3	558	3	clumpier
clumsier	12	3	473	3	clumsier
clunked	14	43	957	3	clunked
clunkers	14	32	755	3	clunkers
clunkier	14	34	579	3	clunkier
clusters	10	29	1240	3	clusters
clustery	13	31	711	3	clustery
clutters	10	32	1035	3	clutters
cluttery	13	34	632	3	cluttery
clyster	12	31	745	3	clyster
cobbers	13	41	1475	3	c_obbers
cobbier	13	34	1016	3	cobbier
cobbler	13	33	1182	3	cobbler
comber	12	51	1850	3	c_omber
coucher	14	45	1585	3	coucher
cougher	13	37	1173	3	cougher
coulter	9	41	1560	3	coulter
counter	9	42	2015	3	counter
coupler	11	47	1301	3	coupler
courier	9	36	1789	3	courier
courser	9	41	1480	3	courser
courter	9	45	1648	3	courter
couter	8	49	3022	3	cou_ter
couther	12	39	1463	3	couther
crabbed	14	38	887	3	crabbed
crabbers	14	35	875	3	crabbers
crabbier	14	32	680	3	crabbier
cribbed	14	40	766	3	cribbed
cribbers	14	30	644	3	cribbers
cruder	9	56	1238	3	cru_der
crueler	9	3	902	3	crueler
cruiser	9	34	1043	3	cruiser
cruller	9	6	875	3	cruller
crumbed	14	37	847	3	crumbed
crumbers	14	33	824	3	crumbers
crumbier	14	5	636	3	crumbier
crupper	13	33	856	3	crupper
crusher	12	44	1232	3	crusher
cubbies	13	33	1288	3	c_ubbies
cubby	14	52	1212	3	c_ubb_y
cube	8	58	3021	3	c_u_be_
cubeb	11	58	1466	3	c_u_beb
cubebs	12	50	868	3	c_ubebs
cubed	10	55	1970	3	c_u_bed
cubers	10	53	1835	3	c_u_bers
cubes	9	50	2816	3	c_u_bes
cucumber	16	4	260	3	cucumber
cudbear	12	3	333	3	c_udbear
culler	8	43	2225	3	c_uller
culver	11	30	1063	3	c_ulver
cumbers	13	45	1541	3	c_umbers
cummer	12	44	1459	3	c_ummer
cunner	8	39	1500	3	c_unner
cupper	12	43	1386	3	c_upper
curbed	11	46	1587	3	c_urbed
curbers	11	55	1438	3	c_urbers
curer	7	50	3075	3	c_u_rer
curler	8	52	2132	3	c_urler
curser	8	47	2147	3	c_urser
curter	8	53	2008	3	c_urter
cusser	8	60	1609	3	c_usser
cuter	7	47	2823	3	c_u_ter
cutler	8	47	1803	3	c_utler
cutter	8	45	2100	3	c_utter
cyber	12	49	1038	3	c__yber
dabber	11	48	1696	3	_dabber
dauber	9	41	1201	3	dau_ber
daubier	10	3	710	3	daubier
dibber	11	46	1471	3	_dibber
dobber	11	40	1542	3	_dobber
doubler	10	31	1008	3	doubler
doubter	10	29	835	3	doubter
drabber	12	43	859	3	drabber
drubbed	13	40	698	3	drubbed
drubbers	13	38	603	3	drubbers
dubbed	12	41	1321	3	_dubbed
dubbers	12	40	1182	3	_dubbers
dumber	11	44	1417	3	_dumber
eluder	7	37	1221	3	elu_der
fabber	13	48	1411	3	_fabber
fibber	13	48	1193	3	_fibber
flabbier	15	3	409	3	flabbier
fluffer	12	33	650	3	fluffer
flukier	14	39	785	3	flukier
flunker	14	38	936	3	flunker
flusher	13	30	1227	3	flusher
fluster	10	39	1306	3	fluster
fluter	9	53	1686	3	flu_ter
flutier	10	30	1155	3	flutier
flutter	10	40	1209	3	flutter
fubbed	14	47	1124	3	_fubbed
gabber	11	49	1660	3	_gabber
gibber	11	41	1286	3	_gibber
globbier	13	3	424	3	globbier
gluer	6	51	1677	3	glu__er
gluier	7	3	1026	3	glu_ier
glummer	12	41	798	3	glummer
grabber	12	38	976	3	grabber
grubbed	13	40	643	3	grubbed
grubbers	13	31	620	3	grubbers
grubbier	13	34	475	3	grubbier
hobber	13	41	1463	3	_hobber
jabber	17	37	1364	3	_jabber
jibber	17	41	1124	3	_jibber
jobber	17	38	1335	3	_jobber
knubbier	16	4	251	3	knubbier
lamber	10	44	1849	3	_lamber
libbers	11	38	1283	3	_libbers
liber	7	47	2362	3	_l_iber
limber	10	43	1679	3	_limber
lobbed	11	31	1461	3	_lobbed
lobbers	11	37	1394	3	_lobbers
lobbyer	14	3	391	3	_lobbyer
lubberly	15	4	366	3	_lubberly
lube	6	47	3156	3	_lu_be_
lubed	8	53	1989	3	_lu_bed
lubes	7	47	2799	3	_lu_bes
luger	6	53	2208	3	_lu_ger
lugger	8	39	1655	3	_lugger
luller	6	34	1548	3	_luller
lumbar	10	36	1059	3	_lumbar
lumbers	11	38	1591	3	_lumbers
lumper	10	38	1665	3	_lumper
lunger	7	57	2042	3	_lunger
lunier	6	46	1760	3	_lunier
lunker	10	47	1834	3	_lunker
lurer	5	46	2531	3	_lu_rer
lurker	10	36	1329	3	_lurker
lusher	9	38	1876	3	_lusher
luster	6	40	2367	3	_luster
mobber	12	36	1346	3	_mobber
nabber	10	49	1354	3	_nabber
nubbier	11	30	813	3	_nubbier
number	10	39	1322	3	_number
plucker	15	36	824	3	plucker
plugger	11	37	843	3	plugger
plumbed	14	31	727	3	plumbed
plumbers	14	41	851	3	plumbers
plumbery	17	31	553	3	plumbery
plumier	11	35	1004	3	plumier
plummer	13	29	852	3	plummer
plumper	13	31	877	3	plumper
plunder	10	38	1050	3	plunder
plunger	10	42	1124	3	plunger
plunker	13	39	1065	3	plunker
plusher	12	40	1038	3	plusher
ribber	10	35	1549	3	_ribber
robber	10	39	1653	3	_robber
rubbed	11	45	1508	3	_rubbed
rubbers	11	39	1319	3	_rubbers
rubbery	14	33	759	3	_rubbery
rubier	8	48	1474	3	_rubier
scrubbed	15	3	385	3	scrubbed
scrubbers	15	4	337	3	scrubbers
scrubbier	15	4	333	3	scrubbier
slabbed	12	40	950	3	slabbed
slabbers	12	36	1012	3	slabbers
slabbery	15	37	577	3	slabbery
slobbers	12	39	852	3	slobbers
slobbery	15	37	566	3	slobbery
slobbier	12	5	463	3	slobbier
slubbered	14	17	525	3	slubbered
slugger	9	36	1068	3	slugger
slumbers	12	31	1027	3	slumbers
slumbery	15	29	604	3	slumbery
slummer	11	37	1120	3	slummer
snubbed	12	34	744	3	snubbed
snubbers	12	32	667	3	snubbers
snubbier	12	4	499	3	snubbier
sobber	10	40	1659	3	_sobber
stabber	11	36	1015	3	stabber
stubbed	12	37	808	3	stubbed
stubbier	12	3	535	3	stubbier
subbed	11	41	1667	3	_subbed
suber	7	49	2450	3	_su_ber
swabber	14	29	796	3	swabber
swobber	14	33	654	3	swobber
tubbed	11	47	1222	3	_tubbed
tubbers	11	34	1125	3	_tubbers
tubbier	11	23	774	3	_tubbier
tuber	7	54	2068	3	_tu_ber
umber	9	46	1759	3	__umber
yabber	13	61	1183	3	_yabber

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	320	6.423	20866.7
3	Display Results	320	320	0.110	2909.1
	(SQL Overall)	178691	320	6.939	25751.7