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

180 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
banders10432456(None) 
bander93928221bander_
bangers104020351bangers
bankers133919091bankers
banners94018711banners
banters94623111banters
benders104021061benders
binders103920741binders
bonders104120661bonders
branders114313091branders
danders93921181danders
ganders93521701ganders
handers114224331handers
landers84026211landers
panders103423731panders
sanders84025941sanders
wanders114221331wanders
zanders173015791zanders
abiders104011082abiders
adders84315702_adders
aiders74524632_aiders
alders74218422_alders
angers75222542_angers
backers153821882backers
badder103817512badder_
badgers114812642badgers
badness1039572badness
baggers113915692baggers
bailers94221352bailers
baiters94619302baiters
bakers125323452ba_kers
balder95318862balder_
balers85626932ba_lers
balkers134915722balkers
ballers94421012ballers
bandagers1335882bandagers
bandas95120542band_as
bandeau1038522bandeau
bandeaus1146502bandeaus
banded105223172bande_d
banderol1145852banderol
banderols1245952banderols
bandies104124862bandies
bandits103814792bandits
bandogs1138362bandogs
bandora1038812bandora
bandoras1138742bandoras
bandore10611632bandore
bandores11311602bandores
bands85233422band__s
banes74945582ban_e_s
banger94423632banger_
banker124222732banker_
banner84421502banner_
bannets94013842bannets
banter84825332banter_
barbers114317502barbers
bardes95026932barde_s
barkers134318512barkers
barters94223032barters
bashers124820832bashers
basters94930302basters
bathers124720362bathers
batters94626012batters
bawlers124412732bawlers
beaders104120182beaders
bedders113513382bedders
bendees103913862bendees
bender95223302bender_
bidders114012302bidders
biders94822802b_iders
bilanders1235962bilanders
binder94422872binder_
bindery13459822bindery
biners85023632bin_ers
bingers104519982bingers
birders103913262birders
bladders12397802bladders
bladers104214682bladers
blander103715162blander_
blenders115210992blenders
blinders113911142blinders
blunders113911332blunders
boarders11408622boarders
bonder95324782bonder_
boners84825432bon_ers
bonkers134015302bonkers
borders104317532borders
bounders114314102bounders
braiders114110572braiders
brander103915822brander_
branners104010922branners
budders113812102budders
bundlers11399182bundlers
bunkers133715952bunkers
bunters94717112bunters
cancers114018582cancers
candlers114214102candlers
candors104216762candors
caners84629192can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827722canters
carders104820352carders
cinders104617752cinders
dancers103413092dancers
dander811222992dander_
dandlers103912052dandlers
dangers94818212dangers
daunders10278472daunders
enders74324052_enders
faders105117462fa_ders
fanners103914652fanners
fenders113717262fenders
finders113717872finders
funders113813932funders
gadders103611502gadders
gander84322762gander_
gangers94418602gangers
genders93616782genders
glanders103811502glanders
hander104526432hander_
handlers124014142handlers
hangers113120812hangers
hankers144218132hankers
hinders113718502hinders
ladders94115172ladders
laders74927762la_ders
lancers93616642lancers
lander74028482lander_
landlers94312832landlers
lanners73618322lanners
larders83516942larders
lauders84012892lauders
launders9358742launders
lenders84419642lenders
madders113513212madders
mangers103521262mangers
manners93417832manners
maunders11348342maunders
meanders1168832meanders
menders103818802menders
minders103720112minders
padders113312872padders
pander93725522pander_
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pinders103720472pinders
ponders103618842ponders
raiders84615142raiders
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
renders83821672renders
sander74828532sander_
sangers84421942sangers
senders83022352senders
slanders94014012slanders
sonders83820712sonders
standers93514302standers
sunders84120052sunders
tandems1037632tandems
tankers113416912tankers
tanners74018392tanners
tenders83719722tenders
tinders84219172tinders
vanners103612842vanners
venders113717002venders
wadders123812442wadders
waders109120642wa_ders
wander104423712wander_
wankers144514712wankers
wanters104420092wanters
warders113416812warders
winders113721262winders
wonders113315992wonders
yarders113211592yarders
zander163417112zander_

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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711803.08034958.1
3Display Results1801800.0632857.1
 (SQL Overall)1786911803.28354429.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.