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 “sakers” 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.

279 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
sakers10412543(None) 
askers105915401askers
bakers125323451bakers
fakers134219531fakers
lakers105225151lakers
makers123921731makers
rakers104123571rakers
sabers85224731sabers
sackers133820221sackers
saker95132021saker_
sakes95540751sake_s
savers93825921savers
sawers94620161sawers
sayers94221591sayers
shakers144015561shakers
slakers114115751slakers
soakers114114951soakers
takers103923741takers
wakers134822491wakers
agers65027852_agers
akees96119242_akees
apers76629132_apers
asker96418782asker_
aspers86220312aspers
asters65631602asters
avers85127312_avers
backers153821882backers
baker115629542baker_
bakery155911002bakery
bakes117035372bake_s
balers85626932balers
balkers134915722balkers
bankers133919092bankers
barkers134318512barkers
beakers134216872beakers
bikers124517552bikers
cabers105023922cabers
cagers95624192cagers
cakes116037672cake_s
calkers134414692calkers
caners84629202caners
cankers134418752cankers
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
dackers143417042dackers
daikers124010312daikers
darers75921872darers
daters74827372daters
dikers114418792dikers
eagers74523682eagers
eaters65535952eaters
eskers105312222eskers
facers115519442facers
faders105117462faders
fakeers14446672fakeers
faker124824592faker_
fakery16509262fakery
fakes126032482fake_s
fakirs13468082fakirs
farers95924052farers
flakers143613272flakers
gagers84021332gagers
gamers94420832gamers
gapers94520472gapers
gaters74728642gaters
gawkers15347452gawkers
gazers164516302gazers
hackers164619042hackers
hakes126034302hake_s
halers94926912halers
hankers144218132hankers
haters94930402haters
havers124721482havers
hawkers174210332hawkers
hayers124415942hayers
hazers184615952hazers
hikers135014352hikers
ickers123914182ickers
inkers104018832inkers
jackers204214452jackers
jagers144415722jagers
jakes165023642jake_s
japers154616172japers
jokers175511192jokers
lacers85225252lacers
lackers134120542lackers
laders74927762laders
lagers74826142lagers
laker95432872laker_
lakes95737652lake_s
larkers113014512larkers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
leakers113415422leakers
likers104620912likers
macers105321272macers
makars124612632makars
maker114127812maker_
makes115336852make_s
markers133516102markers
masers84623452masers
maskers133913842maskers
maters85032392maters
mazers173917092mazers
namers84517332namers
oaters65029792oaters
ockers123813902ockers
pacers105124542pacers
packers153818892packers
pagers94423252pagers
papers105125322papers
parers85530742parers
parkers133816872parkers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
pikers124717392pikers
pokers124617922pokers
quakers20309692quakers
racers84725432racers
rackers134320452rackers
rakees104516972rakees
raker94529792raker_
rakes94440352rake_s
rankers113217462rankers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
saber75330242saber_
sabes76437462sabe_s
sabirs85414632sabirs
sabres85520862sabres
sacker125124842sacker_
sades65239892sade_s
safer84721812safer_
safes85226722safe_s
sager65432052sager_
sages65339062sage_s
saggers94017082saggers
sailers73822322sailers
sake85244962sake__
sakis95323672sak_is
saleps85014902saleps
sales56055592sale_s
salters73622252salters
salvers103916002salvers
sameks12409322sameks
sanders84025942sanders
saner54334322saner_
sanes55649072sane_s
sangers84421942sangers
sapors84118812sapors
sappers113518902sappers
sarees65329942sarees
sates54949322sate_s
satyrs937962satyrs
saucers93712132saucers
saugers83914052saugers
saver84831252saver_
saves85838632save_s
savors95616102savors
sawer85026212sawer_
sawyers13317532sawyers
saxes125229342saxe_s
sayeds10469252sayeds
sayer84926552sayer_
scalers93817262scalers
scarers94618512scarers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
seders74420282seders
seekers113712332seekers
seers55136382s_eers
sers45746652s__ers
severs94121122severs
sewers94719722sewers
shaders115915552shaders
shaker134319462shaker_
shakes135024592shake_s
shapers124016892shapers
sharers104720622sharers
sharkers154011052sharkers
shavers134115092shavers
sheers94322402sheers
shiers94921752shiers
shoers94518332shoers
shyers124712202shyers
siker95326032siker_
sikes96236082sike_s
sinkers113618542sinkers
sivers95324152sivers
sizers155215812sizers
skankers11316482skankers
skaters113512962skaters
skees95023122s_kees
skegs105011232s_kegs
skeps115614252s_keps
skews125413802s_kews
skiers104713702skiers
slackers143812742slackers
slaker104219272slaker_
slakes104021882slake_s
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
smackers16318712smackers
smokers13389322smokers
snackers143010222snackers
snakes103919602snake_s
snarers74216662snarers
sneakers12308642sneakers
sneers64016172sneers
soaker105717532soaker_
soapers93715922soapers
soarers74118092soarers
sobers85218862sobers
sokes95031422soke_s
sowers94923442sowers
spacers113813872spacers
spaders104214472spaders
spankers14369862spankers
sparers94519612sparers
sparkers144111312sparkers
speakers14299452speakers
speers85019952speers
spiers84421742spiers
spikers135311992spikers
stackers143413562stackers
stagers84116672stagers
stakes103927292stake_s
stalkers12369852stalkers
starers74522312starers
starkers123712392starkers
staters73922342staters
stayers103813632stayers
steers63820982steers
stokers114515182stokers
subers85722642subers
suckers133717622suckers
suers55128482s_uers
sulkers113613342sulkers
supers84622402supers
swagers114211022swagers
swayers13398852swayers
sykes124816862syke_s
tabers84621572tabers
tackers134319622tackers
taker95229002taker_
takes94437792take_s
talers64628142talers
talkers113513212talkers
tamers84224032tamers
tankers113416912tankers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
tokers104818892tokers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakens135012042wakens
waker125526592waker_
wakes126633652wake_s
walers94824462walers
walkers143411472walkers
wankers144514712wankers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
yagers105114532yagers
yakkers13304272yakkers

Search took 3 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.326548131.9
2DLD Change Limit825512792.42334069.7
3Display Results2792790.0933000.0
 (SQL Overall)1786912792.84262875.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.