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

140 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
lightest12141035(None) 
rightest12149581rightest
slightest13136941slightest
tightest12148361tightest
brightest1545662brightest
flightiest1744502flightiest
highest1439562high_est
ligates82318382ligates_
lighted122913502lighte_d
lighten112811522lighte_n
lightens122510002lightens
lighter113113442lighte_r
lighters123111392lighters
lightfast1643642lightfast
lightish1556622lightish
lightless1386072lightless
lightness13107432lightness
lights104519912light_s_
lithest10513912lith_est
mightiest1546442mightiest
nighest11310692nigh_est
rightist12159142rightist
alighted1347673alighte_d
alightment1693953alightment
alights113211433alight_s_
biggest1138143big_gest
bighted142810923bighte_d
bights124417963bight_s_
blighted1546863blighte_d
blighter1466853blighte_r
blighters1555743blighters
blighties1546223blighties_
blights133110213blight_s_
blithest1338083blith_est
digest84019623dig__est
dighted132511493dighte_d
dights114016963dight_s_
dishiest12313683dishiest
eighteen1245763eighteen
eighths14388293eighths_
eighties12710803eighties_
eights103618983eight_s_
fighter143010773fighte_r
fighters15269403fighters
fights133816553fight_s_
fishiest14310453fishiest
fittest102510803fi_ttest
flighted1646973flighte_d
flightless1773393flightless
flights143310983flight_s_
highness1536053highness
highted152710163highte_d
highths13358003highths_
hights133716893hight_s_
iratest7312483_iratest
jiggiest17277693jiggiest
latest63822703l__atest
lathiest11312653lathiest
leftest10269463l_eftest
legates82917683legates_
leggiest10308233leggiest
lichees123512783lichees_
liches114724293lich_es_
lichted13268803lichte_d
lichts113712383licht_s_
liefest1038443li_efest
lievest1048343li_evest
ligament1149313ligament
ligases82310713ligases_
ligate72519253ligate__
ligated92414143ligate_d
light94429603ligh___t
lightened1446023lightened
lightener1345693lightener
lightered1446283lightered
lightful1544163lightful
lighting132811833lighting
lightly14369023light_ly
lignites9129613lignites_
ligules82210923ligules_
ligures8269893ligures_
likest104914383li__kest
limbiest12258893limbiest
limiest93716103li_miest
limites92915453limites_
limpest113712313li_mpest
lingiest93715263lingiest
liniest73321153li_niest
lintiest82715913lintiest
lippiest122310613lippiest
litotes7311183litotes_
littlest8309243littlest
livest95315733li__vest
loggiest103011013loggiest
logiest82515543log_iest
lushest103312283lush_est
mights123516253might_s_
minutest10247653minutest
nighness1236103nighness
nighties121011383nighties_
nightless1386073nightless
nights104117723night_s_
piggiest12259663piggiest
pithiest132711443pithiest
plighted1546463plighte_d
plighter1476623plighte_r
plighters1545533plighters
plights13299313plight_s_
richest122813683rich_est
righted122912143righte_d
righter113212383righte_r
righters122610713righters
righties12711573righties_
rightism14156963rightism
rightists13126053rightists
rightmost1544053rightmost
rightness13117353rightness
rights104019333right_s_
sighless1276553sighless
sighted123111523sighte_d
sighter113412113sighte_r
sighters122510603sighters
sightless1385923sightless
sightliest1445103sightliest
sights103818013sight_s_
sightsee1245473sightsee
slighted1357393slighte_d
slighter1257823slighte_r
slighters1346713slighters
slightness1454803slightness
slights112810723slight_s_
tighten11288973tighte_n
tightens12297953tightens
tighter112910693tighte_r
tightness1386603tightness
tights104015853tight_s_
weightiest1743423weightiest
wiggiest13269013wiggiest
wights133315783wight_s_
withiest142411243withiest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621407.43619656.0
3Display Results1401400.0632222.2
 (SQL Overall)1786911407.92222556.3
 
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.