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

117 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
locality1314843(None) 
localite101411541localite
vocality16137931vocality
docility1447122docility
legality1237622legality
localise101511852localise
localism121310012localism
localist101613962localist
localists11149792localists
localites111210432localites
localize191410482localize
locally12179722local_ly
logicality1644182logicality
loyalty13114342loyal_ty
modality14117652modality
molality13118362molality
morality131110332morality
nodality12127422nodality
orality101111682_orality
ovality1377592_ovality
sociality1447952sociality
sodality12127322sodality
tonality1139792tonality
totality1139372totality
amorality1446723amorality
anality10313633_anality
atonality1247073atonality
aurality1139223aurality
axiality1856763axiality
banality1338763banality
cavity14310013__cavity
coalify1536683co_alify
coevality1745383coevality
comicality1946133comicality
concavity1944623concavity
duality1147963_duality
equality2046993equality
facility1638243facility
fatality1438443fatality
finality1448343finality
focalise131210373focalise
focalize22139503focalize
focally15188553focal_ly
formality1746983formality
ideality1247153ideality
jocosity2044343jocosity
jollity1746143jo_llity
joviality2244133joviality
labiality1446363labiality
lability13710833lability
laity85318903l__a_ity
laxity1637273l__axity
lealty92910603l_eal_ty
lethality1545113lethality
lexicality2254093lexicality
lineality1246423lineality
local74820273local___
locale83915653local__e
locales93715093local_es
localised12167863localised
localises111411463localises
localisms13148733localisms
localities1259733localities
localized21168833localized
localizer20147713localizer
localizes201510543localizes
locals83714503local__s
locate83919843loca__te
locating11311503locating
location102113913location
locative1338683locative
loculate101011403loculate
loculi8288253loculi__
lonelily1144973lonelily
loquacity2342483loquacity
lovability18106923lovability
lovelily1444333lovelily
lowlily1335353lo_wlily
loyalism13167573loyalism
loyalist111511133loyalist
loyalists12137473loyalists
loyally13126843loyal_ly
lucidity1445493lucidity
mobility1548543mobility
molarity13118903molarity
mortality1467733mortality
motility1338733motility
nasality1146653nasality
natality1139193natality
nobility1348983nobility
nopalito1046063nopalito
normality1447193normality
opacity1436313_opacity
penality13310713penality
plurality1444613plurality
polarity131310403polarity
polity113015863po__lity
quality1938563_quality
rascality1445993rascality
reality10313573_reality
regality1249313regality
royalty13165113royal_ty
rurality1137403rurality
socialite1148503socialite
sodalite9109593sodalite
topicality1744483topicality
venality1438683venality
vitality1458113vitality
vocalic1446943vocali_c
vocalics1545593vocalics
vocalise131510813vocalise
vocalism15159043vocalism
vocalist131512123vocalist
vocalists14108893vocalists
vocalize221310153vocalize
vocally15188343vocal_ly
voracity1645533voracity

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621177.95318378.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.17221866.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.