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

192 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
relight1151206(None) 
delight12610671delight
refight1488871refight
relights1248051relights
resight11510641resight
alight103816862_alight
bedight1437482bedight
blight124114622_blight
delights1347332delights
eight94928052_e_ight
firelight1655532firelight
flight134014812_flight
freight1447602fre_ight
height134713432he_ight
light94429602__light
penlight1446422penlight
plight123513362_plight
prefight1746392prefight
preflight1844672preflight
refights1555882refights
reliant7319242reliant
relict83623902reli_ct
relighted1436862relighted
relish93916952relish_
relist64628412reli_st
relit55340682reli__t
resights1246732resights
right94430502r__ight
sleight11279022sleight
slight103416002_slight
uplight13167362uplight
weight133914182we_ight
alights113211433_alights
alright1148853alright
aright103817663_aright
bedights1544743bedights
beknight1843563beknight
bight118728843__bight
blights133110213_blights
blighty16356843_blighty
bright124215923_bright
daylight1644513daylight
deadlight1564523deadlight
delict94320333deli_ct
delighted1546203delighted
delighter1445583delighter
delimit10311733delimit
delish105215613delish_
delist74625053deli_st
dight104027003__dight
dreigh11246443dre_igh_
droplight1643803droplight
eeliest73516473eeliest
eighth133310603_e_ighth
eights103618983_e_ights
eighty133711603_e_ighty
elegit71212893_elegit
elicit8417203_elicit
elint55436473_eli_nt
eyesight1543513eyesight
fanlight1545843fanlight
fight124027093__fight
firefight1944133firefight
firelights1764013firelights
flights143310983_flights
flighty17347433_flighty
foresight1645323foresight
freights1555853fre_ights
fright133715243_fright
gaslight1395343gaslight
greenlight1552733greenlight
headlight1744323headlight
heigh124812543he_igh_
heighth13366343he_ighth
heights14399443he_ights
heliast10312073heliast
hight125327233__hight
infight1437453infight
inflight1545893inflight
insight1137913insight
knight1438173_knight
licht104723493__licht
lights104519913__lights
limelight1544243limelight
lowlight1554943lowlight
melilot9311083melilot
might113827083__might
mislight1447243mislight
neigh94912383ne_igh_
neighs10387733ne_ighs
night94327853__night
oiltight1244543oiltight
overlight1647793overlight
penlights1544203penlights
plights13299313_plights
preflights1943323preflights
prelimit1259123prelimit
realign838763realig_n
realigns936253realigns
realist73225383reali_st
rebirth1244933rebirth
rebought1474393rebought
recit75235103reci__t
redigest1039733redigest
redipt94116743redi_pt
refit84230063refi__t
refought1564233refought
regilt71217493regi_lt
reign65015193re_ig_n
reigns74811753re_igns
rejig133810123rejig__
rejigs14368093rejig_s
relegate9311243relegate
relent64431853rel_ent
relet54749823rel__et
relic74623363reli__c
relics84517903reli_cs
relicts94414593relicts
relied74926233reli_ed
relief94419683reli_ef
reliefs10439433reliefs
relier65826183reli_er
reliers75519213reliers
relies65036423reli_es
relieve105010693relieve
relievo10425773relievo
relighting1545853relighting
religion996743religion
reline65434353reli_ne
relined85321933relined
relines75331323relines
relink104415923reli_nk
relinks114510223relinks
relique1636823relique
relished1239433relished
relishes11311953relishes
relists73817053relists
relive95120783reli_ve
relived115114683relived
relives104619443relives
reluct83916113rel_uct
remiges103015473remiges
remint85329973remi_nt
remit75737223remi__t
remixt155014853remi_xt
renig64518913renig__
renigs74314593renig_s
rerig64018483rerig__
rerigs74014793rerig_s
resift94017723resi_ft
resighted1436523resighted
resign74212583resig_n
resigns83910963resigns
resist64524533resi_st
resit54241043resi__t
resought1254983resought
retaught1244653retaught
retighten1374773retighten
retint65633443reti_nt
revisit10311373revisit
reweigh1464773reweigh_
reweighs1583203reweighs
righto104111093r__ighto
rights104019333r__ights
righty135011833r__ighty
ruliest72816433ruliest
rushlight1642713rushlight
safelight16124473safelight
sennight1245143sennight
sidelight14175483sidelight
sight94629293__sight
skylight1943993skylight
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
slights112810723_slights
spright132010403spright
sunlight1245963sunlight
tight93626503__tight
tonight1138743tonight
twilight1543903twilight
unsight1137483unsight
uplights14165053uplights
upright13178293upright
uptight13176033uptight
veliger1137313veliger
weigh125412513we_igh_
weighs13338873we_ighs
weights14409553we_ights
weighty17376233we_ighty
wight123725573__wight
wright133713513_wright

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.423422437.4
2DLD Change Limit1340271926.17021722.4
3Display Results1921920.0802400.0
 (SQL Overall)1786911926.67326778.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.