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

80 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
unsighted145543(None) 
unlighted1455781unlighted
knighted1745122kn_ighted
resighted1436522resighted
sighted123111522__sighted
unbigoted1343992unbigoted
unsifted12128772unsi_fted
unsight1137482unsight__
unsightly1643082unsightly
unsights1244622unsight_s
unsigned1037562unsig_ned
unweighted1843152unweighted
uplighted1653842uplighted
uprighted1654212uprighted
alighted1347673_alighted
bedighted1744583bedighted
benighted1644743benighted
bighted142810923__bighted
blighted1546863_blighted
delighted1546203delighted
dighted132511493__dighted
enlighten1344353enlighten
farsighted1842943farsighted
flighted1646973_flighted
freighted1755203freighted
frighted1657173_frighted
gunfighter1851653gunfighter
highted152710163__highted
infighter1644273infighter
insight1137913insight__
insights1245493insight_s
insisted998673insi_sted
instigated1247693instigated
lighted122913503__lighted
longsighted1751383longsighted
mislighted1743653mislighted
neighed12135893_neigh_ed
nighed113811293_n_igh_ed
plighted1546463_plighted
relighted1436863relighted
righted122912143__righted
sighed113712053__sigh_ed
sighter113412113__sighter
slighted1357393_slighted
unbitted1138213unbi_tted
undigested13123843undigested
undiluted1144903undiluted
unfished15218293unfish_ed
unfitted1238163unfi_tted
ungated92717213un__gated
ungifted13116833ungi_fted
united74421543un_i__ted
unlimited1245923unlimited
unlisted9311153unli_sted
unpitted1148623unpi_tted
unrigged1165643unrig_ged
unsalted9510923uns_alted
unsated83419933uns__ated
unscathed1535313unscathed
unscented1237513unscented
unseated91317683uns_eated
unshed10313773uns__h_ed
unshifted16124943unshifted
unshirted13105953unshirted
unsighting1584443unsighting
unsightlier1551663unsightlier
unsized172510543unsi__zed
unsoothed1344253unsoothed
unsorted9312513uns_orted
unspotted1244933unspotted
unstated91615813uns_tated
unstinted1038563unstinted
unsuited9310793uns_uited
unswathed1634543unswathed
untilted9610893unti_lted
unvisited1345173unvisited
unweighed1753663unweigh_ed
unwished15237833unwish_ed
unwitted1237543unwi_tted
weighted1635593_weighted

Search took 9 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 Limit148641808.36017780.0
3Display Results80800.0461739.1
 (SQL Overall)178691808.82920239.1
 
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.