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

333 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
amiable1131203(None) 
amiably1438301amiably
amicable1438431amicable
actable11313472actable
addable11218842addable
admirable1445432admirable
affable15117402affable
agitable1138582agitable
alible8311972ali_ble
alliable1038432alliable
amble95924642am__ble
amenable1238862amenable
amicably1746332amicably
amusable1237142amusable
arable81821002a_rable
damnable1347592damnable
friable122612562friable
imitable1239122imitable
jammable2144512jammable
laminable1337122laminable
liable81415812_liable
mailable1239622mailable
makable15510202makable
minable112315072_minable
mixable18259172_mixable
namable11312342nam_able
nameable1238862nameable
pliable111610322pliable
radiable11611302radiable
satiable10310732satiable
skiable1338882skiable
tamable11312852tam_able
tameable1238602tameable
triable92515392triable
unamiable1348472unamiable
variable13310062variable
viable111613772_viable
abatable1238023abatable
abdicable1685023abdicable
able66340533___able
abominable1643143abominable
abubble1044523abubble
abusable1236373abusable
addible11236063addible
admirably1743883admirably
adorable1138773adorable
advisable1544573advisable
affably1855183affably
affixable2443343affixable
agile65122263agi__le
aisle55223193a_i_sle
alienable1146933alienable
amassable1346063amassable
amaze166016603am_a_ze
ambage11510603amba_ge
ambiance1446063ambiance
ambled115116373am__bled
ambler104916453am__bler
ambles105121863am__bles
amebae1049633am_ebae
amenably1546513amenably
amendable1446053amendable
amerciable1653743amerciable
amia66836903amia___
amias75831473amia__s
amice96122873ami__ce
amidase1036733amidase
amide86128483ami__de
amidine103613853amidine
amidol9489573amidol_
amidols10457563amidols
amidone10349313amidone
amie66339853ami___e
amine75835383ami__ne
amirate91115953amirate
amitrole1045173amitrole
amoebae1145533amoebae
amole75724593am__ole
ample94720303am__ple
ampoule11116603ampoule
ampule10710613am_pule
anile54634463ani__le
anisole71010833anisole
appliable1545053appliable
arables91814973a_rables
arguable1135903arguable
atingle848253atingle
atonable1038793atonable
audible10228243audible
auditable1245993auditable
available1444903available
aviate9315203avia_te
avoidable15124743avoidable
avowable1635453avowable
axial124515193axia_l_
axially1737233axially
axile126020513axi__le
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bible95119423_bi_ble
bitable11312203bitable
blamable1436693blam_able
blameable1544723blameable
boilable1237793boilable
bombable1336263bombable
bribable1137223bribable
buyable1437493buyable
cable95329913__cable
callable12310753callable
camisole1246173camisole
capable13313363capable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
citable11313463citable
claimable1545703claimable
codable12311663codable
coinable12311583coinable
curable112414513curable
damnably1645113damnably
datable101714233datable
dateable1149443dateable
demisable1448533demisable
deniable11312083deniable
dibble114013843_dibble
dimmable1536113dimmable
disable10516433disable
doable93115243_doable
dowable13189453dowable
dribble12368603dribble
drivable1438023drivable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dutiable1137373dutiable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
edible969353edi_ble
editable11310423editable
effable15106673effable
empale102611263empa_le
emptiable1544843emptiable
enable83318483_enable
enviable1337853enviable
equable1849253equable
errable9312183errable
evitable1339323evitable
examinable2144093examinable
exilable1737203exilable
expiable1946113expiable
eyeable1239063eyeable
fable105824753__fable
faceable15108493faceable
fadable13310463fadable
farmable1538203farmable
fatigable1544863fatigable
fimble133611753_fimble
finable122213623finable
fixable19218193fixable
flammable1844173flammable
flyable15307123flyable
foamable1537043foam_able
foible11410383foi_ble
foilable1338063foilable
framable1537573fram_able
frameable1645353frameable
fribble14287783fribble
fryable15277463fryable
gable85325523__gable
gainable1138933gainable
gamble115417183gam__ble
gelable101710733gelable
getable101712553getable
gribble12297273gribble
guidable1236203guidable
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hatable121713963hatable
hateable1339373hateable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hummable1744583hummable
impale102811663impa_le
inviable1338523inviable
jailable1737143jailable
joinable1737283joinable
jumpable2143953jumpable
kibble143910953_kibble
lamiae84817453lamia__e
lapsable12117383lapsable
laudable1137893laudable
leviable1337513leviable
likable13219413likable
limitable1345643limitable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
mabe85733363_m_ab_e
macabre1335223macabre
macle96127003_m_acle
maile75232223_m_aile
makeable1637253makeable
male66052303_m_a_le
manacle11310283manacle
maple95521143_m_aple
mappable1635923mappable
marble104219103_marble
maskable1638003maskable
measle83513223_measle
miaul71612123_miaul_
miauled1036663_miauled
miauls8178713_miauls
mickle143715133_mickle
middle103414983_middle
miggle104012113_miggle
mile66352573_mi__le
millable121710133_millable
mille75029133_mi_lle
mineable121611053_mineable
mingle93518783_mingle
miracle1138843_miracle
missable12311533_missable
mixible18195093_mixible
mizzle16279993_mizzle
movable14189433movable
mumble123614343_mumble
mutable11312303mutable
navigable1544743navigable
nibble103713283_nibble
nimble103412943_nimble
notable92114903notable
obviable1543863obviable
ownable1237283ownable
oxidable1865123oxidable
packable1838633packable
palpable1448033palpable
parable111819773parable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323payable
pitiable1238293pitiable
pliably14147383pliably
pokable15209503pokable
posable112212783posable
potable112115363potable
quibble2034713quibble
radiale83813523radia_le
raisable10311643raisable
ramble104519973ram__ble
ratable91717553ratable
rateable10311443rateable
reliable10313073reliable
retable91820403retable
ridable101412493ridable
ropable111611333ropable
rowable121510303rowable
ruinable1039263ruinable
rulable9310533rulable
sable74732163__sable
sailable10310563sailable
salable91415463salable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiably1337823satiably
savable121711863savable
saveable1339003saveable
sayable121411613sayable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sewable121911173sewable
shamable15168803sham_able
shameable1645573shameable
sizable1839893sizable
slidable1137953slidable
smile74823923smi__le
smokable1636223smokable
sociable1239503sociable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
suitable10310893suitable
summable1436903summable
table75429603__table
takable13310193takable
takeable1437463takeable
talkable1437193talkable
tamale83717403tam_a_le
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073taxable
tenable93214493tenable
thimble1435873thimble
timbale11248803timbale
totable92313363totable
towable121910113towable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unmixable2045863unmixable
unviable1338703unviable
usable84012553_usable
useable9911063useable
valuable1336863valuable
variables1444673variables
variably1637433variably
viably14199833_viably
vitiable1337503vitiable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wadable13310233wadable
wadeable1437443wadeable
walkable1736063walkable
wamble134415753wam__ble
washable16138043washable
wastable131410453wastable
waxable1937673waxable
wimble133211923_wimble
wirable121610963wirable
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.423422437.4
2DLD Change Limit1340273336.59320328.7
3Display Results3333330.1262642.9
 (SQL Overall)1786913337.14225019.7
 
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.