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 “bendays” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

254 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
bendays1332751(None) 
benday123810811benday_
bendways1743731bendways
bendys12518381bend_ys
bandas95120542banda_s
belays114313852be_lays
beldams1237052beldams
bendayed1534872bendayed
bendees103913862bendees
benders104021062benders
bends85628972bend__s
bendy115017252bend_y_
betrays12127822betrays
bewrays15145112bewrays
endways1444442_endways
heydays1734142heydays
sendals81912262sendals
agendas936933agenda_s
badass949293b_adass
banda85223103banda__
bandage11311023bandage
bandages12310633bandages
bandaid11310483bandaid
bandana10179463bandana
bandanas11178573bandanas
bandeaus1146503bandeaus
banders104324563banders
bandies104124863bandies
bandits103814793bandits
bandogs1138363bandogs
bands85233423band__s
bandsaws1444623bandsaws
bandy114824183band_y_
banians9312033banians
bantams1149063bantams
banyans1237913banyans
banzais1837163banzais
bays97143913b___ays
beaders104120183beaders
beadles103414733beadles
beads85429503be__ads
beady114719923bead_y_
beaks115326623be__aks
beams95328173be__ams
beanbags1342863beanbags
beans75734693be__ans
bears75739043be__ars
beats76042243be__ats
beaus75127113be__aus
becaps123811403be_caps
bedamn1137813be_damn
bedamns1235733be_damns
bedaub1146033be_daub
bedaubs1233693be_daubs
bedders113513383bedders
bedels94015273be_dels
bedews12398943be_dews
bedims1149593be_dims
bedlams1237053bedlams
bedpans1237173bedpans
beds75937783be_d__s
beedies10314203beedies
beflags1355493beflags
beggars11378223beggars
beglads11127263beglads
beheads1338523beheads
belady12489933belady_
belay105021523be_lay_
beldam11410113belda_m
beldame1237233beldame
beldames1336803beldames
beleaps1138053beleaps
belgas9311713belga_s
beltways1683903beltways
bemadams1543383bemadams
bemas96424283be_ma_s
bemeans1148743bemeans
bemoans1138253bemoans
benadryl1451823benadryl
benadryls1561443benadryls
bename103316073ben_ame
benames112814603benames
benches143918603benches
bend76435263bend___
bendable131510853bendable
bendaying1634953bendaying
bended105521233bend_ed
bendee94121023bend_ee
bender95223303bend_er
bendier103111413bendier
bendiest112311983bendiest
bending114420893bending
bendwise1443413bendwise
beneath1236973beneath
benes75536233ben__es
bennes86019013ben_nes
bennets94712163bennets
bennies93917313bennies
bennis84314803ben_nis
benny105217363ben_ny_
benomyl1443453benomyl
benomyls1542983benomyls
bens65945703ben___s
benthos1238373benthos
bentos86218303ben_tos
bents76033693ben__ts
benumbs1333543benumbs
benzal1739643benza_l
benzins1838693benzins
benzols1836673benzols
benzoyl2143363benzoyl
benzoyls2242443benzoyls
benzyl2034163ben_zyl
benzyls2133673benzyls
betas75528763be_ta_s
betray111511443betray_
bettas84913923betta_s
bewraps14135403bewraps
bewray14147733bewray_
beys913829553be___ys
bezoars1836793bezoars
binders103920743binders
bindis94614583bind_is
bindles104016453bindles
binds86627473bind__s
blenders115210993blenders
blendes104713683blend_es
blends96012883blend__s
bondage1138253bondage
bondages1237893bondages
bonders104120663bonders
bonds86126843bond__s
bonducs1235553bonducs
brays106723113b__rays
bridals1038623bridals
bunas75126573bun_a_s
bundles103515773bundles
bunds85523543bund__s
bundts95010843bund_ts
bunyas11359433bunya_s
byplays1743103byplays
byways1734673b_yways
cedars93312833ce_dars
centals94317053centals
centas85020703centa_s
days87637133___days
decays124612913de_cays
dedans85915073de_dans
deejays1843433deejays
defrays1436113defrays
delays104014053de_lays
denars74621433den_ars
denials84114133denials
dentals83915393dentals
deodars937623deodars
derays105514253de_rays
embays131408333_embays
endash10297123_endash
endears83710053_endears
enders74324053_enders
endows104610423_endows
endplays14123773_endplays
ends56528523_end__s
endues73813903_endues
enjoys1644603_enjoys
envoys1255143_envoys
essays965653_essays
fenders113717263fenders
fends96324973fend__s
genders93616783genders
genoas74013623genoa_s
headways1845003headways
hendiadys1741663hendiadys
henleys1334843henleys
hennas94211803henna_s
henrys12366103hen_rys
heyday1635143heyday_
heydeys1732863heydeys
hondas10313353honda_s
inlays9389873_inlays
jetways2094053jetways
keddahs1642923keddahs
kenafs1337113ken_afs
kendos114510663kend_os
keyways2043373keyways
landaus8310343landaus
leeways1354453leeways
lenders84419643lenders
lends65326253lend__s
maydays1634493maydays
medals94218053me_dals
menads95514383men_ads
menders103818803menders
mends84927693mend__s
menials94015683menials
mensas85115863mensa_s
middays14335663middays
nays75931593__n_ays
nongays11176533nongays
noondays1242883noondays
onlays9398713_onlays
pandas95521963panda_s
paydays1634433paydays
pedals94316033pe_dals
pendant10314853pendant
pendants1139093pendants
pends85527193pend__s
pentads1039523pentads
qindars17267423qindars
randans8313213randans
redans75421023re_dans
redbays1336013redbays
relays94316753re_lays
renders83821673renders
rends65129953rend__s
rentals74017473rentals
repays113813973re_pays
replays12399763replays
resays93714153re_says
runways13134443runways
sandals82715203sandals
seaways13307513seaways
sedans74816093se_dans
sendal73314993senda_l
senders83022353senders
sends65528243send__s
sendups10115193sendups
sennas64214233senna_s
serdabs1035323serdabs
sundaes8313093sundaes
sunrays1037083sunrays
tenders83719723tenders
tendons8311473tendons
tends65425583tend__s
tendus75111183tend_us
tenias64720073tenia_s
todays10458103_todays
unlays93810493_unlays
unsays9399543_unsays
vandals113211663vandals
vandas103915993vanda_s
veejays2042313veejays
vendace1357363vendace
vendaces1457183vendaces
vendees114011453vendees
venders113717003venders
vendors113510223vendors
vends95520893vend__s
vendues11318623vendues
weekdays1941433weekdays
wends95822813wend__s
windways1845043windways
xenias133712973xenia_s
yentas94614213yenta_s

Search took 8 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 Filter1786911340270.436409841.7
2DLD Change Limit1340272547.44018014.4
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.96922423.3
 
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.