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

84 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
unlighted145578(None) 
unsighted1455431unsighted
uplighted1653841uplighted
alighted1347672_alighted
blighted1546862_blighted
delighted1546202delighted
enlighten1344352enlighten
flighted1646972_flighted
knighted1745122kn_ighted
lighted122913502__lighted
plighted1546462_plighted
relighted1436862relighted
slighted1357392_slighted
unbigoted1343992unbigoted
unlimited1245922unlimited
unlisted9311152unli_sted
unweighted1843152unweighted
uprighted1654212uprighted
bedighted1744583bedighted
benighted1644743benighted
bighted142810923__bighted
blighter1466853_blighter
daylighted1952193daylighted
delighter1445583delighter
dighted132511493__dighted
enlightened1652323enlightened
enlightens1443743enlightens
enlisted978193enli_sted
freighted1755203freighted
frighted1657173_frighted
gunfighter1851653gunfighter
highted152710163__highted
infighter1644273infighter
lichted13268803__lichted
ligated92414143__ligated
lighten112811523__lighten
lighter113113443__lighter
mislighted1743653mislighted
moonlighted1851943moonlighted
neighed12135893_neigh_ed
nighed113811293_n_igh_ed
obligated13186903obligated
plighter1476623_plighter
resighted1436523resighted
righted122912143__righted
sighted123111523__sighted
skylighted2251803skylighted
slighter1257823_slighter
sunlight1245963sunlight__
sunlights1344003sunlight_s
unaligned1144873unalig_ned
unbitted1138213unbi_tted
uncliched1744623unclich_ed
undigested13123843undigested
undiluted1144903undiluted
unfished15218293unfish_ed
unfitted1238163unfi_tted
ungated92717213un__gated
ungifted13116833ungi_fted
united74421543un_i__ted
unlashed12289183unlash_ed
unletted9310313unl_etted
unlicked15248263unli_cked
unliked122411283unli__ked
unlined82515803unli__ned
unlinked13237793unli_nked
unlived112511373unli__ved
unlocated1238383unlocated
unpitted1148623unpi_tted
unrigged1165643unrig_ged
unsifted12128773unsi_fted
unsight1137483unsight__
unsightly1643083unsightly
unsights1244623unsight_s
unsigned1037563unsig_ned
untilted9610893unti_lted
unvisited1345173unvisited
unweighed1753663unweigh_ed
unwished15237833unwish_ed
unwitted1237543unwi_tted
uplifted1454423upli_fted
uplight13167363uplight__
uplights14165053uplight_s
weighted1635593_weighted

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 Filter1786911486410.440406115.9
2DLD Change Limit148641846.56022658.7
3Display Results84840.0332545.5
 (SQL Overall)178691847.03325407.5
 
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.