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

175 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
buckras153734(None) 
buckra1436751buckra_
buckram1746111buckram
buckrams1844481buckrams
buckers153517452buckers
buckets153811692buckets
buckles153416092buckles
buckoes153810392buckoes
buckos143710892buck_os
bucks134824292buck__s
bucksaw1844372bucksaw
bucksaws1943852bucksaws
buras74736292bu__ras
burkas124513802burk_as
aucubas1145173aucubas
auras55932553au__ras
auroras7311703auroras
babkas146010143babk_as
baccaras1446913baccaras
backcast1887673backcast
backers153821883backers
backlash1945923backlash
backrest1639393backrest
backrush1944103backrush
backs135729623back__s
backsaw1836203backsaw
backsaws1946803backsaws
backups1736173backups
backwash2244943backwash
backwrap2144073backwrap
backwraps2244193backwraps
beckets15399823beckets
beckons15279143beckons
becks135522013beck__s
bhaktas1633643bhaktas
bicarbs1336013bicarbs
bickers154316553bickers
bicorns11338763bicorns
boccias13307193boccias
bocks134526573bock__s
boras75938303b__oras
bras65746453b___ras
bubbas94110703bu_bbas
bubkes144612623bubk_es
buccal1248243buc_cal
buck125129903buck___
buckaroo1644423buckaroo
buckaroos1743803buckaroos
buckayros2051953buckayros
buckbean18113203buckbean
buckbeans19102943buckbeans
buckbrush2251613buckbrush
bucked155121063buck_ed
buckeen1536703buckeen
buckeens1634853buckeens
bucker145420463buck_er
buckeroo1644313buckeroo
buckeroos1744163buckeroos
bucket144620733buck_et
buckeye1835683buckeye
buckeyes1945263buckeyes
bucking163617573bucking
buckish18237883buckish
buckle144815193buck_le
buckled164411883buckled
buckler154112033buckler
bucklers16349503bucklers
bucko134614023buck__o
buckramed2043343buckramed
bucktail1653913bucktail
bucktails1743553bucktails
buddhas1463263buddhas
bugshas1334513bugshas
buhrs104811243bu_hr_s
bulks115920613bulk__s
bumkins15318013bumkins
bunas75126573bu__nas
bunkers133715953bunkers
bunkos124210323bunk_os
bunks115125083bunk__s
bunkums1544053bunkums
bunyas11359433bu_nyas
bupkes144811483bupk_es
bupkus14385683bupk_us
buqshas2143573buqshas
bura66139533bu__ra_
buran75225303bu__ran
burans85019303bu__rans
burbs95423493bu__rbs
burds84626063bu__rds
burgs84924093bu__rgs
burka114617693burk_a_
burkers133716623burkers
burkes124421313burk_es
burls74228853bu__rls
burns74926773bu__rns
burps94220173bu__rps
burqas174410903bu_rqas
burros85114993bu_rros
burrs74925653bu__rrs
burs65847423bu__r_s
bursa74921523bu__rsa
bursars94510893bursars
bursas85318273bu_rsas
busbars1138153busbars
bushwas15105613bushwas
buskers133414093buskers
buskins133310943buskins
busks115521373busk__s
butyral1245713butyral
butyrals1344503butyrals
buyers114511003buyer_s
chakras16428503chakras
cuckoos1585123cuckoos
curaras93911953curaras
duckers143214713duckers
duckies143613813duckies
ducks124823213duck__s
duras65727723du__ras
durras74713373du_rras
euchres1288663euchres
fuckers163611593fuckers
fucks144419253fuck__s
fuckups1832923fuckups
funkias1435383funkias
gucks123917303guck__s
huckles163612623huckles
hucks144322173huck__s
kukris934453ku_kris
lockram1544913lockram
lockrams1643923lockrams
lucerns935753lucerns
luckies133313683luckies
lucks115723563luck__s
lucres84513303luc_res
lycras11287253lyc_ras
muckers153612803muckers
muckles153413253muckles
muckrake1542763muckrake
muckrakes1642743muckrakes
mucks134622643muck__s
mucors104410853mucor_s
mucosas11146683mucosas
mudras94212253mu_dras
muras75329563mu__ras
murras84916003mu_rras
muskrat1346733muskrat
muskrats1444313muskrats
okras94410973__okras
picaras11311283picaras
pucka133412803puck_a_
puckers153514673puckers
pucks134322103puck__s
punkas123410673punk_as
quokkas1942063quokkas
ruckles133414603ruckles
rucks114422053ruck__s
ruckus12407793ruck_us
suckers133717623suckers
suckles134516743suckles
sucks114523073suck__s
sucrase9310343suc_rase
sucres84218893suc_res
suras55336323su__ras
surras65919533su_rras
sutras64818593su_tras
tuckers134014353tuckers
tuckets134810333tuckets
tucks114721123tuck__s
tundras857113tundras
ultras6310193_ultras
umbras1038643_umbras
yucas106013913yuc__as
yuccas13426553yuc_cas
yucks144717193yuck__s

Search took 7 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.1561145455.1
2DLD Change Limit1340271756.03022226.7
3Display Results1751750.0632777.8
 (SQL Overall)1786911756.24928595.1
 
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.