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

217 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
sayers9422159(None) 
hayers124415941hayers
layers93921181layers
payers114621821payers
sabers85224731sabers
sakers104125431sakers
savers93825921savers
sawers94620161sawers
sawyers13317531sawyers
sayeds10469251sayeds
sayer84926551sayer_
shyers124712201shyers
slayers104513321slayers
stayers103813631stayers
swayers13398851swayers
agers65027852_agers
apers76629132_apers
askers105915402askers
aspers86220312aspers
assayers1144842assayers
asters65631602asters
avers85127312_avers
ayes76543512_aye_s
bakers125323452bakers
balers85626932balers
brayers124511902brayers
buyers114511002buyers
cabers105023922cabers
cagers95624192cagers
caners84629202caners
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
darers75921872darers
daters74827372daters
dryers10449272dryers
dyers96617132_dyers
eagers74523682eagers
eaters65535952eaters
essayers1133562essayers
eyers86521332_eyers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
flayers133912032flayers
flyers125712802flyers
foyers125413132foyers
fryers125710972fryers
gagers84021332gagers
gamers94420832gamers
gapers94520472gapers
gaters74728642gaters
gayer94519192gayer_
gazers164516302gazers
halers94926912halers
haters94930402haters
havers124721482havers
hayer114620242hayer_
hazers184615952hazers
jagers144415722jagers
japers154616172japers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
lawyers13377152lawyers
layer84626472layer_
macers105321272macers
makers123921732makers
masers84623452masers
maters85032392maters
mayors115714192mayors
mazers173917092mazers
namers84517332namers
oaters65029792oaters
oyers87620882_oyers
pacers105124542pacers
pagers94423252pagers
papers105125322papers
parers85530742parers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payees114812902payees
payer105125722payer_
payors114312642payors
players124313762players
plyers114912982plyers
prayers124212852prayers
pryers115012242pryers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
saber75330242saber_
sabes76437462sabe_s
sabirs85414632sabirs
sabres85520862sabres
sackers133820222sackers
sades65239892sade_s
safer84721812safer_
safes85226722safe_s
sager65432052sager_
sages65339062sage_s
saggers94017082saggers
sailers73822322sailers
saker95132022saker_
sakes95540752sake_s
saleps85014902saleps
sales56055592sale_s
salters73622252salters
salvers103916002salvers
sameks12409322sameks
sanders84025942sanders
saner54334322saner_
sanes55649072sane_s
sangers84421942sangers
sapors84118812sapors
sappers113518902sappers
sarees65329942sarees
sates54949322sate_s
satyrs937962satyrs
saucers93712132saucers
saugers83914052saugers
saver84831252saver_
saves85838632save_s
savors95616102savors
sawer85026212sawer_
sawyer12438042sawyer_
saxes125229342saxe_s
sayed96127142saye_d
sayest94217742sayest
sayids104310972sayids
says75942102say__s
scalers93817262scalers
scarers94618512scarers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
seders74420282seders
seers55136382s_eers
sers45746652s__ers
severs94121122severs
sewers94719722sewers
shaders115915552shaders
shakers144015562shakers
shapers124016892shapers
sharers104720622sharers
shavers134115092shavers
sheers94322402sheers
shiers94921752shiers
shoers94518332shoers
shyer114714782shyer_
sivers95324152sivers
sizers155215812sizers
skaters113512962skaters
skiers104713702skiers
slakers114115752slakers
slaters73123732slaters
slavers103716502slavers
slayer93916332slayer_
slyer85515122slyer_
snarers74216662snarers
sneers64016172sneers
snyes85012752snye_s
soakers114114952soakers
soapers93715922soapers
soarers74118092soarers
sobers85218862sobers
sowers94923442sowers
spacers113813872spacers
spaders104214472spaders
sparers94519612sparers
speers85019952speers
spiers84421742spiers
sprayers13367052sprayers
stagers84116672stagers
starers74522312starers
staters73922342staters
stayer94516482stayer_
steers63820982steers
strayers113510142strayers
styes86316522stye_s
stylers10359352stylers
subers85722642subers
suers55128482s_uers
supers84622402supers
swagers114211022swagers
swayer125210972swayer_
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
toyers95516332toyers
tuyers94612562tuyers
twyers12497412twyers
tyers86220052_tyers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
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.343520965.0
2DLD Change Limit825512172.56332208.7
3Display Results2172170.0932333.3
 (SQL Overall)1786912172.99959583.5
 
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.