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

181 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
notably1219999(None) 
notable92114901notable
lovably15187062lovably
movably17167042movably
mutably1438612mutably
nobly105314402no__bly
nodally1137912nodally
notables10178242notables
notal55221352nota_l_
notary92310712nota_ry
notedly1136882notedly
portably1539312portably
potable112115362potable
quotably2244152quotably
ratably121711512ratably
sortably1338802sortably
stably113314122_stably
totable92313362totable
totally1039892totally
unstably1339492unstably
vocably17157152vocably
votable122111372votable
ably99725133___ably
actable11313473actable
adorably1446443adorably
affably1855183affably
amiably1438303amiably
anodally1246293anodally
anomaly1238843anoma_ly
attaboy1264303attaboy
avowably1944003avowably
bitable11312203bitable
boatable121610263boatable
bootable12179223bootable
botany1139263bota_ny
botfly1436093bot_fly
capably1639253capably
citable11313463citable
coaly105521593co_a_ly
codable12311663codable
coitally1339483coitally
costally1339723costally
countably1646283countably
curably142010773curably
datable101714233datable
denotable1238373denotable
doable93115243do_able
dotal64919623dota_l_
dotardly1343843dotardly
dottily1147283dottily
doubly12328963do_ubly
dowable13189453dowable
drably123511613_drably
durably13229053durably
eatable91717603eatable
enjoyably2452313enjoyably
enviably1645353enviably
equably2136183equably
fatally1339893fatally
focally15188553focally
formably1846663formably
getable101712553getable
hatable121713963hatable
honorably1745163honorably
hotly115815483hot__ly
instable10313203instable
inviably1646893inviably
knobbly1842873kno_bbly
knottily1543153knottily
knowable1745043knowable
loathly1334713loathly
locally12179723locally
losable91910953losable
lovable12179553lovable
loveably16175233loveably
loyally13126843loyally
modally1338403modally
morally12411493morally
mortally1339933mortally
movable14189433movable
moveably18175543moveably
mutable11312303mutable
namable11312343namable
nasally1057443nasally
natal53921493nata_l_
natantly1144293natantly
nattily103610323nattily
navally1366473navally
nearly94813733n_early
neatly93812483n_eatly
nestable101613673nestable
nettable101610243nettable
nettly9459453net_tly
nimbly13388773n_imbly
nobbily1436693nobbily
nobble103814313no_bble
nobby125513463no__bby
noble74420993no__ble
nodal64717793noda_l_
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nopal75517103nopa_l_
nopals84914023nopa_ls
normally1347883normally
nosily93712683no_sily
nota46830773nota___
notabilia1153403notabilia
notability1549703notability
notate63217863nota_te
notated82713663notated
notates72817483notates
noticeably1752523noticeably
notify1236943not_ify
nounally1146483nounally
novelly1346513novelly
noway111112843nowa__y
nubbly13369673n_ubbly
numbly134410663n_umbly
nuttily10308633nuttily
orally93113593_orally
otalgy1035353_otalgy
ovally12278443_ovally
payably17177093payably
pitiably1545843pitiably
pliably14147383pliably
pokable15209503pokable
portable12313203portable
posable112212783posable
postally13310273postally
potables12179703potables
potboy1397813pot_boy
probably1746413probably
provably1846213provably
quotable1936493quotable
ratable91717553ratable
rateably1337783rateably
retable91820403retable
retally10413683retally
ropable111611333ropable
rotary92411303rota_ry
rowable121510303rowable
royally13157733royally
salably121610743salably
satiably1337823satiably
sizably2136613sizably
snottily1145553snottily
sociably1546793sociably
solubly1255283solubly
sortable10312483sortable
sowable121610753sowable
stable83921643_stable
suably112814533_suably
suitably1347593suitably
tabby125213893__tabby
tabla73318363__tabla
table75429603__table
tally84526863__tally
taxably1936043taxably
tenably122210453tenably
tonally10311373tonally
total55321823tota_l_
totals63115163tota_ls
toteable1048353toteable
towable121910113towable
tunably12218293tunably
unstable10313763unstable
usably11288983_usably
useably1287393useably
viably14199833_viably
violably1644923violably
vitally1339673vitally
vocable14189673vocable
vocally15188343vocally
volubly1543553volubly
votary12248333vota_ry
voteable1347213voteable
wobbly16347093wo_bbly
womanly1535853womanly
workably2044743workably
zonally1938003zonally

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.453394461.4
2DLD Change Limit1340271816.11021935.7
3Display Results1811810.0632873.0
 (SQL Overall)1786911816.62626968.2
 
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.