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

144 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
bejabers193363(None) 
bejabbers1971951bejabbers
beaders104120182be_aders
beakers134216872be_akers
bearers94619592be_arers
beaters94925042be_aters
beavers124417322be_avers
behavers16205612behavers
bejeebers2042282bejeebers
belabors1236402belabors
belayers13298142belayers
babels105216723b__abels
babes95834113b__abe_s
bakers125323453b__akers
balers85626933b__alers
barbers114317503b_arbers
beader94623793be_ader_
beaker125520693be_aker_
beanery1237563be_anery
bearer85323913be_arer_
bears75739043be_a__rs
beater84729393be_ater_
beaver114819253be_aver_
bedders113513383be_dders
bediapers1444333bediapers
bedmakers1844383bedmakers
beebees1138013be_ebees
beepers113612383be_epers
beers75628393be___ers
beetlers1037403beetlers
beezers18349243be_ezers
begazes1937963begaze_s
behaver15206723behaver_
behaves15198523behave_s
beheaders1545153beheaders
bejewels2042493bejewels
belabor1136293belabor_
belabours1343543belabours
belayer12339503belayer_
belchers153510023belchers
beliers94617383be_liers
belters93819413be_lters
benames112814603bename_s
benchers153611013benchers
benders104021063be_nders
berakes134815773berake_s
berates94126873berate_s
berberis1246603be_rberis
bereavers1446123bereavers
beriberi1243453beriberi
beriberis1343523beriberis
betakes134212523betake_s
betatters1134963betatters
betrayers1445013betrayers
betters94422093be_tters
bevelers13389463bevelers
bewailers1434233bewailers
bewares12313373beware_s
bewrayers1743483bewrayers
bibbers103911353b_ibbers
bilayers13296923bilayers
blabbers11308153blabbers
bladers104214683b_laders
blamers115314213b_lamers
blazers184811683b_lazers
bleaters103412323bleaters
bloaters103311023bloaters
blubbers11408143blubbers
boaters93419243b_oaters
bobbers103614283b_obbers
bombers134512593b_ombers
bracers114616703b_racers
bravers124715523b_ravers
brayers124511903b_rayers
brazers184513943b_razers
breakers143810973breakers
bribers114111503b_ribers
cabers105023923__cabers
dealers84118613de_alers
debasers11377903debasers
debaters113511923debaters
decayers14307963decayers
defacers14237993defacers
defamers14258523defamers
delayers12268663delayers
dewaters122910723dewaters
eagers74523683_e_agers
eaters65535953_e_aters
elaters74420193_elaters
embers104116183_e_mbers
enablers10196913_enablers
erasers74413943_erasers
evaders1136933_evaders
fearers104815273fe_arers
headers113819393he_aders
healers104319463he_alers
heapers123616673he_apers
hearers104319783he_arers
heaters104225223he_aters
heavers133717193he_avers
jabbers183610583__jabbers
jagers144415723__jagers
japers154616173__japers
jibers155912883__jibers
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leavers103717783le_avers
meaners94415243me_aners
megabars1344403megabars
members13258603me_mbers
menacers12279313menacers
metamers1249623metamers
negaters9349783negaters
pedalers11239393pedalers
readers83823773re_aders
reamers94221083re_amers
reapers93520453re_apers
rearers74323563re_arers
reavers108320743re_avers
rebaters103413943rebaters
regalers94311133regalers
rehabbers1683133rehabbers
relabels1045343relabels
relaters83218153relaters
relaxers15298263relaxers
remakers143811303remakers
repapers1258833repapers
retakers123511133retakers
sabers85224733__sabers
seabeds10417223se_abeds
sealers74323553se_alers
seamers94719433se_amers
seaters74028943se_aters
tabers84621573__tabers
tearers75218233te_arers
teasers75317243te_asers
vealers103214293ve_alers
weaners104613833we_aners
wearers104615903we_arers
weavers133714463we_avers
webers11310943we__bers

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.436409841.7
2DLD Change Limit1461621447.23620199.3
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.73223110.6
 
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.