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

162 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
loyally1312684(None) 
locally12179721locally
loyalty13114341loyalty
royally13157731royally
clonally1346692clonally
florally1447032florally
focally15188552focally
globally1444612globally
leally94012612l_eally
legally1138132legally
lolly85120662lo__lly
lovably15187062lovably
loyal84513482loya_l_
loyaler1035082loyaler
modally1338402modally
morally12411492morally
nodally1137912nodally
orally93113592_orally
ovally12278442_ovally
royalty13165112royalty
tonally10311372tonally
totally1039892totally
vocally15188342vocally
zonally1938002zonally
aborally1347063aborally
ally76935643___ally
amorally1348093amorally
anally9513503_anally
anodally1246293anodally
areally10411243areally
atonally1148633atonally
aurally10310543aurally
axially1737233axially
bally105530103__bally
banally1249223banally
basally1237963basally
cavally1588483cavally
cecally1459393cecally
chally144314293_chally
chorally1638103chorally
clinally1347233clinally
coaly105521593co_a_ly
coevally1646283coevally
coitally1339483coitally
colly104926773co__lly
coolly114811393co_olly
costally1339733costally
coxalgy2042603coxalgy
coyly135614893coy__ly
dally95324743__dally
disloyally1752733disloyally
dolly96125203do__lly
dorsally1246833dorsally
doyley13487283doy_ley
doyly124514013doy__ly
dually103210063_dually
ducally13257413ducally
equally1936873equally
fatally1339893fatally
finally13310103finally
folly115022603fo__lly
formally1638243formally
foully1239013fo_ully
fugally1435603fugally
gally95026173__gally
golly95121103go__lly
gyrally1435583gyrally
holly114824433ho__lly
ideally1137793ideally
jolly154517513jo__lly
jovially2144753jovially
joyfully2442833joyfully
jurally1736963jurally
labially1336983labially
laically1338983laically
lall45531313l__all_
lalls55324133l__alls
laxly15610103l__axly
layaway1643933layaway
lealty92910603l_ealty
leanly93811503l_eanly
lethally1445923lethally
levelly1335853levelly
lineally1137793lineally
loamy105913343lo_a_my
loathly1334713loathly
lobately1344013lobately
loblolly1342053loblolly
local74820273loca_l_
locale83915653loca_le
locales93715093locales
locality13148433locality
locals83714503loca_ls
loftily1336353loftily
logically1548973logically
logily1039833lo_gily
loll46128383lo__ll_
lolls512121733lo__lls
lonelily1144973lonelily
lonely92912473lo_nely
longly10279603lo_ngly
loonily1037073loonily
loopily1236803loopily
loosely1036713loosely
loral55927823lora_l_
lordly1038753lo_rdly
losable91910953losable
loudly1037783lo_udly
lousily1038333lousily
lovable12179553lovable
loveably16175233loveably
lovelily1444333lovelily
lovely12339713lo_vely
loverly1346973loverly
lowball1275503lowball_
lowballs1364393lowballs
lowlily1335353lowlily
lowly114113333lo__wly
loyalest11146723loyalest
loyalism13167573loyalism
loyalist111511133loyalist
mesally12119793mesally
misally121111063misally
molly105222493mo__lly
mortally1339933mortally
movably17167043movably
nasally1057443nasally
navally1366473navally
normally1347883normally
notably12199993notably
nounally1146483nounally
novelly1346513novelly
otalgy1035353_otalgy
pally105727123__pally
papally1437973papally
payably17177093payably
penally121111773penally
plurally1345813plurally
postally13310273postally
rally84725903__rally
really93315613_really
regally1159873regally
retally10413683retally
royal85014703roya_l_
royals93711263roya_ls
rurally1038303rurally
sally85129713__sally
socially1338543socially
squally1937673squally
tally84526863__tally
tidally1137933tidally
tomalley1343283tomalley
usually1066063usually
vagally1435833vagally
venally13119563venally
virally1339653virally
vitally1339673vitally
vocably17157153vocably
wally114625093__wally
wofully1644523wofully
womanly1535853womanly
woolly12408513wo_olly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271626.36021073.4
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.82926166.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.