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

272 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
lovable1217955(None) 
livable122010321livable
losable91910951losable
lovably15187061lovably
loveable13187901loveable
movable14189431movable
closable12168002closable
codable12311662codable
doable93115242do_able
dowable13189452dowable
leviable1337512leviable
liable81415812l_iable
likable13219412likable
linable92214342linable
liveable13177662liveable
loanable1037612loanable
locale83915652loca_le
lockable1636952lockable
lovage1037352lova_ge
loveably16175232loveably
movables15175572movables
movably17167042movably
moveable15168012moveable
notable92114902notable
plowable1535912plowable
pokable15209502pokable
posable112212782posable
potable112115362potable
provable1539092provable
ropable111611332ropable
rowable121510302rowable
savable121711862savable
solvable1337472solvable
sowable121610752sowable
totable92313362totable
towable121910112towable
unlovable1446362unlovable
vocable14189672vocable
votable122111372votable
able66340533___able
actable11313473actable
addable11218843addable
adorable1138773adorable
affable15117403affable
alliable1038433alliable
allocable1345633allocable
allowable1444953allowable
amiable11312033amiable
arable81821003_arable
atonable1038793atonable
avowable1635453avowable
bitable11312203bitable
blamable1436693blamable
blockable1944303blockable
boatable121610263boatable
bobble94115143bo_bble
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
bootable12179223bootable
buyable1437493buyable
cable95329913__cable
capable13313363capable
citable11313463citable
cleavable1644473cleavable
closeable13155023closeable
clubable1436093clubable
cobble123615263co_bble
coble94823173co__ble
coinable12311583coinable
colorable1348243colorable
cookable16147973cookable
copyable1736623copyable
coracle112011723coracle
coverable1649103coverable
covetable1648163covetable
curable112414513curable
datable101714233datable
disable10516433disable
double94013993do_uble
drivable1438023drivable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
effable15106673effable
enable83318483_enable
enviable1337853enviable
equable1849253equable
erodable1139203erodable
errable9312183errable
evocable1537103evocable
evolvable1743383evolvable
exorable1738933exorable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
finable122213623finable
fixable19218193fixable
floatable1444983floatable
floggable1642243floggable
floodable1544013floodable
flyable15307123flyable
foamable1537043foamable
foible11410383fo_ible
foilable1338063foilable
foldable1437133foldable
fordable1439593fordable
formable1539503formable
foveole13106873foveole
friable122612563friable
fryable15277463fryable
gable85325523__gable
gelable101710733gelable
getable101712553getable
giveable14155753giveable
gobble113512983go_bble
growable1435623growable
hatable121713963hatable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hobble133913433ho_bble
holdable1437073holdable
immovable1844413immovable
inviable1338523inviable
isolable1038793isolable
joinable1737283joinable
knowable1745043knowable
label75019383l__abel
labile8315223l__abile
ladle66320443l__adle
lapsable12117383lapsable
laudable1137893laudable
lavabo1135273lavab_o
lavaboes1344433lavaboes
lavabos1235453lavabos
lavage1038263lava_ge
leasable101510133leasable
legible1035833legible
lendable11169463lendable
lienable10188693lienable
liftable1376863liftable
likeable14166473likeable
lineable101811083lineable
linkable14187263linkable
listable10810313listable
loathe94211383lo_athe
lobate82915243loba_te
lobe65535363lo__b_e
lobule82910063lo_bule
local74820273loca_l_
locales93715093loca_les
locally12179723locally
locals83714503loca_ls
locatable1345573locatable
locate83919843loca_te
locule83412033lo_cule
loral55927823lora_l_
lovages1138033lovages
lovat8321043lova__t
lovats939073lova_ts
love75234763lov___e
lovebug1342033lovebug
lovely12339713lov_ely
loverly1346973loverly
lowball1275503lowball
loyal84513483loya_l_
loyaler1035083loya_ler
loyally13126843loyally
makable15510203makable
minable112315073minable
mixable18259173mixable
mockable1846643mockable
moldable1337103moldable
morale85220553mora_le
moveables16163963moveables
moveably18175543moveably
mutable11312303mutable
namable11312343namable
nobble103814313no_bble
noble74420993no__ble
nonviable1446263nonviable
notables10178243notables
notably12199993notably
novae85913123nova__e
novelle1058233novelle
obviable1543863obviable
oracle84313293_oracle
oval77119523_ova_l_
ovally12278443_ovally
ovals85413393_ova_ls
ovate84214393_ova_te
overable13513573_overable
ovule839493_ov_ule
ownable1237283ownable
parable111819783parable
payable141711323payable
placable14169243placable
playable15137923playable
pliable111610323pliable
portable12313203portable
potables12179703potables
pourable1239133pourable
probable1439053probable
provably1846213provably
quotable1936493quotable
ratable91717553ratable
relivable1438513relivable
removable1646923removable
retable91820403retable
ridable101412493ridable
roble75223023ro__ble
rockable1638013rockable
rouble83913313ro_uble
rulable9310533rulable
sable74732163__sable
salable91415463salable
salvable1338403salvable
saveable1339003saveable
sayable121411613sayable
seeable91113943seeable
servable13310093servable
sewable121911173sewable
shavable16177273shavable
showable1636583showable
sizable1839893sizable
skiable1338883skiable
slakable14177553slakable
slayable13157563slayable
slidable1137953slidable
smokable1636223smokable
sociable1239503sociable
soluble966103soluble
sorbable1239303sorbable
sortable10312483sortable
stable83921643_stable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553_suable
table75429603__table
takable13310193takable
tamable11312853tamable
taxable1639073taxable
tenable93214493tenable
toteable1048353toteable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unlivable1447603unlivable
unmovable1645963unmovable
unviable1338703unviable
usable84012553_usable
useable9911063useable
vale74937343__va_le
viable111613773_viable
violable1337543violable
vocables15145733vocables
vocably17157153vocably
voidable1466853voidable
voluble1244503voluble
voteable1347213voteable
wadable13310233wadable
waxable1937673waxable
wirable121610963wirable
wobble133212313wo_bble
workable1737093workable

Search took 8 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.403443402.0
2DLD Change Limit1340272726.73619897.1
3Display Results2722720.1102472.7
 (SQL Overall)1786912727.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.