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

168 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
bangers10402035(None) 
angers75222541_angers
badgers114812651badgers
baggers113915691baggers
banders104324561banders
banger94423641banger_
bankers133919091bankers
banners94018711banners
banters94623121banters
bingers104519991bingers
dangers94818211dangers
gangers94418601gangers
hangers113120811hangers
mangers103521261mangers
rangers83621041rangers
sangers84421941sangers
agers65027852_a_gers
aggers85817792_aggers
angels74416172_angels
anger66225882_anger_
anglers84014822_anglers
augers73818702_augers
backers153821892backers
badger105415082badger_
badges103917372badge_s
bagels95712312ba_gels
bagger104619202bagger_
bailers94221352bailers
baiters94619312baiters
bakers125323452ba_kers
balers85626942ba_lers
balkers134915722balkers
ballers94421012ballers
bandagers1335882bandagers
bander93928222bander_
banes74945582ban_e_s
banged104923732bange_d
bangles103617412bangles
bangs85627782bang__s
banker124222732banker_
banner84421502banner_
bannets94013842bannets
banter84825342banter_
barbers114317502barbers
bargees105415872bargees
barges94528252barge_s
barkers134318512barkers
barters94223052barters
bashers124820832bashers
basters94930312basters
bathers124720362bathers
batters94626022batters
bawlers124412732bawlers
benders104021062benders
binders103920742binders
biners85023632bin_ers
binger94923452binger_
binges93923122binge_s
blungers11469852blungers
bonders104120662bonders
boners84825432bon_ers
bonkers134015302bonkers
boogers104514632boogers
braggers12327902braggers
branders114313092branders
branners104010922branners
bringers112811072bringers
budgers114314922budgers
buggers114315662buggers
bulgers105215142bulgers
bungees104513102bungees
bunglers11398482bunglers
bunkers133715952bunkers
bunters94717122bunters
burgers103918572burgers
cadgers114712002cadgers
cagers95624192ca_gers
cancers114018582cancers
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
changers144313202changers
clangers114312342clangers
congers104223232congers
daggers103714912daggers
dancers103413092dancers
danders93921182danders
danger83722832danger_
danglers103610592danglers
dingers94321382dingers
eagers74523682ea_gers
fanners103914652fanners
fingers113418432fingers
flangers123311372flangers
gagers84021332ga_gers
gaggers103413662gaggers
ganders93521702ganders
ganger83721472ganger_
gaugers94211712gaugers
gingers94118642gingers
grangers103011972grangers
handers114224332handers
hangars114313492hangars
hanger104023262hanger_
hankers144218132hankers
hingers113420212hingers
hungers114013302hungers
jaegers15307102jaegers
jagers144415722ja_gers
jaggers164012892jaggers
janglers16319372janglers
laagers83411252laagers
lagers74826142la_gers
laggers94216242laggers
lancers93616642lancers
landers84026222landers
langurs889102langurs
lanners73618332lanners
lingers84223302lingers
longers84819542longers
lungers83817102lungers
managers112911002managers
mangels103614492mangels
manger94325012manger_
manges94628952mange_s
manglers113311902manglers
manners93417832manners
mongers104217272mongers
naggers93812652naggers
onagers838102onagers
pagers94423252pa_gers
panders103423742panders
pangens103112072pangens
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pingers104020742pingers
ranger73925532ranger_
ranges73826932range_s
rankers113217462rankers
ranters73323642ranters
ringers83922952ringers
saggers94017082saggers
sanders84025942sanders
sangars83116252sangars
sanger74524572sanger_
saugers83914052saugers
singers83824702singers
taggers93514192taggers
tanagers9259002tanagers
tanglers92911972tanglers
tankers113416912tankers
tanners74018392tanners
tongers84116012tongers
twangers12226062twangers
vanners103612842vanners
wagers105122212wa_gers
waggers124613082waggers
wanders114221332wanders
wanglers123310032wanglers
wankers144514712wankers
wanters104420092wanters
wingers113921482wingers
yagers105114532ya_gers
zanders173015792zanders
zingers173514852zingers

Search took 5 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 Filter1786911076710.733243780.4
2DLD Change Limit1076711683.95327237.8
3Display Results1681680.0632666.7
 (SQL Overall)1786911684.74937627.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.