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

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

80 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
babbler	10	40	1282	(None)
babble	9	40	1711	1	babble_
babbled	11	36	1286	1	babbled
babblers	11	35	1035	1	babblers
babbles	10	44	1632	1	babbles
brabbler	11	39	737	1	brabbler
bubbler	10	36	1178	1	bubbler
dabbler	12	40	1215	1	dabbler
gabbler	12	40	1330	1	gabbler
rabbler	11	35	1409	1	rabbler
wabbler	14	35	1192	1	wabbler
abler	7	56	2431	2	_a_bler
ambler	10	49	1645	2	_ambler
babier	10	35	1557	2	ba_bier
baffler	15	41	811	2	baffler
bailer	8	54	2525	2	ba_iler
baler	7	56	3527	2	ba__ler
baller	8	38	2520	2	ba_ller
barber	10	44	1932	2	barb_er
battler	9	41	1338	2	battler
bauble	10	38	1321	2	bauble_
baubles	11	36	1186	2	baubles
bawler	11	43	1505	2	ba_wler
bibber	9	46	1357	2	bibb_er
blabber	10	41	892	2	blabb_er
bobber	9	50	1674	2	bobb_er
bobble	9	41	1514	2	bobble_
bobbled	11	38	1183	2	bobbled
bobbles	10	45	1491	2	bobbles
brabble	10	34	997	2	brabble_
brabbled	12	33	763	2	brabbled
brabblers	12	33	556	2	brabblers
brabbles	11	34	975	2	brabbles
bubble	9	40	1659	2	bubble_
bubbled	11	36	1212	2	bubbled
bubblers	11	44	894	2	bubblers
bubbles	10	43	1596	2	bubbles
bubblier	11	8	447	2	bubblier
bumbler	13	40	1323	2	bumbler
burbler	11	44	1242	2	burbler
cabler	10	45	1917	2	ca_bler
cobbler	13	33	1182	2	cobbler
dabber	11	48	1696	2	dabb_er
dabble	11	45	1519	2	dabble_
dabbled	13	37	1207	2	dabbled
dabblers	13	37	936	2	dabblers
dabbles	12	45	1477	2	dabbles
dibbler	12	45	1028	2	dibbler
fabber	13	48	1411	2	fabb_er
fabler	11	61	1581	2	fa_bler
gabber	11	49	1660	2	gabb_er
gabbier	12	37	963	2	gabbier
gabble	11	38	1572	2	gabble_
gabbled	13	41	1245	2	gabbled
gabblers	13	41	1008	2	gabblers
gabbles	12	44	1541	2	gabbles
gambler	12	36	1268	2	gambler
garbler	10	40	1256	2	garbler
gobbler	12	33	1002	2	gobbler
grabbler	13	37	769	2	grabbler
hobbler	14	37	1040	2	hobbler
jabber	17	37	1364	2	jabb_er
labeler	9	23	1018	2	labeler
marbler	11	35	1167	2	marbler
nabber	10	49	1354	2	nabb_er
nibbler	11	37	927	2	nibbler
nobbler	11	32	1118	2	nobbler
rabble	10	38	1824	2	rabble_
rabbled	12	35	1442	2	rabbled
rabblers	12	38	1085	2	rabblers
rabbles	11	35	1797	2	rabbles
rambler	11	33	1326	2	rambler
wabble	13	37	1484	2	wabble_
wabbled	15	33	1144	2	wabbled
wabblers	15	39	899	2	wabblers
wabbles	14	40	1399	2	wabbles
wabblier	15	37	549	2	wabblier
warbler	12	32	1146	2	warbler
wobbler	14	32	982	2	wobbler
yabber	13	61	1183	2	yabb_er

Search took 4 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.140	1276364.3
2	DLD Change Limit	107671	80	3.470	31029.1
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.643	49050.5