Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

219 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
cabers10502392(None) 
caber95126831caber_
cablers114416711cablers
cagers95624191cagers
cambers134017441cambers
caners84629201caners
capers105428141capers
carers85133961carers
caters85336501caters
cavers115026841cavers
cubers105318351cubers
sabers85224731sabers
tabers84621571tabers
abets75621672_abets
agers65027852_agers
ambers104519582ambers
apers76629132_apers
avers85127312_avers
babels105216722babels
babes95834112babe_s
bakers125323452bakers
balers85626932balers
barbers114317502barbers
cabals104020152cabals
cabins104418922cabins
cabler104519172cabler_
cables104527552cables
cablets114216342cablets
cabobs124311892cabobs
cabs86739422cab__s
cades85440732cade_s
cadets96316512cadets
cadgers114712002cadgers
cadres94017932cadres
cafes106426922cafe_s
cager85229222cager_
cages85936012cage_s
cahiers123510672cahiers
cakes116037672cake_s
calibers1238522calibers
calkers134414692calkers
callers94221962callers
camber124418482camber_
camels105217082camels
cameos105818002cameos
camera10313692camera
cameras11313362cameras
cames97047312came_s
campers134220292campers
cancers114018582cancers
caner75334772caner_
canes75350372cane_s
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
caper94831622caper_
capes95441922cape_s
cappers134419402cappers
carders104820352carders
careers95218782careers
carer74942332carer_
cares77369182care_s
caress85720262caress
carets85330772carets
carpers114521252carpers
carrs75730852ca_rrs
cars67364762ca__rs
carters95327252carters
carvers124817532carvers
casern84713312casern
caserns94711222caserns
cases75048382case_s
casters94729902casters
cater74840722cater_
cates75951892cate_s
causers94014792causers
caver105629062caver_
cavern115312452cavern
caverns124510252caverns
caves105639702cave_s
ceders93817672ceders
chafers154512742chafers
chambers173410622chambers
chasers123714922chasers
chawers154412052chawers
cheers114518912cheers
ciders94620092ciders
citers85022982citers
clabbers14359902clabbers
clambers144211292clambers
clavers124314902clavers
clawers123910972clawers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
coders95426982coders
combers134516622combers
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
covers114627962covers
cowers114625532cowers
crabbers14358752crabbers
craters95021892craters
cravers124416552cravers
criers83918582criers
cubebs12508682cubebs
cuber95222532cuber_
cubes95028162cube_s
cumbers134515412cumbers
curbers115514382curbers
curers84923192curers
cyber124910382cyber_
cyders12398832cyders
dabbers123813212dabbers
darers75921872darers
daters74827372daters
daubers104610422daubers
eagers74523682eagers
eaters65535952eaters
embers104116182embers
fablers124812612fablers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
fibers114717522fibers
gabbers124612832gabbers
gagers84021332gagers
gamers94420832gamers
gapers94520472gapers
gaters74728642gaters
gazers164516302gazers
gibers95114662gibers
halers94926912halers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
jabbers183610582jabbers
jagers144415722jagers
japers154616172japers
jibers155912882jibers
kabars124513952kabars
labels84515682labels
labors84016412labors
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lambers113817112lambers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
libers84721442libers
mabes96331532mabe_s
macers105321272macers
makers123921732makers
masers84623452masers
maters85032392maters
mazers173917092mazers
nabbers113710462nabbers
nabes75427092nabe_s
namers84517332namers
oaters65029792oaters
ombers104214402ombers
pacers105124542pacers
pagers94423252pagers
papers105125322papers
parers85530742parers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
saber75330242saber_
sabes76437462sabe_s
sabirs85414632sabirs
sabres85520862sabres
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scalers93817262scalers
scarers94618512scarers
sobers85218862sobers
subers85722642subers
taber73825822taber_
tabes76033922tabe_s
tabors84517112tabors
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
tubers85017032tubers
umbers104215212umbers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
webers11310942webers
yabbers14389352yabbers
yagers105114532yagers

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.360496363.9
2DLD Change Limit825512192.61031628.7
3Display Results2192190.0762881.6
 (SQL Overall)1786912193.04658664.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.