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

290 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
livable12201032(None) 
liable81415811li_able
likable13219411likable
linable92214341linable
liveable13177661liveable
lovable12179551lovable
bitable11312202bitable
citable11313462citable
disable10516432disable
drivable1438022drivable
finable122213622finable
fixable19218192fixable
giveable14155752giveable
hidable1399402hidable
hirable121612312hirable
leviable1337512leviable
lienable10188692lienable
liftable1376862liftable
likeable14166472likeable
lineable101811082lineable
linkable14187262linkable
listable10810302listable
losable91910952losable
lovably15187062lovably
loveable13187902loveable
minable112315072minable
mixable18259172mixable
movable14189432movable
pliable111610322pli_able
relivable1438512relivable
ridable101412492ridable
savable121711862savable
sizable1839892sizable
slidable1137952slidable
unlivable1447602unlivable
viable111613772vi_able
wirable121610962wirable
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
agitable1138583agitable
alible8311973ali__ble
alienable1146933alienable
alliable1038433alliable
amiable11312033amiable
amicable1438433amicable
arable81821003_arable
bailable1238583bailable
believable1742723believable
bible95119423bi__ble
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
bivalve1543593bivalve
blamable1436693blamable
boilable1237793boilable
bribable1137223bribable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cicale10314503cica_le
citeable1238413citeable
claimable1545703claimable
cleavable1644473cleavable
clickable1944303clickable
climbable1743603climbable
clippable1773463clippable
closable12168003closable
clubable1436093clubable
codable12311663codable
coinable12311583coinable
cultivable1743833cultivable
curable112414513curable
datable101714233datable
derivable1548063derivable
dibble114013843di_bble
dimmable1536113dimmable
dippable1536123dippable
disabled1248713disabled
disabler1147913disabler
disables11410903disables
dividable1645003dividable
doable93115243_doable
dowable13189453dowable
driveable1544523driveable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
editable11310423editable
effable15106673effable
elidible1164573elidible
eligible11114693eligible
enable83318483_enable
enviable1337853enviable
equable1849253equable
errable9312183errable
evitable1339323evitable
exilable1737203exilable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
fileable13179223fileable
fillable13179563fillable
filmable15157133filmable
fimble133611753fi_mble
finagle11238313finagle
finale94116763fina_le
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fittable1337083fittable
flickable2043983flickable
flyable15307123flyable
foilable1338063foilable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gainable1138933gainable
gelable101710733gelable
getable101712553getable
giftable1465893giftable
guidable1236203guidable
hatable121713963hatable
hewable15177823hewable
hireable13139083hireable
hittable1336843hittable
imitable1239123imitable
inviable1338523inviable
jailable1737143jailable
joinable1737283joinable
kibble143910953ki_bble
kickable1535583kickable
killable14168133killable
kissable1436853kissable
label75019383l__abel
labile8315223l__abile
ladle66320443l__adle
laminable1337123laminable
lapsable12117383lapsable
laudable1137893laudable
lavabo1135273lavab_o
lavaboes1344433lavaboes
lavabos1235453lavabos
lavage1038263lava_ge
leasable101510133leasable
legible1035833legible
lendable11169463lendable
liaise6310693li_aise
liane54720663li_a_ne
libel74116103li__bel
ligase7259913liga_se
ligate72519243liga_te
ligule74010833li_gule
limbate1139213limbate
limitable1345643limitable
linage7713403lina_ge
lipase8239103lipa_se
lisle53916723li__sle
litigable1244213litigable
little63312163li_ttle
live76540993liv___e
lively123310813liv_ely
lividly1434783lividly
livre85613253liv__re
loanable1037613loanable
locale83915653loca_le
lockable1636953lockable
lovage1037353lova_ge
loveably16175233loveably
mailable1239623mailable
makable15510203makable
millable121710133millable
mineable121611053mineable
miracle1138843miracle
missable12311533missable
mixible18195093mixible
movables15175573movables
movably17167043movably
moveable15168013moveable
mutable11312303mutable
namable11312333namable
nibble103713283ni_bble
nimble103412943ni_mble
nival84915773niva_l_
notable92114903notable
obligable1444383obligable
obviable1543863obviable
ownable1237283ownable
oxidable1865123oxidable
parable111819773parable
payable141711323payable
pitiable1238293pitiable
pivotable1644563pivotable
placable14169243placable
playable15137923playable
pliably14147383pli_ably
plowable1535913plowable
pokable15209503pokable
posable112212783posable
potable112115363potable
provable1539093provable
raisable10311643raisable
ratable91717553ratable
reliable10313073reli_able
relievable1544663relievable
retable91820403retable
revivable1736863revivable
rideable1158653rideable
rinsable10310033rinsable
rippable1435383rippable
risible937923risible
rivage1038843riva_ge
rival85216503riva_l_
rivaled1138933riva_led
rivalled1236093rivalled
rivals94213183riva_ls
ropable111611333ropable
rowable121510303rowable
ruinable1039263ruinable
rulable9310533rulable
sable74732163__sable
sailable10310563sailable
salable91415463salable
salvable1338403salvable
saveable1339003saveable
sayable121411613sayable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
servable13310083servable
sewable121911173sewable
shavable16177273shavable
singable11159533singable
sinkable14178413sinkable
sizably2136613sizably
sizeable1937113sizeable
skiable1338883skiable
slakable14177553slakable
slayable13157563slayable
sliceable1345443sliceable
solvable1337473solvable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
suitable10310893suitable
table75429603__table
takable13310193takable
tamable11312843tamable
taxable1639073taxable
tenable93214493tenable
tillable10159753tillable
tiltable10159013tiltable
timbale11248803timbale
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unlikable1546773unlikable
unlovable1446363unlovable
unviable1338703unviable
usable84012553_usable
useable9911063useable
vale74937343__va_le
viably14199833vi_ably
viewable1635223viewable
violable1337543violable
visible1236923visible
vitiable1337503vitiable
vivace1436553viva_ce
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wadable13310233wadable
waxable1937673waxable
willable13168683willable
wimble133211923wi_mble
windable14159153windable
winnable13156983winnable
writable1338753writable

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.1601116818.8
2DLD Change Limit1340272907.09318895.7
3Display Results2902900.1062735.8
 (SQL Overall)1786912907.35924282.0
 
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.