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

266 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
backset1531419(None) 
backseat1648901backseat
backsets1638851backsets
backbeat1847842backbeat
backbit17129102backbit
backed155725722back_ed
backer144525522back_er
backfit18108212backfit
backlit15911902backlit
backout15612952backout
backrest1639392backrest
backs135729622backs__
backsaw1836202backsaw
backseats1746672backseats
backswept2243692backswept
basket125722912bask_et
basset85225382ba_sset
becket144619882beck_et
blackest16269302blackest
bracket154117232brack_et
bucket144620732buck_et
jacket194720672jack_et
lockset13311162lockset
packet144726502pack_et
racket125229422rack_et
tacket124627492tack_et
wackest164710862wackest
abacuses1235763abacuses
ackee115825373_ack_ee
ackees124914583_ackees
anklet105618733_anklet
asset55932263_a_sset
auklet104216833_auklet
avoset9315673_avoset
baases85218013ba_ases
babiest114414753babiest
babysat14135233babysat
babysit14145613babysit
baccae12119703baccae_
baccate131011263baccate
bached145519893bac_hed
baches135426943bac_hes
back125535763back___
backbeats1945763backbeats
backbend1944783backbend
backbite1899173backbite
backcast1887673backcast
backchat2147113backchat
backdate1748223backdate
backers153821883backers
backfits19106953backfits
backhoe1847153backhoe
backhoed2047013backhoed
backhoes1938543backhoes
backing165523443backing
backless162910633backless
backlist16910653backlist
backlog1635773backlog
backmost1846633backmost
backouts1698643backouts
backrests1744983backrests
backsaws1946803backsaws
backside17108143backside
backsides1887693backsides
backslap1844993backslap
backslid1746273backslid
backspin1845423backspin
backstab1845453backstab
backstay1945963backstay
backstop1845563backstop
backstreet1855033backstreet
backup1646613back_up
backups1736173backups
baddest112611143baddest
baguet9316103ba_guet
bake105637513ba_k_e_
baked126130773ba_k_ed
baker115629543ba_k_er
bakes117035373ba_k_es
balases93815433balases
baldest102313533baldest
balked135219413balk_ed
balker124519163balk_er
balkier134111983balkier
balkiest144112453balkiest
balks114926293balks__
ballet84733973ba_llet
banked135021443bank_ed
banker124222733bank_er
bankit123617043bank_it
banks115527903banks__
banksia1335943banksia
bannet84925333ba_nnet
banquet1839783banquet
barbet104427883ba_rbet
barest85327693bares_t
barked135027313bark_ed
barkeep1536363barkeep
barker124822863bark_er
barkier133814483barkier
barkiest144115153barkiest
barks115735813barks__
baronet91022203baronet
barret84930483ba_rret
base64847023ba__se_
based85331583ba__sed
baser74828923ba__ser
bases75644353ba__ses
basest84720493ba__sest
basinet9318933basinet
basked135218603bask_ed
baskets135111833bask_ets
basks115621763basks__
basses85428303ba_sses
bassets96414823ba_ssets
bassett94213863ba_ssett
bast66362413ba__s_t
baste74829983ba__ste
batiste939743batiste
bayonet121212213bayonet
becked155417763beck_ed
beckets15399823beck_ets
becks135522013becks__
beset76739133b__eset
bicker144819173bick_er
blacked163613373black_ed
blacken15439793black_en
blacker154513513black_er
blackleg1734233blackleg
blackout1647413blackout
blacks144914953blacks__
blankest14439063blankest
blanket134313093blank_et
bocks134526573bocks__
boneset9316433boneset
booklet132312643booklet
bosket124919223bosk_et
bracelet12310693bracelet
brachet144020313brac_het
bracken15409813brack_en
brackets163310433brack_ets
bractlet1239283bractlet
brisket134413403brisket
brocket154013383brock_et
bucked155121063buck_ed
buckeen1536703buckeen
bucker145420463buck_er
buckets153811693buck_ets
buckle144815193buckle_
buckled164411883buckled
buckler154112033buckler
buckles153416093buckles
buckoes153810393buckoes
bucks134824293bucks__
bucksaw1844373bucksaw
buckshee1945403buckshee
buckshot1954963buckshot
cachet134526413cac_het
cackle143416923cackle_
cackled164613303cackled
cackler153812573cackler
cackles153717203cackles
casket124820993cask_et
coset75748843__coset
dacker134920753dack_er
dankest122611673dankest
darkest122512623darkest
docket134721173dock_et
facet106038523fac__et
gasket114417253gask_et
hackbut1845713hackbut
hacked164923513hack_ed
hackee154921833hack_ee
hackees165014103hackees
hacker154822693hack_er
hackie154615623hackie_
hackies163418243hackies
hackle154916813hackle_
hackled173312493hackled
hackler163512353hackler
hackles162917063hackles
hackmen1836713hackmen
hackney1935123hackney
hacks144928713hacks__
hacksaw1943713hacksaw
handset113016823handset
hardset113415833hardset
jacked204817523jack_ed
jacker194417583jack_er
jackets205011373jack_ets
jackies202912623jackies
jackleg2135043jackleg
jackpot2245013jackpot
jacks185219833jacks__
jacksmelt2472593jacksmelt
jaconet16311483jaconet
laciest93819043laciest
lacked135324653lack_ed
lacker125325623lack_er
lackey154813353lack_ey
lacks116129203lacks__
lankest112714113lankest
locket123922473lock_et
locksets1435693locksets
mackle143716433mackle_
mackled164111923mackled
mackles154415753mackles
macks135127603macks__
market123226043mark_et
nailset7311973nailset
paciest112917813paciest
packed154822603pack_ed
packer144223403pack_er
packets155114773pack_ets
packmen1746313packmen
packs135528933packs__
picket144924313pick_et
placket15412873plack_et
pocket144622623pock_et
quickset2345363quickset
rachet115028973rac_het
raciest92820013raciest
racist82822793racis_t
racked134526083rack_ed
racker124824553rack_er
rackets134916873rack_ets
rackety16499113rack_ety
rackle123917293rackle_
racks115028853racks__
racquet1838743racquet
rankest112713813rankest
rocket125425283rock_et
sachet114725773sac_het
sackbut1545943sackbut
sacked135525213sack_ed
sacker125124843sack_er
sacks114228873sacks__
sickest131813793sickest
slackest14289403slackest
socket123923523sock_et
tacet75840023tac__et
tacked134723943tack_ed
tacker124224503tack_er
tackets134914363tack_ets
tackey154613083tack_ey
tackier133712523tackier
tackiest143112433tackiest
tackle123815733tackle_
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
tacks115430133tacks__
tasset65925313ta_sset
thickset17257133thickset
ticket124524853tick_et
tucket124219483tuck_et
wacke145918623wack_e_
wacker154920123wack_er
wackes154717713wack_es
wackier16369733wackier
wackiest172610273wackiest
wacks146626283wacks__
wadset10314303wa_dset
wicket155318943wick_et
yacked164516793yack_ed
yacks144419813yacks__

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.406440125.6
2DLD Change Limit1340272666.17321711.8
3Display Results2662660.0932860.2
 (SQL Overall)1786912666.67226782.2
 
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.