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

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

120 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
cambers	13	40	1744	(None)
ambers	10	45	1958	1	_ambers
cabers	10	50	2392	1	ca_bers
camber	12	44	1848	1	camber_
campers	13	42	2029	1	campers
chambers	17	34	1062	1	chambers
clambers	14	42	1129	1	clambers
combers	13	45	1662	1	combers
cumbers	13	45	1541	1	cumbers
lambers	11	38	1711	1	lambers
ambeers	11	42	892	2	_ambeers
amber	9	45	2321	2	_amber_
ambery	13	38	1113	2	_ambery
amblers	11	52	1356	2	_amblers
ameers	8	40	1557	2	_ameers
barbers	11	43	1750	2	barbers
bombers	13	45	1259	2	bombers
caber	9	51	2683	2	ca_ber_
cablers	11	44	1671	2	cablers
cadgers	11	47	1200	2	cadgers
cagers	9	56	2419	2	ca_gers
cahiers	12	35	1067	2	cahiers
calibers	12	3	852	2	calibers
calkers	13	44	1469	2	calkers
callers	9	42	2196	2	callers
cambered	15	12	900	2	cambered
camels	10	52	1708	2	cam_els
cameos	10	58	1800	2	cam_eos
camera	10	3	1369	2	cam_era
cameras	11	3	1336	2	cam_eras
cames	9	70	4731	2	cam_e_s
camlets	11	43	1462	2	camlets
camper	12	47	2221	2	camper_
cancers	11	40	1858	2	cancers
caners	8	46	2920	2	ca_ners
cankers	13	44	1875	2	cankers
canners	9	38	2266	2	canners
canoers	9	43	1837	2	canoers
canters	9	48	2773	2	canters
capers	10	54	2814	2	ca_pers
cappers	13	44	1940	2	cappers
carders	10	48	2035	2	carders
careers	9	52	1878	2	careers
carers	8	51	3396	2	ca_rers
carpers	11	45	2125	2	carpers
carters	9	53	2725	2	carters
carvers	12	48	1753	2	carvers
casters	9	47	2990	2	casters
caters	8	53	3650	2	ca_ters
causers	9	40	1479	2	causers
cavers	11	50	2684	2	ca_vers
chamber	16	40	1106	2	chamber_
chamfers	18	40	922	2	chamfers
champers	17	33	1162	2	champers
clabbers	14	35	990	2	clabbers
clamber	13	33	1174	2	clamber_
clammers	14	35	1069	2	clammers
clampers	14	32	1189	2	clampers
climbers	14	31	841	2	climbers
clumbers	14	39	1041	2	clumbers
cobbers	13	41	1475	2	cobbers
comber	12	51	1850	2	comber_
combes	12	53	2173	2	combe_s
comers	10	53	2808	2	com_ers
crabbers	14	35	875	2	crabbers
crambes	13	3	996	2	crambe_s
crammers	14	36	935	2	crammers
crumbers	14	33	824	2	crumbers
cubers	10	53	1835	2	c_ubers
cumber	12	40	1670	2	cumber_
cummers	13	37	1348	2	cummers
curbers	11	55	1438	2	curbers
dabbers	12	38	1321	2	dabbers
dammers	12	32	1427	2	dammers
damners	10	41	1211	2	damners
dampers	12	39	1569	2	dampers
daubers	10	46	1042	2	daubers
embers	10	41	1618	2	_embers
gabbers	12	46	1283	2	gabbers
gambes	11	63	1831	2	gambe_s
gambiers	13	33	707	2	gambiers
gambirs	12	35	908	2	gambirs
gamblers	13	36	973	2	gamblers
gamers	9	44	2083	2	gam_ers
gammers	12	32	1456	2	gammers
hammers	14	42	1606	2	hammers
hampers	14	36	1695	2	hampers
jabbers	18	36	1058	2	jabbers
jambes	17	59	1405	2	jambe_s
jammers	18	37	1070	2	jammers
lamber	10	44	1849	2	lamber_
lambert	11	36	1711	2	lambert
lamberts	12	34	879	2	lamberts
lampers	11	38	1733	2	lampers
limbers	11	36	1474	2	limbers
lumbers	11	38	1591	2	lumbers
mammers	10	46	1569	2	mammers
mamzers	20	40	916	2	mamzers
members	13	25	860	2	members
nabbers	11	37	1046	2	nabbers
namers	8	45	1733	2	nam_ers
numbers	11	37	1124	2	numbers
ombers	10	42	1440	2	_ombers
pampers	13	36	1593	2	pampers
ramblers	12	40	1037	2	ramblers
rammers	11	37	1504	2	rammers
sabers	8	52	2473	2	sa_bers
sambars	11	51	1384	2	sambars
samburs	11	36	934	2	samburs
scammers	14	33	977	2	scammers
scampers	14	36	1103	2	scampers
tabers	8	46	2157	2	ta_bers
tamburs	11	28	861	2	tamburs
tamers	8	42	2403	2	tam_ers
tampers	11	35	1674	2	tampers
timbers	11	31	1185	2	timbers
umbers	10	42	1521	2	_umbers
vampers	14	31	1162	2	vampers
yabbers	14	38	935	2	yabbers
yammers	14	34	1032	2	yammers

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.360	496363.9
2	DLD Change Limit	107671	120	3.093	34811.2
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	3.499	51069.2