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

165 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
lovably1518706(None) 
lovable12179551lovable
loveably16175231loveably
movably17167041movably
livable122010322livable
locally12179722locally
losable91910952losable
loveable13187902loveable
lovely12339712lov_ely
loverly1346962loverly
loyally13126842loyally
movable14189432movable
moveably18175542moveably
notably12199992notably
ovally12278442_ovally
provably1846212provably
vocably17157152vocably
ably99725133___ably
adorably1446443adorably
affably1855183affably
allowably1743773allowably
amiably1438303amiably
avowably1944003avowably
blamably1744903blamably
capably1639253capably
cavally1588483cavally
clonally1346693clonally
closable12168003closable
coaly105521593co_a_ly
codable12311663codable
coevally1646283coevally
colorably1646153colorably
covary1438743cova_ry
curably142010773curably
doable93115243do_able
doubly12328963do_ubly
dowable13189453dowable
drably123511613_drably
durably13229053durably
enviably1645353enviably
equably2136183equably
florally1447033florally
focally15188553focally
formably1846663formably
globally1444613globally
immovably2143623immovably
inviably1646893inviably
jovially2144753jovially
laudably1445123laudably
lavabo1135273lavab_o
lavabos1235453lavabos
laxly15610103l__axly
leally94012613l_eally
leanly93811503l_eanly
legally1138133legally
legibly1344623legibly
levelly1335843levelly
leviable1337513leviable
liable81415813l_iable
likable13219413likable
linable92214343linable
liveable13177663liveable
lively123310813liv_ely
lividly1434783lividly
loamy105913343lo_a_my
loanable1037613loanable
loathly1334713loathly
lobately1344013lobately
lobby125113913lo__bby
local74820273loca_l_
locale83915653loca_le
locals83714503loca_ls
lockable1636953lockable
loftily1336353loftily
logily1039833lo_gily
lolly85120663lo__lly
lonely92912463lo_nely
longly10279603lo_ngly
looby108115623lo_ob_y
loonily1037073loonily
loopily1236803loopily
loosely1036713loosely
loral55927823lora_l_
lordly1038753lo_rdly
loudly1037783lo_udly
lousily1038333lousily
lovability18106923lovability
lovage1037353lova_ge
lovages1138033lovages
lovat8321043lova__t
lovats939073lova_ts
lovebug1342033lovebug
lovelily1444333lovelily
lovingly1535703lovingly
lowball1275503lowball
lowboy1435903lo_wboy
lowlily1335353lowlily
lowly114113333lo__wly
loyal84513483loya_l_
loyalty13114343loyalty
modally1338393modally
morally12411493morally
movables15175573movables
moveable15168013moveable
mutably1438613mutably
navally1366473navally
nobly105314403no__bly
nodally1137913nodally
notable92114903notable
novelly1346513novelly
orally93113593_orally
oval77119523_ova_l_
ovals85413393_ova_ls
ovary1149113_ova_ry
ovately1334433_ovately
overly122411363_overly
payably17177093payably
placably17156673placably
pliably14147383pliably
plowable1535913plowable
pokable15209503pokable
portably1539313portably
posable112212783posable
potable112115363potable
probably1746413probably
provable1539093provable
quotably2244153quotably
ratably121711513ratably
removably1944783removably
ropable111611333ropable
rowable121510303rowable
royally13157733royally
salably121610743salably
salvably1645443salvably
savable121711863savable
sizably2136613sizably
slovenly1443853slovenly
sociably1546793sociably
solubly1255283solubly
solvable1337473solvable
sortably1338803sortably
sovranly1443453sovranly
sowable121610753sowable
stably113314123_stably
suably112814533_suably
taxably1936043taxably
tenably122210453tenably
tonally10311373tonally
totable92313363totable
totally1039893totally
towable121910113towable
tunably12218293tunably
unlovable1446363unlovable
usably11288983_usably
useably1287393useably
viably14199833_viably
violably1644923violably
vocable14189673vocable
vocally15188343vocally
volubly1543553volubly
votable122111373votable
wobbly16347093wo_bbly
womanly1535853womanly
workably2044743workably
zonally1938003zonally

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340271657.95016858.7
3Display Results1651650.0632619.0
 (SQL Overall)1786911658.17321863.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.