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 “lightered” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
lightered144628(None) 
lightened1446021lightened
flichtered1942132flichtered
ligatured1143332ligatured
lighted122913502light__ed
lightener1345692lightener
lighter113113442lighter__
lighters123111392lighter_s
littered92511382li_ttered
tightened1444962tightened
alighted1347673alight__ed
bighted142810923bight__ed
bistered112913323bi_stered
bittered112711833bi_ttered
blighted1546863blight__ed
blighter1466853blighter__
blighters1555743blighter_s
blistered12167683bli_stered
blithered15156123blith_ered
brightened1743163brightened
ciphered1637053ciph_ered
dighted132511493dight__ed
dithered13189293dith_ered
eighteen1245763eighte_en
enlightened1652323enlightened
fighter143010773fighter__
fighters15269403fighter_s
filtered12259043fi_ltered
flighted1646973flight__ed
flittered13196253fli_ttered
frightened1843243frightened
glistered11176293gli_stered
glittered11195403gli_ttered
heightened1843013heightened
highbred1843373high_bred
highted152710163hight__ed
inhered11313163_inh_ered
jiggered1834203jig_gered
jittered16267223ji_ttered
lagered92311153lag__ered
lathered121512323lath_ered
leathered13148713leathered
lechered1437523lech_ered
leistered1037043leistered
lettered92910783l_ettered
lichened1435753lich_ened
lichted13268803licht__ed
ligated92414143ligat__ed
ligature945133ligature_
ligatures1044933ligatures
lighten112811523light__en
lighteners1444983lighteners
lightens122510003lighte_ns
lighterage1552543lighterage
lighterages1652413lighterages
lightering15246113lightering
lightest121410353lighte_st
lightfaced2072253lightfaced
lighthearted2061713lighthearted
lightwood1753183lightwood
limbered13158123li_mbered
lingered10129643li_ngered
lippered13287953li_ppered
listened9168813li_stened
litterer82810173li_tterer
livered113111633li__vered
lobstered1244643lobstered
loitered938183l_oitered
lustered92510603l_ustered
mitered103213233mi__tered
plighted1546463plight__ed
plighter1476623plighter__
plighters1545533plighter_s
righted122912143right__ed
righter113212383righter__
righters122610713righter_s
sighted123111523sight__ed
sighter113412113sighter__
sighters122510603sighter_s
sintered92213903si_ntered
sistered92612803si_stered
slaughtered1652233slaughtered
slighted1357393slight__ed
slighter1257823slighter__
slighters1346713slighter_s
slithered13136623slith_ered
tightener1344703tightener
tighter112910693tighter__
tittered9239493ti_ttered
wintered122111573wi_ntered
withered15169433with_ered

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 Filter1786911486410.423422437.4
2DLD Change Limit148641916.28023668.9
3Display Results91910.0332757.6
 (SQL Overall)178691916.73626527.8
 
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.