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

158 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
atonable103879(None) 
atoneable1145851atoneable
stonable1039841stonable
actionable14116212actionable
adorable1138772adorable
amenable1238862amenable
atonal6514022atona_l_
atonally1148632atonally
avowable1635452avowable
detonable1247622detonable
storable10310732storable
stowable1337612stowable
tannable1039382tannable
tenable93214492_tenable
totable92313362_totable
towable121910112_towable
tunable92511312_tunable
abatable1238023abatable
abominable1643143abominable
abrogable1444573abrogable
abusable1236373abusable
actable11313473a_ctable
actionably17105513actionably
addable11218843a_ddable
adoptable1444753adoptable
adorably1446443adorably
affable15117403a_ffable
agitable1138583agitable
agonal7410053agona_l_
alienable1146933alienable
alliable1038433alliable
allocable1345633allocable
allowable1444953allowable
alterable1149163alterable
amenably1546513amenably
amendable1446053amendable
amiable11312033a_miable
amicable1438433amicable
amusable1237143amusable
apposable1545603apposable
arable81821003a__rable
arguable1135903arguable
arousable1145573arousable
atingle848253atin_gle
atone56527983aton___e
atremble1244113atremble
attainable1243743attainable
avoidable15124743avoidable
avowably1944003avowably
axonal1347653axona_l_
azonal1568273azona_l_
bannable1278353bannable
bondable13169273_bondable
bookable16127003bookable
bootable12179223bootable
burnable1237263burnable
canoeable1347103canoeable
catchable1845713catchable
closable12168003closable
codable12311663_codable
coinable12311583coinable
cookable16147973cookable
damnable1347593damnable
datable101714233dat__able
dateable1149443dat_eable
doable93115243_do_able
dowable13189453_dowable
eatable91717603eat__able
enable83318483__enable
erodable1139203erodable
evocable1537103evocable
exorable1738933exorable
factorable1743573factorable
fathomable2052103fathomable
fatigable1544863fatigable
favorable1744583favorable
finable122213623_finable
gainable1138933gainable
growable1435623growable
hatable121713963hat__able
hatchable1944793hatchable
hateable1339373hat_eable
isolable1038793isolable
joinable1737283joinable
knowable1745043knowable
laminable1337123laminable
lienable10188693lienable
linable92214343_linable
loanable1037613loanable
losable91910953_losable
lovable12179553_lovable
matchable1845463matchable
minable112315073_minable
movable14189433_movable
notable92114903_notable
openable1247013openable
ownable1237283_ownable
pardonable1544023pardonable
parolable1347113parolable
patchable1845633patchable
patentable1444933patentable
pawnable1535983pawnable
plowable1535913plowable
pokable15209503_pokable
posable112212783_posable
potable112115363_potable
probable1439053probable
provable1539093provable
prunable1237843prunable
quotable1936493quotable
ratable91717553rat__able
rateable10311443rat_eable
rationale949463rationa_le
reasonable1246283reasonable
ropable111611333_ropable
rowable121510303_rowable
ruinable1039263ruinable
satiable10310733sat_iable
saturable1146633saturable
seasonable1244933seasonable
showable1636583showable
smokable1636223smokable
sowable121610753_sowable
stable83921643st__able
stainable1138093stainable
statable10310703statable
stewable1337133stewable
stoppable1544103stoppable
storables1146283storables
table75429603_t__able
takable13310193_takable
takeable1437463takeable
talkable1437193talkable
tamable11312853_tamable
tameable1238603tameable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073_taxable
tenably122210453_tenably
tonal53724303_tona_l_
tonally10311373_tonally
toteable1048353_toteable
triable92515393_triable
tunably12218293_tunably
tuneable1038913_tuneable
turnable1037853turnable
typable1435883_typable
unable83819223__unable
untenable11410503untenable
untunable1147833untunable
vaporable1645543vaporable
violable1337543violable
vocable14189673_vocable
votable122111373_votable
voteable1347213voteable
watchable1944773watchable
winnable13156983winnable

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621586.53022383.2
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.01625469.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.