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

276 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
balers8562693(None) 
bailers94221351bailers
bakers125323451bakers
baler75635271baler_
bales76250081bale_s
balkers134915721balkers
ballers94421011ballers
bawlers124412731bawlers
halers94926911halers
talers64628141talers
walers94824461walers
abasers95311972abasers
abaters95115202abaters
abler75624312abler_
ables75935542able_s
agers65027852_agers
alders74218422_alders
alecs76620732_alecs
alefs87319662_alefs
alert54740652_alert
alerts64418222_alerts
ales47067102_ale_s
alters64924222_alters
apers76629132_apers
avers85127312_avers
babblers113510352babblers
babels105216722babels
babes95834112babe_s
backers153821882backers
badgers114812652badgers
bafflers16356592bafflers
bagels95712312bagels
baggers113915692baggers
bailees93914382bailees
bailer85425252bailer_
baileys12388932baileys
bailors93212412bailors
baiters94619302baiters
baker115629542baker_
bakery155911002bakery
bakes117035372bake_s
balas76937212bal_as
balder95318862balder_
balds85524642bal_ds
bale66353842bale__
baled85436442bale_d
baleen8613052baleen
baleens938472baleens
balker124519162balker_
balks114926292bal_ks
baller83825202baller_
ballets93719512ballets
balls76236412bal_ls
balms95723922bal_ms
bals66354042bal__s
balsas86417522balsas
banders104324562banders
banes74945582bane_s
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
barbers114317502barbers
barer74535802barer_
bares75457132bare_s
barkers134318512barkers
barless94317002barless
barleys125011842barleys
barres84427542barres
bars66564092ba__rs
barters94223032barters
baser74828922baser_
bases75644352base_s
bashers124820832bashers
basters94930302basters
bates75846342bate_s
bathers124720362bathers
batters94626012batters
battlers104110972battlers
bawler114315052bawler_
bazars174613112bazars
beaders104120182beaders
beakers134216872beakers
bearers94619592bearers
beaters94925042beaters
beavers124417322beavers
beers75628392b_eers
beliers94617382beliers
belters93819412belters
biders94822802biders
biers76225222b_iers
bikers124517552bikers
biles75542142bile_s
bilkers134711862bilkers
billers94720832billers
biners85023632biners
birlers93813002birlers
biters83925242biters
bladers104214682bladers
blamers115314212blamers
blares85021632blares
blazers184811682blazers
blears85116452b_lears
blebs96416152b_lebs
bless75917812b_less
blets75324942b_lets
blurs74619082b_lurs
boaters93419242boaters
boilers93417062boilers
bolero8412092bolero
boleros9310292boleros
boles75448602bole_s
bolters94017802bolters
boners84825432boners
borers85122682borers
bowers115523702bowers
bowlers123715782bowlers
boxers155013482boxers
bracers114616702bracers
braless92910562braless
bravers124715522bravers
brawlers13408642brawlers
brayers124511902brayers
brazers184513942brazers
briers85319732briers
buglers105115322buglers
bulgers105215142bulgers
burlers94120272burlers
butlers94518052butlers
buyers114511002buyers
cabers105023922cabers
cablers114416712cablers
cagers95624192cagers
calkers134414692calkers
callers94221962callers
caners84629202caners
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
coalers94419352coalers
dales66439742dale_s
darers75921872darers
daters74827372daters
dealers84118612dealers
dialers83614302dialers
eagers74523682eagers
eaters65535952eaters
fablers124812612fablers
facers115519442facers
faders105117462faders
fakers134219532fakers
fallers103917992fallers
falters103916472falters
farers95924052farers
filers94623722filers
gagers84021332gagers
galeas74618512galeas
galere73716672galere
galeres83514332galeres
gales65442482gale_s
gamers94420832gamers
gaolers83511562gaolers
gapers94520472gapers
gaters74728642gaters
gazers164516302gazers
hailers104017262hailers
haler85033522haler_
haleru94212072haleru
hales85449842hale_s
halters104619802halters
halvers133311422halvers
haters94930402haters
haulers104012442haulers
havers124721482havers
hayers124415942hayers
hazers184615952hazers
healers104319462healers
idlers74012812idlers
jagers144415722jagers
jailers144114042jailers
japers154616172japers
kales95730982kale_s
lacers85225252lacers
laders74927762laders
ladlers84613572ladlers
lagers74826142lagers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
macers105321272macers
mailers94420332mailers
makers123921732makers
malars85020682malars
males75049792male_s
masers84623452masers
maters85032392maters
maulers94213302maulers
mazers173917092mazers
milers84625162milers
nailers73215892nailers
naleds7469132naleds
namers84517332namers
oaters65029792oaters
oglers74313182oglers
oilers64721192oilers
pacers105124542pacers
pagers94423252pagers
paler75436932paler_
pales75753802pale_s
palets85122312palets
palmers113513622palmers
palters94021682palters
papers105125322papers
parers85530742parers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
polers84225642polers
pulers83820282pulers
racers84725432racers
railers74420662railers
rakers104123572rakers
rales54947492rale_s
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
rulers64317092rulers
sabers85224732sabers
sailers73822322sailers
sakers104125432sakers
saleps85014902saleps
sales56055592sale_s
salters73622252salters
salvers103916002salvers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scalers93817262scalers
sealers74323552sealers
tabers84621572tabers
tailers73720182tailers
takers103923742takers
talars66021682talars
taler56034862taler_
tales55451372tale_s
talkers113513212talkers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
thalers106212262thalers
tilers63523502tilers
vales85434262vale_s
valets93715622valets
valors93413772valors
valuers10328942valuers
vealers103214292vealers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wailers103916802wailers
wakers134822492wakers
waler84229262waler_
wales86142832wale_s
walkers143411472walkers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
whalers13529702whalers
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.376475242.0
2DLD Change Limit825512762.62331472.0
3Display Results2762760.0962875.0
 (SQL Overall)1786912763.09557735.4
 
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.