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

269 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
movable1418943(None) 
lovable12179551lovable
movables15175571movables
movably17167041movably
moveable15168011moveable
codable12311662codable
doable93115242do_able
dowable13189452dowable
immovable1844412immovable
livable122010322livable
losable91910952losable
lovably15187062lovably
loveable13187902loveable
makable15510202makable
minable112315072minable
mixable18259172mixable
mockable1846642mockable
moldable1337102moldable
morale85220552mora_le
moveables16163962moveables
moveably18175542moveably
mutable11312302mutable
notable92114902notable
pokable15209502pokable
posable112212782posable
potable112115362potable
provable1539092provable
removable1646922removable
ropable111611332ropable
rowable121510302rowable
savable121711862savable
smokable1636222smokable
solvable1337472solvable
sowable121610752sowable
totable92313362totable
towable121910112towable
unmovable1645962unmovable
vocable14189672vocable
votable122111372votable
able66340533___able
actable11313473actable
addable11218843addable
adorable1138773adorable
affable15117403affable
amenable1238863amenable
amiable11312033amiable
amicable1438433amicable
amusable1237143amusable
arable81821003_arable
atonable1038793atonable
avowable1635453avowable
bitable11312203bitable
boatable121610263boatable
bobble94115143bo_bble
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
bootable12179223bootable
buyable1437493buyable
cable95329913__cable
capable13313363capable
citable11313463citable
closable12168003closable
cobble123615263co_bble
coble94823173co__ble
coinable12311583coinable
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
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
imitable1239123imitable
immovables1952623immovables
immovably2143623immovably
imposable1546443imposable
improvable1945253improvable
inviable1338523inviable
isolable1038793isolable
joinable1737283joinable
knowable1745033knowable
leviable1337513leviable
liable81415813_liable
likable13219413likable
linable92214343linable
liveable13177663liveable
loanable1037613loanable
locale83915653loca_le
lockable1636953lockable
lovage1037353lova_ge
loveably16175233loveably
mabe85733353m__ab_e
macabre1335223macabre
macle96127003m__acle
mailable1239623mailable
maile75232223m__aile
makeable1637253makeable
male66052293m__a_le
manacle11310283manacle
maple95521143m__aple
mappable1635923mappable
marble104219103m_arble
maskable1638003maskable
measle83513223m_easle
meltable12310473meltable
memorable1547533memorable
mendable131510583mendable
millable121710133millable
mineable121611053mineable
miracle1138843miracle
missable12311533missable
mixible18195093mixible
mobile103613543mo_bile
mobled113213183mo__bled
modal85919233moda_l_
modally1338393modally
modals93914443moda_ls
module93011033mo_dule
molal75120343mola_l_
mole66251833mo___le
monocle1139663monocle
morae75831193mora__e
moraine9314573moraine
moral75533433mora_l_
morales93619403mora_les
morally12411493morally
morals85324633mora_ls
morelle91210803morelle
motile83818343mo_tile
mottle84116053mo_ttle
mouille937843mouille
mountable1346303mountable
move96630723mov___e
movie105319133mov__ie
moviola1244823moviola
mumble123614343m_umble
mutably1438613mutably
namable11312333namable
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
parable111819773parable
payable141711323payable
pliable111610323pliable
plowable1535913plowable
portable12313203portable
potables12179703potables
pourable1239133pourable
probable1439053probable
provably1846213provably
quotable1936493quotable
ratable91717553ratable
removably1944783removably
removeable1744223removeable
retable91820403retable
ridable101412493ridable
roble75223023ro__ble
rockable1638013rockable
rouble83913313ro_uble
rulable9310533rulable
sable74732163__sable
salable91415463salable
salvable1338403salvable
saveable1339003saveable
sayable121411613sayable
seeable91113943seeable
servable13310083servable
sewable121911173sewable
shavable16177273shavable
showable1636583showable
sizable1839893sizable
skiable1338883skiable
smokeable1743853smokeable
sociable1239503sociable
soluble966103soluble
sorbable1239303sorbable
sortable10312483sortable
stable83921643_stable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553_suable
table75429603__table
takable13310193takable
tamable11312843tamable
taxable1639073taxable
tenable93214493tenable
toteable1048353toteable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unlovable1446363unlovable
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.1561145455.1
2DLD Change Limit1340272697.34318252.3
3Display Results2692690.1102445.5
 (SQL Overall)1786912697.60923484.2
 
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.