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

150 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
quotable193649(None) 
quotably2244151quotably
bootable12179222bootable
cuttable1247952cuttable
equatable2045192equatable
equitable2046192equitable
gustable11138202gustable
huntable1338092huntable
mutable11312302mu_table
notable92114902_notable
potable112115362_potable
rustable101511362rustable
suitable10310892suitable
totable92313362_totable
votable122111372_votable
abatable1238023abatable
actable11313473_actable
adoptable1444753adoptable
adorable1138773adorable
agitable1138583agitable
atonable1038793atonable
auditable1245993auditable
avowable1635453avowable
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bookable16127003bookable
buffable1844393buffable
burnable1237263burnable
buyable1437493bu_yable
cartable121314093cartable
castable121613973castable
citable11313463_citable
closable12168003closable
codable12311663_codable
cookable16147973cookable
countable1348853countable
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
datable101714233_datable
denotable1238373denotable
doable93115243_do_able
doubtable1445163doubtable
dowable13189453_dowable
dubitable1445093dubitable
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
eatable91717603_eatable
editable11310423editable
equable1849253equ__able
equitably2344423equitably
erodable1139203erodable
evitable1339323evitable
evocable1537103evocable
exorable1738933exorable
fittable1337093fittable
floatable1444983floatable
furlable1335893furlable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
growable1435623growable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
hatable121713963_hatable
heatable131612043heatable
hittable1336853hittable
huggable1543333huggable
hummable1744583hummable
imitable1239123imitable
instable10313203instable
isolable1038793isolable
jumpable2143953jumpable
knowable1745043knowable
liftable1376863liftable
listable10810313listable
losable91910953_losable
lovable12179553_lovable
meltable12310473meltable
mountable1346303mountable
movable14189433_movable
mutably1438613mu_tably
nestable101613673nestable
nettable101610243nettable
notables10178243_notables
notably12199993_notably
outfable1378813outfable
pettable121710713pettable
pivotable1644563pivotable
plowable1535913plowable
pokable15209503_pokable
portable12313203portable
posable112212783_posable
potables12179703_potables
pourable1239133pourable
probable1439053probable
provable1539093provable
quale143617853qu__a_le
quellable2043673quellable
quibble2034713qu_ibble
quota145111963quota___
quotas15339433quota__s
quote143714773quot___e
ratable91717553_ratable
rentable101716333rentable
restable101618443restable
retable91820403_retable
ropable111611333_ropable
rowable121510303_rowable
ruinable1039263ruinable
rulable9310533ru_lable
showable1636583showable
smokable1636223smokable
sortable10312483sortable
sowable121610753_sowable
spottable1345343spottable
stable83921643__stable
statable10310703statable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553su__able
suitably1347593suitably
summable1436903summable
surfable1338443surfable
table75429603___table
tastable101511973tastable
testable101412623testable
tiltable10159013tiltable
toteable1048353_toteable
towable121910113_towable
trustable1147123trustable
tubbable1134683tubbable
tunable92511313tu_nable
tuneable1038913tuneable
turnable1037853turnable
turntable1144983turntable
unable83819223_u_nable
unstable10313763unstable
usable84012553_u_sable
useable9911063_useable
violable1337543violable
vocable14189673_vocable
voteable1347213_voteable
wastable131410453wastable
wettable13148043wettable
writable1338753writable

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.423422437.4
2DLD Change Limit1461621507.68619016.7
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.17221866.3
 
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.