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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

62 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
gabbier	12	37	963	(None)
gabber	11	49	1660	1	gabb_er
gabbler	12	40	1330	1	gabbler
gambier	12	47	1197	1	gambier
grabbier	13	31	665	1	grabbier
babbler	10	40	1282	2	babbler
babier	10	35	1557	2	ba_bier
cabbie	12	29	1335	2	cabbie_
cabbies	13	31	1516	2	cabbies
cobbier	13	34	1016	2	cobbier
crabbier	14	32	680	2	crabbier
dabber	11	48	1696	2	dabb_er
dabbler	12	40	1215	2	dabbler
daubier	10	3	710	2	daubier
fabber	13	48	1411	2	fabb_er
flabbier	15	3	409	2	flabbier
gabbed	12	52	1689	2	gabb_ed
gabbers	12	46	1283	2	gabb_ers
gabbiest	13	3	727	2	gabbiest
gabbing	13	35	1203	2	gabbing
gabble	11	38	1572	2	gabble_
gabbled	13	41	1245	2	gabbled
gabblers	13	41	1008	2	gabblers
gabbles	12	44	1541	2	gabbles
gabies	9	38	2073	2	ga_bies
gambiers	13	33	707	2	gambiers
gambir	11	50	977	2	gambi_r
gambler	12	36	1268	2	gambler
gamier	9	36	1793	2	ga_mier
gammier	12	37	1119	2	gammier
gappier	12	36	984	2	gappier
garbler	10	40	1256	2	garbler
gassier	8	38	1257	2	gassier
gaudier	9	3	845	2	gaudier
gauzier	17	3	563	2	gauzier
gawkier	15	32	652	2	gawkier
gibber	11	41	1286	2	gibb_er
globbier	13	3	424	2	globbier
gobbler	12	33	1002	2	gobbler
grabber	12	38	976	2	grabb_er
grabbler	13	37	769	2	grabbler
grubbier	13	34	475	2	grubbier
jabber	17	37	1364	2	jabb_er
lambier	11	36	1164	2	lambier
nabber	10	49	1354	2	nabb_er
nobbier	11	30	916	2	nobbier
nubbier	11	30	813	2	nubbier
rabbies	11	34	1605	2	rabbies
rabbiter	12	3	467	2	rabbiter
rabbler	11	35	1409	2	rabbler
ribbier	11	3	759	2	ribbier
scabbier	14	3	513	2	scabbier
shabbier	15	3	518	2	shabbier
tabbied	12	29	779	2	tabbied
tabbies	11	29	1350	2	tabbies
tubbier	11	23	774	2	tubbier
wabbler	14	35	1192	2	wabbler
wabblier	15	37	549	2	wabblier
webbier	14	4	542	2	webbier
yabber	13	61	1183	2	yabb_er
yabbie	13	30	866	2	yabbie_
yabbies	14	27	964	2	yabbies

Search took 5 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	62	4.110	26197.3
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	4.249	42054.8