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

273 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
likable1321941(None) 
liable81415811li_able
likeable14166471likeable
linable92214341linable
linkable14187261linkable
livable122010321livable
bitable11312202bitable
citable11313462citable
clickable1944302clickable
disable10516432disable
finable122213622finable
fixable19218192fixable
flickable2043982flickable
hidable1399402hidable
hirable121612312hirable
kickable1535582kickable
lienable10188692lienable
liftable1376862liftable
lineable101811082lineable
listable10810312listable
liveable13177662liveable
lockable1636952lockable
losable91910952losable
lovable12179552lovable
makable15510202makable
minable112315072minable
mixable18259172mixable
pliable111610322pli_able
pokable15209502pokable
ridable101412492ridable
sinkable14178412sinkable
sizable1839892sizable
skiable1338882skiable
slakable14177552slakable
slidable1137952slidable
takable13310192takable
unlikable1546772unlikable
viable111613772vi_able
wirable121610962wirable
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
agitable1138583agitable
alible8311973ali__ble
alienable1146933alienable
alliable1038433alliable
amiable11312033amiable
amicable1438433amicable
arable81821003_arable
bailable1238583bailable
bankable1677913bankable
bible95119423bi__ble
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
blamable1436693blamable
blockable1944303blockable
boilable1237793boilable
bookable16127003bookable
bribable1137223bribable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cicale10314503cica_le
citeable1238413citeable
claimable1545703claimable
climbable1743603climbable
clippable1773463clippable
closable12168003closable
clubable1436093clubable
codable12311663codable
coinable12311583coinable
cookable16147973cookable
curable112414513curable
datable101714233datable
dibble114013843di_bble
dimmable1536113dimmable
dippable1536123dippable
disabled1248713disabled
disabler1147913disabler
disables11410903disables
dislikable1744323dislikable
doable93115243_doable
dowable13189453dowable
drinkable1644113drinkable
drivable1438023drivable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
editable11310423editable
effable15106673effable
elidible1164573elidible
eligible11114693eligible
enable83318483_enable
equable1849253equable
errable9312183errable
evitable1339323evitable
exilable1737203exilable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
fimble133611753fi_mble
finagle11238313finagle
finale94116763fina_le
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fittable1337093fittable
flyable15307123flyable
foilable1338063foilable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gainable1138933gainable
gelable101710733gelable
getable101712553getable
giftable1465893giftable
giveable14155753giveable
guidable1236203guidable
hackable1937473hackable
hatable121713963hatable
hewable15177823hewable
hireable13139083hireable
hittable1336853hittable
imitable1239123imitable
jailable1737143jailable
joinable1737283joinable
kale86533753__ka_le
kibble143910953ki_bble
killable14168133killable
kissable1436853kissable
label75019383l__abel
labile8315223l__abile
ladle66320443l__adle
laminable1337123laminable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leasable
legible1035833legible
lendable11169463lendable
leviable1337513leviable
liaise6310693li_aise
liane54720663li_a_ne
libel74116103li__bel
ligase7259913liga_se
ligate72519253liga_te
ligule74010833li_gule
like86040843lik___e
likely13328133lik_ely
limbate1139213limbate
limitable1345643limitable
linage7713403lina_ge
linkage1295963linka_ge
lipase8239103lipa_se
lisle53916723li__sle
litigable1244223litigable
little63312163li_ttle
loanable1037613loanable
locale83915653loca_le
lovably15187063lovably
loveable13187903loveable
mailable1239623mailable
makeable1637253makeable
maskable1638003maskable
millable121710133millable
mineable121611053mineable
miracle1138843miracle
missable12311533missable
mixible18195093mixible
mockable1846643mockable
movable14189433movable
mutable11312303mutable
namable11312343namable
nibble103713283ni_bble
nimble103412943ni_mble
notable92114903notable
obligable1444383obligable
ownable1237283ownable
oxidable1865123oxidable
packable1838633packable
parable111819773parable
payable141711323payable
pikake11115803pika_ke
pitiable1238293pitiable
placable14169243placable
playable15137923playable
pliably14147383pli_ably
plowable1535913plowable
posable112212783posable
potable112115363potable
raisable10311643raisable
ratable91717553ratable
reliable10313073reli_able
relivable1438513relivable
retable91820403retable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923risible
rockable1638013rockable
ropable111611333ropable
rowable121510303rowable
ruinable1039263ruinable
rulable9310533rulable
sable74732163__sable
sailable10310563sailable
salable91415463salable
savable121711863savable
sayable121411613sayable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sewable121911173sewable
shakable17177683shakable
singable11159543singable
sizably2136613sizably
sizeable1937113sizeable
slayable13157563slayable
sliceable1345443sliceable
smokable1636223smokable
sowable121610753sowable
stable83921643_stable
stickable1745543stickable
suable83920553_suable
suitable10310893suitable
table75429603__table
takeable1437463takeable
talkable1437193talkable
tamable11312853tamable
taxable1639073taxable
tenable93214493tenable
thinkable1844063thinkable
tillable10159753tillable
tiltable10159013tiltable
timbale11248803timbale
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unlivable1447603unlivable
usable84012553_usable
useable9911063useable
viably14199833vi_ably
viewable1635223viewable
violable1337543violable
visible1236923visible
vitiable1337503vitiable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wadable13310233wadable
walkable1736063walkable
waxable1937673waxable
willable13168683willable
wimble133211923wi_mble
windable14159153windable
winnable13156983winnable
workable1737093workable
writable1338753writable

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.1431249587.4
2DLD Change Limit1340272736.50020619.5
3Display Results2732730.1102481.8
 (SQL Overall)1786912736.75326461.0
 
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.