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

303 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
belayers1329814(None) 
belayer12339501belayer_
bilayers13296921bilayers
delayers12268661delayers
allayers11156632allayers
beaders104120182be_aders
beakers134216872be_akers
bearers94619592be_arers
beaters94925042be_aters
beavers124417322be_avers
behavers16205612behavers
bejabers1933632bejabers
belabors1236402belabors
belayed133610082belaye_d
belays114313852belay__s
belchers153510022belchers
beliers94617382bel_iers
belters93819412bel_ters
betrayers1445012betrayers
bewrayers1743482bewrayers
bilayer12347802bilayer_
bladers104214682b_laders
blamers115314212b_lamers
blazers184811682b_lazers
bleaters103412322bleaters
brayers124511902b_rayers
decayers14307962decayers
delayer113010532delayer_
elaters74420192_elaters
flayers133912032_flayers
inlayers1135642inlayers
layers93921182__layers
players124313762_players
relaters83218152relaters
relaxers15298262relaxers
slayers104513322_slayers
allayer10148213allayer_
arrayers11125853arrayers
assayers1144843assayers
bakers125323453b__akers
balancers1345063balancers
balases93815433balase_s
balers85626943b__alers
balkers134915723bal_kers
ballers94421013bal_lers
beader94623793be_ader_
beaker125520693be_aker_
beanery1237563be_anery
bearer85323913be_arer_
bears75739043be_a__rs
beater84729393be_ater_
beaver114819253be_aver_
beclamors1574223beclamors
bedders113513383be_dders
bediapers1444333bediapers
bedmakers1844383bedmakers
beepers113612383be_epers
beers75628393be___ers
beetlers1037403beetlers
beezers18349243be_ezers
beflowers17165823beflowers
begazes1937963begaze_s
beglamors1473373beglamors
behaver15206723behaver_
behaves15198523behave_s
beheaders1545153beheaders
bejabbers1971953bejabbers
belabor1136293belabor_
belabours1343543belabours
belaced124112153belace_d
beladies11310423beladies
belated103520013belate_d
belauds1036643bela_uds
belay105021523belay___
belaying143110603belaying
belcher143511493belcher_
belches143514343belche_s
beldames1336803beldame_s
beleaguers1342373beleaguers
beliefs12448583bel_iefs
belier84423563bel_ier_
belies84631053bel_ie_s
believers14346633believers
belleeks1444363belleeks
belles85325993bel_le_s
bellies94023723bellie_s
bellowers14177623bellowers
beloveds14153963beloveds
belter84720963bel_ter_
beltless10297713beltless
benames112814603bename_s
benchers153611013benchers
benders104021063be_nders
berakes134815773berake_s
berates94126873berate_s
bereavers1446123bereavers
betakes134212523betake_s
betatters1134963betatters
betrayer1345643betrayer_
betters94422093be_tters
bevelers13389463bevelers
bewailers1434233bewailers
bewares12313373beware_s
bewrayer1643733bewrayer_
bilanders1235963bilanders
bilkers134711863bil_kers
billers94720833bil_lers
blabbers11308153b_labbers
bladders12397803b_ladders
blader93618583b_lader_
blades95221253b_lade_s
blamer104417143b_lamer_
blames105121863b_lame_s
blares85021633b_lare_s
blasters104116143b_lasters
blathers134713793b_lathers
blatters104414093b_latters
blazer174414023b_lazer_
blazes174817353b_laze_s
bleachers16297923bleachers
bleaker133510533bleaker_
blears85116453blea__rs
bleater94515303bleater_
bleeders11448453bleeders
bleepers12377493bleepers
blenders115211003blenders
blessers10277633blessers
blethers13429613blethers
bloaters103311023bloaters
blowers124313593b_lowers
boaters93419243b_oaters
bolases93315003bolase_s
bolsters103712453bolsters
bolters94017803bol_ters
bowyers15438733b_owyers
bracers114616703b_racers
bravers124715523b_ravers
brayer115315313b_rayer_
brazers184513943b_razers
breakers143810973breakers
bulgers105215143bul_gers
buyers114511003b__uyers
byliners1334753byliners
caloyers1337343caloyers
cellarers11236503cellarers
clavers124314903_clavers
clawers123910973_clawers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
dealers84118613de_alers
debasers11377903debasers
debaters113511923debaters
decayer13339353decayer_
declarers1236423declarers
decoyers14287713decoyers
defacers14237993defacers
defamers14258523defamers
deflaters13298703deflaters
defrayers1644173defrayers
delates83526283delate_s
delators92314833delators
delayed123310763delaye_d
delays104014053delay__s
delivers123310753delivers
deluders10156433deluders
delvers113411993del_vers
deployers1545063deployers
dewaters122910723dewaters
dilaters92513063dilaters
eagers74523683_e_agers
eaters65535953_e_aters
elater64724203_elater_
elates65032363_elate_s
elders74817303_el_ders
elopers95112943_elopers
eluders8409913_eluders
elvers93814983_el_vers
erasers74413943_erasers
essayers1133563essayers
evaders1136933_evaders
eyers86521333_e__yers
fearers104815273fe_arers
felafels1452853felafels
fellers104117543fel_lers
flakers143613273_flakers
flamers124616363_flamers
flayer124713563_flayer_
flyers125712803_fl_yers
forayers14277273forayers
gelates83219593gelate_s
gelders93812573gel_ders
glazers174410043_glazers
gleamers11306563gleamers
gleaners9348073gleaners
hayers124415943__hayers
headers113819393he_aders
healers104319463he_alers
heapers123616673he_apers
hearers104319783he_arers
heaters104225223he_aters
heavers133717193he_avers
hellers103619833hel_lers
helpers123311853hel_pers
inlayer1036933inlayer_
kelters113813753kel_ters
lacers85225253__lacers
laders74927763__laders
lagers74826143__lagers
lakers105225153__lakers
lasers64925703__lasers
lavers94526363__lavers
lawyers13377153__lawyers
layer84626473__layer_
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leavers103717783le_avers
meaners94415243me_aners
melders103213913mel_ders
melters93918313mel_ters
menacers12279313menacers
metamers1249623metamers
minelayers1543453minelayers
mislayers1445943mislayers
negaters9349783negaters
obeyers1234813obe__yers
palavers1337993palavers
payers114621823__payers
pedalers11239393pedalers
pelages10714613pelage_s
pelters93720313pel_ters
placers114515263_placers
planers94517953_planers
platers93924093_platers
player115215213_player_
pleaders113210193pleaders
pleasers104010293pleasers
pleaters103613793pleaters
plyers114912983_pl_yers
prayers124212853_prayers
readers83823773re_aders
realters83614043realters
reamers94221083re_amers
reapers93520453re_apers
rearers74323563re_arers
reavers108320743re_avers
rebaters103413943rebaters
regalers94311133regalers
relabels1045343relabels
relaces93420883relace_s
relapsers1164123relapsers
relater73723143relater_
relates73731433relate_s
relators83316133relators
relaxer143410223relaxer_
relaxes143215323relaxe_s
relayed113212753relaye_d
relays94316753relay__s
releasers937323releasers
reliers75519213rel_iers
reloaders1036423reloaders
remakers143811303remakers
repapers1258833repapers
replacers13266833replacers
retakers123511133retakers
sayers94221593__sayers
sealers74323553se_alers
seamers94719433se_amers
seaters74028943se_aters
sellers73721323sel_lers
seltzers1735063seltzers
slakers114115753_slakers
slaters73123733_slaters
slavers103716503_slavers
slayer93916333_slayer_
solacers10268893solacers
sprayers13367053sprayers
stayers103813633_stayers
strayers113510143strayers
swayers13398853_swayers
tearers75218233te_arers
teasers75317243te_asers
telfers10299083tel_fers
tellers73717613tel_lers
telphers1335473telphers
vealers103214293ve_alers
velars93913723vela__rs
veligers1237023veligers
vilayets1443073vilayets
waylayers1842943waylayers
weaners104613833we_aners
wearers104615903we_arers
weavers133714463we_avers
welchers16338053welchers
welders113313413wel_ders
welshers14246813welshers
welters103516063wel_ters
yeasayers1542023yeasayers
yellers103912953yel_lers
yelpers12348203yel_pers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623037.25020160.3
3Display Results3033030.1232463.4
 (SQL Overall)1786913037.79622920.9
 
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.