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

173 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
basher11512381(None) 
baser74828921bas_er
bashed126225701bashed
bashers124820831bashers
bashes115631391bashes
baster85333591baster
bather115322511bather
brasher124515231brasher
busher114922201busher
dasher104318981dasher
gasher104320371gasher
kasher134915031kasher
lasher94824531lasher
masher114123201masher
rasher95024111rasher
washer124720391washer
abaser86414342abas_er
abashed1357662abashed
abashes12510372abashes
ashed97829772_ashed
ashen87818672_ashen
ashes86230612_ashes
ashier94714832_ashier
ashler9459972_ashler
asker96418782_asker
asper75520432_asper
aster55434892_aster
babier103515572babier
bached145519892bached
baches135426942baches
backer144525522backer
badder103817512badder
badger105415072badger
bagger104619202bagger
bailer85425252bailer
baiter84422552baiter
baker115629542ba_ker
balder95318862balder
baler75635272ba_ler
balker124519162balker
baller83825202baller
bander93928222bander
banger94423632banger
banisher13169182banisher
banker124222732banker
banner84421502banner
banshee121212452banshee
banter84825332banter
barber104419322barber
barer74535802ba_rer
barker124822862barker
barter85525372barter
base64847022bas_e_
based85331582bas_ed
bases75644352bas_es
bash915240162bash__
bashaw14349302bashaw
basked135218602basked
basket125722912basket
basses85428302basses
basset85225382basset
baste74829982baste_
basted95227232basted
basters94930302basters
bastes85330382bastes
batcher144414852batcher
bathe105822882bathe_
bathed125518742bathed
bathers124720362bathers
bathes116524832bathes
batter84928872batter
bawler114315052bawler
bister84922762bister
blaster94017302blaster
blather125314202blather
blusher124113112blusher
boaster94616432boaster
boshes114721882boshes
bosker123813652bosker
bother115218062bother
brashes124518462brashes
brashier13389932brashier
brasier94516752brasier
brusher123813002brusher
bushed124822382bushed
bushel114513942bushel
bushers124018802bushers
bushes115226112bushes
bushier123712812bushier
busier85219722busier
busker125517832busker
buster84726492buster
cashed125124352cashed
cashes114729882cashes
cashew144311452cashew
cashier123713322cashier
caster85232572caster
clasher124615512clasher
cosher114819902cosher
crasher124616152crasher
dashed115920562dashed
dashers115016862dashers
dashes106124982dashes
dashier114311182dashier
easier64218462easier
easter65027982easter
fashed136720252fashed
fashes124524022fashes
faster94625772faster
father125116712father
fisher124917142fisher
flasher133914062flasher
gashed116321972gashed
gashes105725152gashes
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gather104115852gather
gusher104115772gusher
harsher13310362harsher
hashed136021942hashed
hashes125024802hashes
jasper154610382jasper
josher164312962josher
kashers143914022kashers
kosher134412972kosher
laser54633322las_er
lashed105625212lashed
lashers104121832lashers
lashes94831002lashes
laster64830632laster
lather95124352lather
lusher93818762lusher
maser75029972mas_er
mashed125325042mashed
mashers124621052mashers
mashes115030002mashes
masker124416102masker
master84831342master
mosher114719792mosher
musher113820572musher
nosher94616362nosher
pashed125923142pashed
pashes115828392pashes
passer84721032passer
paster85734372paster
pisher114317752pisher
plasher124215032plasher
posher115018162posher
pusher114318282pusher
quasher19198622quasher
raser55633412ras_er
rashers104020902rashers
rashes95330152rashes
rasper83917322rasper
raster64731442raster
rather94319732rather
rusher94019652rusher
sashed105622942sashed
sashes94728482sashes
slasher104515322slasher
smasher123911012smasher
swasher134011502swasher
taster64930572taster
trasher104416122trasher
usher84517762_usher
vaster94521022vaster
washed135521502washed
washers134517522washers
washes124425492washes
washier133611152washier
waster95228942waster
wisher123617062wisher

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 Filter178691825510.1101624463.6
2DLD Change Limit825511733.12326433.2
3Display Results1731730.0632746.0
 (SQL Overall)1786911733.29654214.5
 
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.