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

115 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
unsight113748(None) 
insight1137911insight
unsights1244621unsights
gunfight1643492gunfight
infight1437452infight
insights1245492insights
knight1438172kn_ight
night94327852_n_ight
outsight1246912outsight
resight11510642resight
sight94629292__sight
sunlight1245962sunlight
unbright1444702unbright
unsighted1455432unsighted
unsightly1643082unsightly
unsought1244232unsought
unweight1544742unweight
uplight13167362uplight
upright13178292upright
uptight13176032uptight
alight103816863_alight
alright1148853alright
aright103817663_aright
bedight1437483bedight
bight118728843__bight
blight124114623_blight
bright124215923_bright
delight12610673delight
dight104027003__dight
eight94928053__eight
ensign737523ensig_n
ensigns836353ensigns
eyesight1543513eyesight
fanlight1545843fanlight
fight124027093__fight
flight134014813_flight
freight1447603freight
fright133715243_fright
gaslight1395343gaslight
gastight1365213gastight
gunfights1742433gunfights
height134713433_height
hight125327233__hight
hindsight1753033hindsight
infights1545573infights
inflight1545893inflight
insigne837673insigne
insist6314513insi_st
knights1545653kn_ights
light94429603__light
might113827083__might
mislight1447243mislight
naught104312493_naught
neigh94912383_neigh_
neighs10387733_neighs
nigh85220663_n_igh_
nighs95013613_n_ighs
nights104117723_n_ights
nighty135611273_n_ighty
nought104713963_nought
outfight1546103outfight
outright1248743outright
outsights1344183outsights
penlight1446423penlight
plight123513363_plight
refight1488873refight
relight11512063relight
resights1246733resights
right94430503__right
sennight1245143sennight
sigh85625893__sigh_
sighs95416743__sighs
sights103818013__sights
sleight11279023sleight
slight103416003_slight
spright132010403spright
sunlights1344003sunlights
tight93626503__tight
tonight1138743tonight
unbought1443763unbought
uncaught1443623uncaught
unfit84518563unfi__t
unfixt16398423unfi_xt
unfought1543543unfought
ungirt71112713ungi_rt
ungot61718063un__got
unit45140073un_i__t
unlighted1455783unlighted
unlit55025463unli__t
unmixt15378703unmi_xt
unrig61711413unrig__
unrigs7159003unrig_s
unseat64221023uns_eat
unsent63820963uns_ent
unset54532433uns__et
unshift1387413unshift
unshut939013uns_hut
unsighting1584443unsighting
unsigned1037563unsigned
unsilent849603unsilent
unsized172510543unsized
unsmart939603unsmart
unspent92610893unspent
unspilt938853unspilt
unsplit956563unsplit
unswept1246013unswept
untaught1243723untaught
unweights1643203unweights
unwish1239093unwish_
unwit84417523unwi__t
uplights14165053uplights
uprights14145313uprights
weight133914183_weight
wight123725573__wight
wright133713513_wright

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.1401276364.3
2DLD Change Limit1340271157.03319056.9
3Display Results1151150.0303833.3
 (SQL Overall)1786911157.20324807.9
 
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.