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

288 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
alight10381686(None) 
alights113211431alights
alright1148851alright
aright103817661aright
blight124114621blight
flight134014811flight
light94429601_light
plight123513361plight
slight103416001slight
alighted1347672alighted
align65016502alig_n
aligns75312952aligns
alist56136782ali_st
alit46155692ali__t
aliyot93611712aliyot
almighty1742682almighty
aught95120702a_ught
bight118728842_bight
blights133110212blights
blighty16356842blighty
bright124215922bright
daylight1644512daylight
delight12610672delight
dight104027002_dight
eight94928052_eight
fanlight1545842fanlight
fight124027092_fight
flights143310982flights
flighty17347432flighty
fright133715242fright
gaslight1395342gaslight
height134713432height
hight125327232_hight
knight1438172knight
laigh95515922laigh_
laighs10508802laighs
licht104723492_licht
lights104519912_lights
might113827082_might
night94327852_night
plights13299312plights
relight11512062relight
right94430502_right
sight94629292_sight
sleight11279022sleight
slights112810722slights
tight93626502_tight
uplight13167362uplight
weight133914182weight
wight123725572_wight
wright133713512wright
aargh96314083aargh_
abought1346143abought
adit56443653adi__t
affright1844193affright
agha87417303a__gha
agist66325583agi_st
aiglet74224193a_iglet
aigret73720023a_igret
airt45757783a_i_rt
airth85621023a_irth
airtight1245963airtight
ait38093903a_i__t
alant55742293al_ant
albeit8314343albeit
alegar739283alegar
aleph10311393aleph_
alephs1136533alephs
alert54740653al_ert
alga57927603al_g_a
algae65319623al_gae
algal66518213al_gal
algas65624933al_gas
algid75415573al_gid
algin65718763al_gin
algins74816433algins
algor6513053al_gor
algum82711763al_gum
alias55834603ali_as
alibi7514223ali_bi
alibis8311073alibis
alible8311973alible
alidad838873alidad
alien56425583ali_en
aliens65619213aliens
alif76242133ali__f
alifs86121263ali_fs
alighting1446413alighting
aligned9128553aligned
aligner8108303aligner
alike95523963ali_ke
aliment9316703aliment
aline57243153ali_ne
alined75221403alined
aliner65621983aliner
alines65735223alines
aliped95414283aliped
aliquot1646493aliquot
alive85722513ali_ve
aliya83713483ali_ya
aliyah12397493aliyah
aliyahs13395323aliyahs
aliyas93911803aliyas
aliyos9349533aliyos
allot54933873al_lot
almah106917253almah_
almahs118611613almahs
almeh106214553almeh_
almehs11619493almehs
almost81014433almost
aloft8423433al_oft
aloha8513613al_oha
alpha1049653al_pha
alt36467963al___t
altho86312603al_tho
amidst94913233amidst
amiga85514793amig_a
amigas95912163amigas
amigo86515453amig_o
amigos94511203amigos
angst6415493a_ngst
apish105116633apish_
argot67728643a_rgot
atilt54828473ati_lt
aughts104710243a_ughts
aweigh1334933aweigh_
backlight2155703backlight
bedight1437483bedight
bights124417963_bights
bigot84828323_bigot
blighted1546863blighted
blighter1466853blighter
blithe115810863blithe
bought125115633bought
brights133710233brights
caliche14329953caliche
caliph13311403caliph_
caliphs1436753caliphs
catfight1744273catfight
caught124911683caught
claught1335103claught
cliche133712453cliche
client8316343client
clift106422193cli_ft
clipt96324273cli_pt
daylights1743283daylights
deadlight1564523deadlight
delights1347333delights
dights114016963_dights
digit73825273_digit
dought114915513dought
eighth133310603_eighth
eights103618983_eights
eighty133711603_eighty
elegit71212893elegit
elicit8417203elicit
elint55436473eli_nt
fanlights1643923fanlights
fights133816553_fights
fliest94718423fliest
flighted1646973flighted
flint87333503fli_nt
flirt87424753fli_rt
flit76539273fli__t
fought135112393fought
freight1447603freight
frights14339623frights
galiot72322583gali_ot
galipot1049543galipot
gaslights1463753gaslights
gastight1365213gastight
gighe10139733_gighe
gigot74023073_gigot
glint66830183gli_nt
halibut1289053halibut
headlight1744323headlight
heigh124812543heigh_
heighth13366343heighth
heights14399443heights
high116619913_high_
highs125412523_highs
highth12389143_highth
hights133716893_hights
infight1437453infight
inflight1545893inflight
insight1137913insight
jacklight2643743jacklight
kaliph1537873kaliph_
kaliphs1634293kaliphs
klepht1535043klepht
knights1545653knights
laich105920713laich_
laichs115110893laichs
laith85722103laith_
lamplight1743843lamplight
laugh94414373laugh_
laughs10489023laughs
legit61323503_legit
lich96230843_lich_
lichi104412953_lichi
lichts113712383_lichts
licit74327683_licit
lift76942723_li_ft
ligan67920283_ligan
ligate72519243_ligate
liger65024463_liger
lighted122913503_lighted
lighten112811523_lighten
lighter113113423_lighter
lightly14369023_lightly
lilt46349943_li_lt
limit73126333_limit
lint416266233_li_nt
lirot5430033_lirot
list47055343_li_st
lit39377313_li__t
lithe84922013_lithe
litho86513783_litho
lowlight1554943lowlight
malign939853malig_n
maligns1038133maligns
mights123516253_mights
mighty154310203_mighty
mislight1447243mislight
naught104312493naught
neigh94912383neigh_
neighs10387733neighs
nigh85220663_nigh_
nighs95013613_nighs
nights104117723_nights
nighty135611273_nighty
nought104713963nought
oiltight1244543oiltight
ought95221533_ought
paliest93021603paliest
palish114718273palish_
penlight1446423penlight
pliant83918823pliant
plighted1546463plighted
plighter1476623plighter
plinth11310453plinth
refight1488873refight
relights1248053relights
resight11510643resight
righto104111093_righto
rights104019333_rights
righty135011833_righty
safelight16124473safelight
salient7419763salient
sigh85625893_sigh_
sighs95416743_sighs
sights103818013_sights
skylight1943993skylight
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
sliest66621943sliest
slighted1357393slighted
slighter1257823slighter
slightly1544603slightly
slipt76627483sli_pt
slit46250103sli__t
sought106315053sought
spigot9312603spigot
spright132010403spright
starlight1345913starlight
sunlight1245963sunlight
taillight1344873taillight
talipot949723talipot
taught104312223taught
thigh12410113thigh_
thighs1346623thighs
tights104015853_tights
tonight1138743tonight
twilight1543903twilight
unsight1137483unsight
uplights14165053uplights
upright13178293upright
uptight13176033uptight
valiant10314623valiant
waught133811043waught
weigh125412513weigh_
weighs13338873weighs
weights14409553weights
weighty17376233weighty
whisht154510813whisht
wights133315783_wights
wrights14318993wrights

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162886.21618133.2
3Display Results2882880.0963000.0
 (SQL Overall)1786912886.45527682.6
 
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.