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 “amiableness” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
amiableness154716(None) 
amicableness1856161amicableness
admirableness1855142admirableness
amiablenesses1756532amiablenesses
damnableness1755242damnableness
pliableness1546602pliableness
variableness1756432variableness
adorableness1556043adorableness
advisableness1954413advisableness
agileness1046493agi__leness
amicablenesses2055213amicablenesses
ampleness1345303am__pleness
availableness1854253availableness
capableness1745883capableness
curableness1547313curableness
durableness1446713durableness
edibleness1345293edi_bleness
enviableness1756993enviableness
equableness22146123equableness
habitableness2054813habitableness
laudableness1554733laudableness
likableness1755333likableness
livableness1645913livableness
losableness1346033losableness
lovableness1645593lovableness
maleness10312313_m_a_leness
movableness1855733movableness
nimbleness1445593_nimbleness
notableness1347623notableness
pitiableness1655523pitiableness
potableness1547193potableness
reliableness1457133reliableness
sizableness2265593sizableness
sociableness1655753sociableness
stableness1248823_stableness
suitableness1456303suitableness
tenableness1347403tenableness
tunableness1345953tunableness
usableness1246503_usableness
valuableness1754783valuableness
voidableness1854943voidableness
admirablenesses2074354admirablenesses
agreeableness1654104agreeableness
alikeness1336334ali__keness
aliveness1238224ali__veness
amanuenses1251974am_anuenses
amativeness1646224amativeness
amiable11312034amiabl__e__
amylenes13105704am__ylene_s
anablepses1482604a_nablepses
animateness1355694animateness
awareness1236344a_wa_reness
brittleness1353734brittleness
charitableness2163924charitableness
culpableness1853964culpableness
damnablenesses1954614damnablenesses
desirableness1666954desirableness
doubleness1345784_doubleness
equitableness24105474equitableness
estimableness1754754estimableness
excitableness2455394excitableness
facileness1545504faci__leness
favorableness2154554favorableness
feebleness1544894_feebleness
femaleness1545764fema_leness
fickleness1943664_fickleness
formidableness2263084formidableness
haleness11312624__ha_leness
humbleness1744624_humbleness
idleness936844__i_dleness
ignobleness1453444ignobleness
imaginableness1963944imaginableness
immovableness2254434immovableness
immutableness1955034immutableness
inimitableness1864994inimitableness
insatiableness1655034insatiableness
irritableness1576134irritableness
lamentableness1863584lamentableness
laughableness1963114laughableness
littleness1045024_littleness
manliness111310124_m_anliness
mealiness11310064_mea_liness
memorableness1955634memorableness
mildness1136524_mi__ldness
minuteness1245294_minuteness
miserableness17145754_miserableness
nobleness1147524__nobleness
palatableness1754644palatableness
paleness10312984__pa_leness
peaceableness1955284peaceableness
pliablenesses1756074pliablenesses
provableness1955514provableness
readableness1576264readableness
removableness2054854removableness
simpleness1445174_simpleness
singleness1145734_singleness
smallness1174514sm_a_llness
smileless1134694smi__leless
staleness9310784_sta_leness
tableless1145034__tableless
tangibleness1553704tangibleness
teachableness2054714teachableness
terminableness1864484terminableness
thinkableness2253324thinkableness
tractableness1755034tractableness
unstableness1457124unstableness
variablenesses1965494variablenesses
veritableness1856514veritableness
vileness1139984_vi__leness
violableness1754884violableness
visibleness1654814visibleness
volubleness1653694volubleness
workableness2154394workableness

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191137.93618752.4
3Display Results1131130.0631793.7
 (SQL Overall)1786911138.42221217.2
 
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.