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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

125 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
limber	10	43	1679	(None)
climber	13	44	913	1	climber
lamber	10	44	1849	1	lamber
libber	10	44	1401	1	libber
liber	7	47	2362	1	li_ber
limbed	11	45	1318	1	limbed
limbers	11	36	1474	1	limbers
limbier	11	34	911	1	limbier
limier	8	35	1872	1	limier
limmer	10	43	1479	1	limmer
limner	8	41	1287	1	limner
limper	10	41	1785	1	limper
lumber	10	38	1777	1	lumber
timber	10	40	1268	1	timber
aimer	7	59	2682	2	aim_er
amber	9	45	2321	2	_amber
bibber	9	46	1357	2	bibber
bomber	12	50	1465	2	bomber
camber	12	44	1847	2	camber
clamber	13	33	1173	2	clamber
climbed	14	33	698	2	climbed
climbers	14	31	840	2	climbers
clumber	13	40	1144	2	clumber
comber	12	51	1850	2	comber
cumber	12	40	1670	2	cumber
dibber	11	46	1471	2	dibber
dimer	8	56	2560	2	dim_er
dimmer	11	41	1261	2	dimmer
dumber	11	44	1417	2	dumber
ember	9	55	1680	2	_ember
fibber	13	48	1193	2	fibber
fiber	10	49	2113	2	fi_ber
gibber	11	41	1286	2	gibber
giber	8	54	1770	2	gi_ber
glibber	12	3	516	2	glibber
glimmer	12	43	771	2	glimmer
imbed	10	50	1365	2	_imbed
jibber	17	41	1124	2	jibber
jiber	14	51	1570	2	ji_ber
jimper	17	38	986	2	jimper
lambed	11	56	1478	2	lambed
lambers	11	38	1710	2	lambers
lambert	11	36	1711	2	lambert
lambier	11	36	1164	2	lambier
lamer	7	52	3370	2	lam_er
libbers	11	38	1283	2	libbers
libel	7	41	1610	2	li_bel
libers	8	47	2144	2	li_bers
licker	12	52	2204	2	licker
lieder	7	49	1232	2	lieder
liefer	9	52	957	2	liefer
lier	4	59	4246	2	li__er
liever	9	46	1186	2	liever
lifer	8	58	2215	2	li_fer
lifter	9	38	1481	2	lifter
liger	6	50	2447	2	li_ger
liker	9	56	2706	2	li_ker
limb	8	54	2938	2	limb__
limba	9	54	1498	2	limb_a
limbas	10	53	1320	2	limbas
limbeck	17	4	417	2	limbeck
limbered	13	15	812	2	limbered
limberer	12	18	705	2	limberer
limberly	15	4	446	2	limberly
limbi	9	65	1381	2	limb_i
limbic	12	52	874	2	limbic
limbo	9	56	1481	2	limb_o
limbos	10	47	1214	2	limbos
limbs	9	61	1894	2	limb_s
limbus	10	57	1038	2	limbus
limby	12	57	1407	2	limb_y
lime	6	62	4493	2	lim_e_
limed	8	54	2680	2	lim_ed
limen	7	54	2603	2	lim_en
limes	7	56	3650	2	lim_es
limey	10	47	2104	2	lim_ey
limiter	9	27	1085	2	limiter
limmers	11	34	1308	2	limmers
limned	9	48	1147	2	limned
limners	9	33	1156	2	limners
limped	11	48	1712	2	limped
limpers	11	38	1522	2	limpers
limpet	10	35	1863	2	limpet
liner	5	59	3892	2	li_ner
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
linker	10	43	2147	2	linker
linter	6	46	2534	2	linter
lipper	10	42	1963	2	lipper
lisper	8	41	1443	2	lisper
lister	6	45	2725	2	lister
liter	5	47	3634	2	li_ter
lither	9	45	2095	2	lither
litter	6	43	2485	2	litter
liver	8	51	3296	2	li_ver
livier	9	75	1459	2	livier
livyer	12	42	629	2	livyer
lobber	10	40	1660	2	lobber
lubber	10	42	1462	2	lubber
lumbar	10	36	1059	2	lumbar
lumbers	11	38	1591	2	lumbers
lumper	10	38	1665	2	lumper
member	12	25	885	2	member
mimbar	12	9	749	2	mimbar
mimer	9	48	2576	2	mim_er
nimbler	11	35	806	2	nimbler
number	10	39	1322	2	number
omber	9	53	1644	2	_omber
plumber	13	33	998	2	plumber
ribber	10	35	1549	2	ribber
rimer	7	54	2924	2	rim_er
rimier	8	39	1627	2	rimier
rimmer	10	35	1603	2	rimmer
simmer	10	41	1535	2	simmer
simper	10	36	1629	2	simper
slimier	9	32	1201	2	slimier
slimmer	11	42	1134	2	slimmer
slumber	11	38	1100	2	slumber
somber	10	37	1399	2	somber
timbers	11	31	1185	2	timbers
timbery	14	25	689	2	timbery
timbre	10	32	863	2	timbre
timer	7	56	2604	2	tim_er
umber	9	46	1759	2	_umber
unlimber	12	4	337	2	unlimber

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	125	4.796	17212.5
3	Display Results	125	125	0.046	2717.4
	(SQL Overall)	178691	125	4.965	35990.1