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

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

255 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
climbing	15	20	598	(None)
limbing	12	34	1042	1	_limbing
chiming	15	33	1183	2	chim_ing
claiming	13	27	930	2	claim_ing
clamming	15	32	937	2	clamming
clamping	15	40	1115	2	clamping
clicking	17	36	1098	2	clicking
climaxing	21	4	349	2	climaxing
clinging	12	29	1091	2	clinging
clinking	15	36	1166	2	clinking
clipping	15	34	915	2	clipping
cliquing	20	3	536	2	cliquing
clomping	15	32	965	2	clomping
clubbing	15	26	651	2	clubbing
clumping	15	31	988	2	clumping
combing	14	37	1473	2	c_ombing
cribbing	15	27	684	2	cribbing
crimping	15	29	978	2	crimping
crumbing	15	26	781	2	crumbing
gliming	11	33	1013	2	glim_ing
lambing	12	34	1241	2	_lambing
liming	9	40	2124	2	_lim_ing
limning	10	37	1032	2	_limning
limping	12	46	1411	2	_limping
plumbing	15	28	643	2	plumbing
sliming	10	29	1395	2	slim_ing
slimming	13	28	809	2	slimming
upclimbing	19	4	170	2	upclimbing
aiming	9	43	2084	3	_aim_ing
aliasing	9	3	1007	3	aliasing
alibiing	11	3	532	3	alibiing
aliening	9	15	1089	3	aliening
aligning	10	15	853	3	aligning
alining	8	19	1704	3	ali_ning
bibbing	11	29	961	3	_bibbing
blabbing	12	26	672	3	blabbing
blaming	12	35	1569	3	blam_ing
blebbing	12	26	567	3	blebbing
blinding	12	32	1016	3	blinding
blinking	15	35	1062	3	blinking
blipping	15	30	680	3	blipping
blissing	11	3	687	3	blissing
blitzing	20	3	590	3	blitzing
blobbing	12	24	692	3	blobbing
blubbing	12	25	701	3	blubbing
bluming	12	35	1128	3	blum_ing
blurbing	13	32	650	3	blurbing
bombing	14	32	1139	3	_bombing
bribing	12	31	1104	3	bri_bing
brimming	15	19	662	3	brimming
cabbing	14	36	1315	3	c_abbing
calming	12	39	1597	3	calm_ing
camping	14	31	1897	3	c_amping
ceiling	10	34	1672	3	cei_ling
champing	18	36	1093	3	champing
chiding	14	39	1159	3	chi_ding
childing	15	28	850	3	childing
chilling	14	35	1218	3	chilling
chining	13	33	1684	3	chi_ning
chinking	18	32	1089	3	chinking
chinning	14	32	965	3	chinning
chipping	18	38	979	3	chipping
chirking	18	33	938	3	chirking
chirming	16	31	864	3	chirming
chirping	16	27	886	3	chirping
chirring	14	26	1017	3	chirring
chitling	14	29	1066	3	chitling
chivying	20	3	497	3	chivying
chomping	18	33	988	3	chomping
chumming	18	36	620	3	chumming
chumping	18	34	906	3	chumping
citing	9	42	2018	3	c_i_ting
clacking	17	33	1349	3	clacking
cladding	13	3	714	3	cladding
clagging	13	32	888	3	clagging
clambering	17	7	616	3	clambering
clamoring	14	7	742	3	clamoring
clanging	12	40	1212	3	clanging
clanking	15	43	1306	3	clanking
clapping	15	38	1060	3	clapping
clashing	14	38	1219	3	clashing
clasping	13	33	1026	3	clasping
classing	11	32	1179	3	classing
clawing	13	38	1267	3	cl_awing
claying	13	36	1430	3	cl_aying
cleaning	11	31	1238	3	cleaning
clearing	11	30	1488	3	clearing
cleating	11	35	1814	3	cleating
cleaving	14	138	968	3	cleaving
cleeking	15	26	781	3	cleeking
clefting	14	34	758	3	clefting
cleping	12	33	1042	3	cl_eping
clerking	15	25	716	3	clerking
clewing	13	35	958	3	cl_ewing
climb	11	54	1359	3	climb___
climbed	14	33	698	3	climb_ed
climber	13	44	913	3	climb_er
climbers	14	31	841	3	climbers
climbs	12	49	872	3	climb__s
clinching	17	27	612	3	clinching
cling	8	64	2467	3	cl___ing
clippings	16	27	375	3	clippings
cloaking	15	29	971	3	cloaking
clocking	17	43	1241	3	clocking
clogging	13	36	850	3	clogging
cloning	10	32	1547	3	cl_oning
clonking	15	38	1015	3	clonking
clopping	15	35	1108	3	clopping
closing	10	31	1484	3	cl_osing
clothing	14	27	878	3	clothing
clotting	11	31	1064	3	clotting
clouding	12	26	949	3	clouding
clouring	11	28	1127	3	clouring
clouting	11	30	1168	3	clouting
clowning	14	30	725	3	clowning
cloying	13	35	1175	3	cl_oying
clucking	17	42	999	3	clucking
clueing	10	41	1009	3	cl_ueing
cluing	9	39	1350	3	cl__uing
clunking	15	32	943	3	clunking
coaming	12	38	1832	3	coam_ing
coiffing	17	5	593	3	coiffing
coifing	13	32	1389	3	coi_fing
coigning	12	3	717	3	coigning
coiling	10	37	2345	3	coi_ling
coining	10	39	2054	3	coi_ning
columbine	15	4	426	3	columbine
combine	13	30	1472	3	c_ombine
combings	15	34	832	3	c_ombings
coming	11	42	2545	3	c_om_ing
comping	14	35	1859	3	c_omping
crabbing	15	28	793	3	crabbing
cramming	15	33	943	3	cramming
cramping	15	34	1185	3	cramping
cribbings	16	27	317	3	cribbings
cricking	17	34	1265	3	cricking
crimine	11	24	1347	3	crim_ine
crimini	11	25	888	3	crim_ini
criminy	14	26	845	3	crim_iny
crimpling	16	4	534	3	crimpling
cringing	12	33	1138	3	cringing
crisping	13	31	966	3	crisping
crumbling	16	5	508	3	crumbling
crumping	15	31	990	3	crumping
cubing	11	42	1395	3	c__ubing
culming	12	38	1118	3	culm_ing
curbing	12	38	1402	3	c_urbing
cymbling	18	3	477	3	c_ymbling
cymling	15	3	627	3	c_ymling
deliming	12	3	1037	3	delim_ing
dibbing	13	31	1089	3	_dibbing
dimming	13	33	959	3	_dimming
dribbing	14	32	588	3	dribbing
dumbing	13	31	985	3	_dumbing
eclipsing	14	4	374	3	eclipsing
eliding	9	34	1434	3	eli_ding
fibbing	15	33	946	3	_fibbing
filming	13	32	1035	3	film_ing
flambeing	17	4	393	3	flambeing
flaming	13	42	1644	3	flam_ing
flamming	16	35	715	3	flamming
flicking	18	41	1004	3	flicking
flinging	13	33	1005	3	flinging
flinting	12	34	1234	3	flinting
flipping	16	30	766	3	flipping
flirting	12	31	901	3	flirting
fliting	11	35	1461	3	fli_ting
flitting	12	30	1088	3	flitting
flubbing	16	27	588	3	flubbing
fluming	13	35	1279	3	flum_ing
flumping	16	28	758	3	flumping
gibbing	13	33	937	3	_gibbing
gibing	10	37	1235	3	_gi_bing
gimping	13	37	1076	3	_gimping
gliding	10	39	1184	3	gli_ding
glimpsing	15	4	259	3	glimpsing
glinting	10	32	1005	3	glinting
glitzing	19	3	497	3	glitzing
globing	11	32	1000	3	gl_obing
glomming	14	27	592	3	glomming
griming	11	36	1249	3	grim_ing
imbuing	12	3	610	3	__imbuing
imping	11	43	1535	3	__imping
jambing	19	32	853	3	_jambing
jibbing	19	33	806	3	_jibbing
jibing	16	37	962	3	_ji_bing
laming	9	45	2836	3	_lam_ing
lamming	12	30	1458	3	_lamming
lamping	12	31	1600	3	_lamping
lemming	12	26	939	3	_lemming
licking	14	41	1828	3	_licking
lidding	10	36	1143	3	_lidding
lifting	11	33	1327	3	_lifting
liking	11	43	1958	3	_li_king
lilting	8	35	1538	3	_lilting
limbering	14	8	879	3	_limbering
limbi	9	65	1381	3	_limbi__
limbic	12	52	874	3	_limbi_c
limbier	11	34	911	3	_limbier
limina	8	35	1450	3	_lim_ina
limiting	11	3	881	3	_limiting
lining	7	45	2680	3	_li_ning
linking	12	38	1825	3	_linking
linting	8	38	2098	3	_linting
lipping	12	30	1607	3	_lipping
lisping	10	34	1275	3	_lisping
listing	8	40	2059	3	_listing
living	10	43	1832	3	_li_ving
lobbing	12	31	1091	3	_lobbing
lubing	9	41	1404	3	_l_ubing
lumping	12	33	1464	3	_lumping
maiming	12	29	1272	3	maim_ing
miming	11	43	1726	3	_mim_ing
nibbing	12	33	955	3	_nibbing
nimming	12	35	814	3	_nimming
numbing	12	26	903	3	_numbing
outclimbing	18	7	224	3	~~out~~climbing
pimping	14	38	1212	3	_pimping
plinking	15	36	1124	3	plinking
plumbings	16	21	336	3	plumbings
pluming	12	34	1204	3	plum_ing
plumping	15	27	763	3	plumping
priming	12	34	1737	3	prim_ing
primming	15	26	817	3	primming
primping	15	33	889	3	primping
ribbing	12	31	1195	3	_ribbing
riming	9	33	2222	3	_rim_ing
rimming	12	34	1107	3	_rimming
scribing	13	23	818	3	scri_bing
scrimping	16	3	495	3	scrimping
shimming	16	27	825	3	shimming
skimming	17	28	627	3	skimming
skimping	17	30	624	3	skimping
slabbing	13	28	778	3	slabbing
slamming	13	33	1000	3	slamming
slicing	10	35	1464	3	sli_cing
slicking	15	37	1259	3	slicking
sliding	9	31	1455	3	sli_ding
slinging	10	33	1286	3	slinging
slinking	13	34	1298	3	slinking
sliping	10	33	1441	3	sli_ping
slipping	13	35	1066	3	slipping
slitting	9	30	1258	3	slitting
slubbing	13	24	803	3	slubbing
slumming	13	27	838	3	slumming
slumping	13	35	997	3	slumping
snibbing	13	29	589	3	snibbing
stimying	14	3	750	3	stimying
swimming	16	31	632	3	swimming
thumbing	16	24	551	3	thumbing
timing	9	36	1930	3	_tim_ing
tombing	12	33	1053	3	_tombing
trimming	13	31	865	3	trimming
wimbling	16	18	654	3	_wimbling
wimping	15	39	1101	3	_wimping

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	255	7.736	18893.7
3	Display Results	255	255	0.093	2741.9
	(SQL Overall)	178691	255	8.249	21662.1