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

145 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
backlit1591190(None) 
backbit17129101backbit
backfit18108211backfit
backlist16910651backlist
backbite1899172backbite
backfits19106952backfits
backflip2143092backflip
backlight2155702backlight
backlists17117412backlists
backlog1635772backlog
backout15612952backout
backset15314192backset
backslid1746272backslid
bankit123617042bank_it
blacklist1746122blacklist
acquit17610323_acquit
alit46155693_a__lit
anklet105618733_anklet
auklet104216833_auklet
baalim1038473ba_alim
babysit14145613babysit
bacalao1146613bacalao
bacchic1545813bacchic
bacchii1644543bacchii
bacilli1146403bacilli
back125535763back___
backbeat1847843backbeat
backbiter191786803backbiter
backbites19108633backbites
backcast1887673backcast
backchat2147113backchat
backcloth2294563backcloth
backdate1748223backdate
backed155725723back_ed
backer144525533back_er
backers153821893backers
backfill1965063backfill
backfire1946013backfire
backflips2243333backflips
backflow2243373backflow
backhoe1847153backhoe
backing165523443backing
backland1748103backland
backlash1945923backlash
backless162910633backless
backlights2253993backlights
backlisted1944503backlisted
backload1746833backload
backlogs1746633backlogs
backmost1846633backmost
backouts1698643backouts
backrest1639393backrest
backs135729623back__s
backsaw1836203backsaw
backseat1648903backseat
backsets1638853backsets
backside17108143backside
backslap1844993backslap
backslide1845883backslide
backspin1845423backspin
backup1646613back_up
backups1736173backups
bacula103112683bacul_a
baculine1238983baculine
baculum1345703baculum
bailie83818363ba_ilie
bait66556003ba___it
bakelite1447253bakelite
balkily16266693balkily
balkline1437973balkline
ballet84733973ba_llet
ballot84624093ba_llot
banality1338763banality
bandit93821133ba_ndit
bankits133410153bank_its
banksia1335943banksia
barefit1249723barefit
basalt83519583basal_t
basilic1137493basilic
basket125722913bask_et
becket144619883beck_et
blackest16269303blackest
blackfin1953903blackfin
blackleg1734233blackleg
blacklists1844183blacklists
blackly1835253blackl_y
blackout1647413blackout
booklet132312643booklet
bracelet12310693bracelet
bracket154117233brack_et
bractlet1239283bractlet
bucket144620733buck_et
buckle144815193buckl_e
buckled164411883buckled
buckler154112033buckler
buckles153416093buckles
buckling17259113buckling
bucolic1345593bucolic
cackle143416923cackl_e
cackled164613303cackled
cackler153812573cackler
cackles153717203cackles
cackling172610943cackling
cockpit1747993cockpit
dacoit9415453dac_oit
dakoit11310353da_koit
daylit10512493da_ylit
facelift1645773facelift
facility1638253facility
gaslit7513503ga_slit
hackbut1845713hackbut
hackie154615623hack_ie
hackle154916813hackl_e
hackled173312493hackled
hackler163512353hackler
hackles162917063hackles
hacklier1737133hacklier
hackliest1836523hackliest
hackling183310163hackling
hackly18298733hackl_y
jacket194720673jack_et
jackleg2135043jackleg
jacklight2643743jacklight
jackpot2245013jackpot
mackle143716433mackl_e
mackled164111923mackled
mackles154415753mackles
mackling172710063mackling
packet144726503pack_et
packly17228333packl_y
racket125229423rack_et
rackle123917293rackl_e
sackbut1545943sackbut
sacklike1337303sacklike
tacit76333673tac__it
tacket124627493tack_et
tackily1637503tackily
tackle123815733tackl_e
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
tackling153211123tackling
tallit63422733ta_llit
wackest164710863wackest
wackily1936053wackily

Search took 9 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.420425454.8
2DLD Change Limit1340271457.64317535.9
3Display Results1451450.0602416.7
 (SQL Overall)1786911458.12321998.2
 
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.