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

147 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
amenable123886(None) 
amenably1546511amenably
amendable1446051amendable
alienable1146932alienable
amiable11312032am_iable
amicable1438432amicable
amusable1237142amusable
atonable1038792atonable
damnable1347592dam_nable
emendable1446232emendable
enable83318482__enable
lamentable1444202lamentable
laminable1337122laminable
lienable10188692lienable
mendable131510582_mendable
minable112315072_minable
nameable1238862name_able
openable1247012openable
tameable1238602tame_able
tenable93214492_tenable
unamenable1446942unamenable
abatable1238023abatable
abominable1643143abominable
abusable1236373abusable
actable11313473a_ctable
addable11218843a_ddable
adherable1545003adherable
admirable1445433admirable
adorable1138773adorable
affable15117403a_ffable
agitable1138583agitable
agreeable1244653agreeable
alliable1038433alliable
alterable1149163alterable
amassable1346063amassable
amble95924643am___ble
amebae1049633ame__bae
amerciable1653743amerciable
amesace1147733amesa_ce
amiably1438303am_iably
amicably1746333amicably
arable81821003a__rable
arguable1135903arguable
ascendable1543983ascendable
atoneable1145853atoneable
averrable14105413averrable
avertable14117343avertable
avowable1635453avowable
bannable1278353bannable
bendable131510853_bendable
blameable1544723blame_able
burnable1237263burnable
cenacle1139123_cenacle
chewable1835443chewable
cleanable1345203cleanable
coinable12311583coinable
damnably1645113dam_nably
dateable1149443date_able
deniable11312083_deniable
disenable1249673disenable
dyeable1337303dye_able
enabled102510633__enabled
enabler9299363__enabler
enables92813123__enables
examinable2144093examinable
eyeable1239063eye_able
faceable15108493face_able
feedable1437673feedable
fenagle11197153_fenagle
finable122213623_finable
fineable131810333fineable
frameable1645353frame_able
gainable1138933gainable
gelable101710733_gelable
getable101712553_getable
gleanable1244083gleanable
hateable1339373hate_able
hewable15177823_hewable
imitable1239123imitable
jammable2144513jam_mable
joinable1737283joinable
keepable1635323keepable
labelable1344393labelable
lacerable1346943lacerable
lamentably1743713lamentably
lendable11169463_lendable
linable92214343_linable
lineable101811083lineable
loanable1037613loanable
mailable1239623mailable
makable15510203_makable
makeable1637253makeable
manacle11310283_manacle
mappable1635923mappable
maskable1638003maskable
measle83513223_me_asle
meltable12310473_meltable
menace103216943_mena_ce
menage93216543_mena_ge
mineable121611053_mineable
mixable18259173_mixable
movable14189433_movable
mutable11312303_mutable
namable11312343nam__able
numerable1347623numerable
obeyable1544113obeyable
operable12410323operable
overable13513573overable
ownable1237283_ownable
patentable1444933patentable
pawnable1535983pawnable
peelable1238553peelable
pregnable1456693pregnable
prunable1237843prunable
rateable10311443rate_able
reefable1339533reefable
reelable10311593reelable
rentable101716333_rentable
retable91820403_retable
ruinable1039263ruinable
saleable10312023sale_able
saveable1339003save_able
seeable91113943_seeable
sendable111612043_sendable
sewable121911173_sewable
shameable1645573shame_able
shedable1437423shedable
smokable1636223smokable
spendable1446463spendable
stewable1337133stewable
stonable1039843stonable
takeable1437463take_able
tamable11312853tam__able
tannable1039383tannable
tapeable1238823tape_able
tenably122210453_tenably
timetable1346873timetable
tunable92511313_tunable
tuneable1038913tuneable
turnable1037853turnable
unable83819223__unable
untenable11410503untenable
useable9911063use_able
vendable14159693_vendable
viewable1635223viewable
wadeable1437443wade_able
winnable13156983winnable

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621477.64019131.2
3Display Results1471470.0502940.0
 (SQL Overall)1786911478.09622071.5
 
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.