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

287 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
blight12411462(None) 
alight103816861alight
bight118728841b_ight
blights133110211blights
blighty16356841blighty
bright124215921bright
flight134014811flight
light94429601_light
plight123513361plight
slight103416001slight
alights113211432alights
alright1148852alright
aright103817662aright
bedight1437482bedight
bights124417962b_ights
bigot84828322b_igot
blighted1546862blighted
blighter1466852blighter
blithe115810862blithe
bought125115632bought
brights133710232brights
delight12610672delight
dight104027002_dight
eight94928052_eight
fight124027092_fight
flights143310982flights
flighty17347432flighty
fright133715242fright
height134713432height
hight125327232_hight
knight1438172knight
licht104723492_licht
lights104519912_lights
might113827082_might
night94327852_night
plights13299312plights
relight11512062relight
right94430502_right
sight94629292_sight
sleight11279022sleight
slights112810722slights
tight93626502_tight
uplight13167362uplight
weight133914182weight
wight123725572_wight
wright133713512wright
abought1346143abought
alighted1347673alighted
align65016503alig_n
aligns75312953aligns
alist56136783ali_st
alit46155693ali__t
aliyot93611713aliyot
almighty1742683almighty
aught95120703_aught
backlight2155703backlight
baht96740013b__aht
bait66556003bai__t
baith108023133baith_
bedights1544743bedights
begat86629723b_egat
beget85632563b_eget
begirt9412683begirt
begot84625953b_egot
beige81515383beig_e
beiges91014413beiges
beigne9148613beigne
beignet101510963beignet
beigy111110583beig_y
beknight1843563beknight
bidet84935623b_idet
big67345723b_ig__
biggy124413133b_iggy
bighted142810923b_ighted
bigly114814753b_igly
bigos85020013b_igos
bigots95015133b_igots
bigs76235023b_ig_s
bilge87618913bilg_e
bilged105513183bilged
bilges94915633bilges
bilgy114713713bilg_y
billet86029723billet
binit76431583b_init
bint67355043b_i_nt
biont7727163b_iont
birth105619873b_irth
bit57070903b_i__t
bitt65545813b_i_tt
blah98625063bl_ah_
blahs105616513bl_ahs
blast76532573bl_ast
blat66550953bl__at
bleat75737003bl_eat
blent76230953bl_ent
blest76431723bl_est
blet66247673bl__et
blighters1555743blighters
blighties1546223blighties
blighting1635733blighting
blimey13468453blimey
blimp115612943bli_mp
blimps12588153blimps
blimy125212823bli_my
blin67228173bli__n
blind86319323bli_nd
blindgut1242453blindgut
blinds95111613blinds
blini75519273bli_ni
blinis85313683blinis
blink115720143bli_nk
blinks124613573blinks
blintz1788843blintz
blip88322773bli__p
blips95615783bli_ps
bliss75616913bli_ss
blite76225353bli_te
blites84721213blites
blither124812173blither
blithest1338083blithest
blitz165318133bli_tz
bloat75229923bl_oat
blog75723823blog__
blogs85319233blog_s
blot65842323bl__ot
bluest84016483bluest
bluet75631193bl_uet
bluish1159243bluish_
blunt75525023bl_unt
blurt77625623bl_urt
blush105115313blush_
borsht11813503borsht
bough115719313bough_
boughs125414373boughs
brig76528033brig__
brighten1466243brighten
brighter1476663brighter
brightly1764553brightly
brigs85823223brig_s
brit66350153bri__t
brith104924373brith_
briths115113863briths
britt75732233bri_tt
brought13308683brought
brugh115414293brugh_
brughs12509063brughs
budget104618123budget
built74325923bui_lt
bullfight1842933bullfight
burgh115216033burgh_
burghs12519923burghs
caught124911683caught
claught1335103claught
cliche133712453cliche
client8316343client
clift106422193cli_ft
clipt96324273cli_pt
daylight1644513daylight
delights1347333delights
dights114016963_dights
digit73825273_digit
dought114915513dought
eighth133310603_eighth
eights103618983_eights
eighty133711603_eighty
elegit71212893elegit
elicit8417203elicit
elint55436473eli_nt
fanlight1545843fanlight
fights133816553_fights
fliest94718433fliest
flighted1646973flighted
flint87333503fli_nt
flirt87424753fli_rt
flit76539273fli__t
fought135112393fought
freight1447603freight
frights14339623frights
gaslight1395343gaslight
gighe10139733_gighe
gigot74023073_gigot
glint66830183gli_nt
heigh124812543heigh_
heighth13366343heighth
heights14399443heights
high116619923_high_
highs125412523_highs
highth12389153_highth
hights133716893_hights
infight1437453infight
inflight1545893inflight
insight1137913insight
klepht1535043klepht
knights1545653knights
laigh95515923laigh_
laighs10508803laighs
legit61323503_legit
lich96230843_lich_
lichi104412953_lichi
lichts113712383_lichts
licit74327683_licit
lift76942723_li_ft
ligan67920283_ligan
ligate72519253_ligate
liger65024473_liger
lighted122913503_lighted
lighten112811523_lighten
lighter113113443_lighter
lightly14369023_lightly
lilt46349943_li_lt
limit73126343_limit
lint416266233_li_nt
lirot5430033_lirot
list47055343_li_st
lit39377313_li__t
lithe84922013_lithe
litho86513783_litho
lowlight1554943lowlight
mights123516253_mights
mighty154310203_mighty
mislight1447243mislight
naught104312493naught
neigh94912383neigh_
neighs10387733neighs
nigh85220663_nigh_
nighs95013613_nighs
nights104117723_nights
nighty135611273_nighty
nought104713963nought
obligate11198303obligate
obligati11184833obligati
obligato11194983obligato
oblige937653oblig_e
obliged1134983obliged
obligee1046863obligee
obliger1035283obliger
obliges1037143obliges
obligor1043533obligor
oiltight1244543oiltight
ought95221533_ought
penlight1446423penlight
pliant83918823pliant
plighted1546463plighted
plighter1476623plighter
plinth11310453plinth
refight1488873refight
relights1248053relights
resight11510643resight
righto104111093_righto
rights104019333_rights
righty135011833_righty
sigh85625893_sigh_
sighs95416743_sighs
sights103818013_sights
skylight1943993skylight
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
sliest66621953sliest
slighted1357393slighted
slighter1257823slighter
slightly1544603slightly
slipt76627483sli_pt
slit46250103sli__t
sought106315053sought
spigot9312603spigot
spright132010403spright
sunlight1245963sunlight
taught104312223taught
thigh12410123thigh_
thighs1346633thighs
tights104015853_tights
tonight1138743tonight
twilight1543903twilight
unbright1444703unbright
unsight1137483unsight
uplights14165053uplights
upright13178293upright
uptight13176033uptight
waught133811043waught
weigh125412513weigh_
weighs13338873weighs
weights14409553weights
weighty17376233weighty
whisht154510813whisht
wights133315783_wights
wrights14318993wrights

Search took 6 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 Filter1786911127160.453394461.4
2DLD Change Limit1127162875.03022408.7
3Display Results2872870.0933086.0
 (SQL Overall)1786912875.57632046.4
 
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.