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

240 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
lighten11281152(None) 
lighted122913501lighted
lightens122510001lightens
lighter113113441lighter
tighten11288971tighten
alighted1347672alighted
bighted142810922bighted
blighted1546862blighted
blighter1466852blighter
brighten1466242brighten
dighted132511492dighted
eighteen1245762eighteen
enlighten1344352enlighten
fighter143010772fighter
flighted1646972flighted
frighten1566442frighten
heighten1545702heighten
highted152710162highted
lichen114012742lich_en
lichted13268802lichted
ligate72519252ligate_
ligated92414142ligated
ligates82318382ligates
light94429602light__
lightened1446022lightened
lightener1345692lightener
lighters123111392lighters
lightest121410352lightest
lighting132811832lighting
lightly14369022lightly
lights104519912light_s
listen64816812li_sten
litten64014872li_tten
plighted1546462plighted
plighter1476622plighter
righted122912142righted
righter113212382righter
sighted123111522sighted
sighter113412112sighter
slighted1357392slighted
slighter1257822slighter
tightens12297952tightens
tighter112910692tighter
alight103816863alight__
alighting1446413alighting
alightment1693953alightment
alights113211433alight_s
bighorn1346063bighorn
bight118728843bight__
bighting15269453bighting
bights124417963bight_s
bigoted11258403bigoted
bitten84715123bi_tten
blight124114623blight__
blighters1555743blighters
blighties1546223blighties
blighting1635733blighting
blights133110213blight_s
blighty16356843blight_y
boughten1444193boughten
brightens1565373brightens
brighter1476663brighter
cithren12306593cithren
delighted1546203delighted
delighter1445583delighter
dight104027003dight__
dighting142510843dighting
dights114016963dight_s
eight94928053eight__
eighteens1344883eighteens
eighth133310603eight_h
eighths14388293eighths
eighties12710803eighties
eights103618983eight_s
eightvo1443843eightvo
eighty133711603eight_y
enlightens1443743enlightens
fight124027093fight__
fighters15269403fighters
fighting162710083fighting
fights133816553fight_s
flichter1664963flichter
flight134014813flight__
flightier1644423flightier
flighting1736103flighting
flights143310983flight_s
flighty17347433flight_y
foughten1544003foughten
frighted1657173frighted
frightens1655393frightens
gigaton946343gigaton
gighe10139733gigh_e_
glisten8418083gli_sten
heightens1644713heightens
higher134610893high_er
hight125327233hight__
highth12389153hight_h
highths13358003highths
highting16259723highting
hightop1645013hightop
hights133716893hight_s
kitten104611483ki_tten
knighted1745123knighted
laten54328343l__aten
latten65018203l_atten
laughter1245113laughter
legate72917453legate_
legated92513983legated
legatee82814633legatee
legates82917683legates
leghorn1146223leghorn
legmen939343leg_men
lengthen1243533lengthen
lenten6312883l_enten
lichee114017973lich_ee
lichees123512783lichees
lichens123510683lich_ens
liches114724293lich_es
licht104723493licht__
lichting14268513lichting
lichtly15255523lichtly
lichts113712383licht_s
liegemen1144133liegemen
lien45339813li___en
lifted104413523li_fted
lifter93814813li_fter
liftmen1234233liftmen
ligament1149313ligament
ligan67920283lig__an
ligase7259913ligase_
ligases82310713ligases
ligating102212283ligating
ligation92313093ligation
liger65024473lig__er
lighteners1444983lighteners
lightening15255053lightening
lightered1446283lightered
lightering15246113lightering
lightful1544163lightful
lightings14277723lightings
lightish1556623lightish
lightless1386073lightless
lightness13107433lightness
lightning14286023lightning
lignan75510323lig_nan
lignin74911193lig_nin
lignite81310303lignite_
lignites9129613lignites
ligroin848043ligroin
ligule74010833ligule_
ligules82210923ligules
ligure7279473ligure_
ligures8269893ligures
liken911818843li__ken
lilted73715373li_lted
limen75426033li__men
limited102310233limited
limiter92710853limiter
limites92915453limites
linden7411453li_nden
linemen938633linemen
linen55728723li__nen
linkmen1335363linkmen
linted74021823li_nted
lintel64013993li_ntel
linter64625343li_nter
lippen103911403li_ppen
listed74322833li_sted
listee64223063li_stee
listel64214743li_stel
listens74014133li_stens
lister64527253li_ster
lite47054553li__te_
liter54736343li__ter
lithe84922013lith_e_
lither94520953lith_er
lithoed1137833lithoed
litotes7311183litotes
litter64324853li_tter
liven85021733li__ven
might113827083might__
mightier1436383mightier
mights123516253might_s
mighty154310213might_y
mitten83914093mi_tten
nighed113811293nigh_ed
nigher103612753nigh_er
night94327853night__
nightie1179653nightie
nighties121011383nighties
nightly14449033nightly
nights104117723night_s
nighty135611273night_y
oughted1236223oughted
pigpen1136583pig_pen
plight123513363plight__
plighters1545533plighters
plighting1635563plighting
plights13299313plight_s
relighted1436863relighted
retighten1374773retighten
richen113812513rich_en
right94430503right__
righters122610713righters
rightest12149583rightest
righties12711573righties
righting132610853righting
rightly14389043rightly
righto104111093right_o
rights104019333right_s
righty135011833right_y
sighed113712053sigh_ed
sigher103813703sigh_er
sight94629293sight__
sighters122510603sighters
sighting133110863sighting
sightly14408273sightly
sights103818013sight_s
sightsee1245473sightsee
sightseen1343193sightseen
sitten64113823si_tten
slight103416003slight__
slighters1346713slighters
slightest13136953slightest
slighting1436373slighting
slightly1544603slightly
slights112810723slight_s
tight93626503tight__
tightened1444963tightened
tightener1344703tightener
tightest12148363tightest
tightly14327613tightly
tights104015853tight_s
unlighted1455783unlighted
uplighted1653843uplighted
weighmen1743463weighmen
weighted1635593weighted
weighter1535603weighter
wight123725573wight__
wights133315783wight_s

Search took 8 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 Limit1340272407.11018850.5
3Display Results2402400.1102181.8
 (SQL Overall)1786912407.64323379.7
 
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.